1 Reply Latest reply on Nov 6, 2004 11:00 AM by Alexey Loubyansky

    Problem deleting relations

    Javier Pedrido Newbie

      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