Hi 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, Javier View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3854109#3854109 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3854109 ------------------------------------------------------- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
