This content has been marked as final.
Show 3 replies
-
1. Re: CMR and too many parameters in delete sql statement
pvainio Dec 15, 2004 6:06 AM (in response to pvainio)Looks like this is a real problem.
http://cvs.sourceforge.net/viewcvs.py/jboss/jboss/src/main/org/jboss/ejb/plugins/cmp/jdbc/JDBCDeleteRelationsCommand.java?rev=1.10.2.7&view=markup// // This command needs to be changed to chunk delete commands, because // some database have a limit on the number of parameters in a statement. // public void execute(RelationData relationData) {
-
2. Re: CMR and too many parameters in delete sql statement
aloubyansky Dec 16, 2004 3:25 AM (in response to pvainio)I saw your patch. Thanks. If you have time to fix it in a proper way, i.e. expose a configuration parameter that would indicate whether to use limit on the number of rows deleted in a single DELETE statement and what the limit is or do not apply any limit, please, do. Maybe you'll also commit it yourself.
-
3. Re: CMR and too many parameters in delete sql statement
pvainio Dec 16, 2004 12:32 PM (in response to pvainio)Committed a patch.
Since I have no real experience in JBoss internals (or patching it) I hope it is something like you were asking for.
Br,
Pekka