I have two CMP 2.x entity beans that have a m:n relationship (ModelEJB and NodeEJB) and a typical model has thousands of nodes. The problems arrises when I want to delete all the nodes related to a model, the class org.jboss.ejb.plugins.cmp.jdbc.JDBCDeleteRelationsCommand creates a sql command so large that neither Oracle nor MS SqlServer can handle it.
My question is: Is there a way to limit the size of the command generated by this class? If there isn't, how can I delete thousands of relations?
Thanks in advance,
Submit a bug report, please.