1 Reply Latest reply on Sep 30, 2002 1:28 PM by Alexey Loubyansky

    CMR - Many to Many with composite primary keys

    sekhar Newbie

      Hi,
      I am defining a many to many relation ship between 2 entities both having composite primary keys. In addition to it, both having the same fk which is part of their primary keys.

      While writing the relationship in jbosscmp-jdbc.xml file, there are 2 columns each for the relationship-role. out of which one column is same here and there. We have the JOIN TABLE which is created already having only 3 columns.

      now the problem is when we try to insert a new record in join table using CMR.add(Collection), an SQL Exception is thrown indicating column not foung. i looked at the server log, for no surprasise it has 2 + 2 columsn in QUERY with the column name repeted.
      Anyone had faced this proble? support is greatly appreciated -
      Thanks
      Sekhar