[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - deployment problem with CMP (1:n relation)

Hi, im using: - EJB21 - JBoss 4.2.2.GA - Java 1.5.0.14 I have a one-to-many relationship: Customer - Books, very straightforward. I keep getting the following error when i deploy my application: | org.jboss.deployment.DeploymentException: Configuration found in jbosscmp-jdbc.xml for relation Customer-Book but relation is not a jbosscmp-jdbc-managed relation in ejb-jar.xml | When i don't use jbosscmp-jdbc.xml it deploys but the table books doesnt contain a foreign key with the customerid. Is there anyone who can help me with this problem? Here is my ejb-jar.xml | <?xml version="1.0" encoding="UTF-8"?> | | <ejb-jar | xmlns="http://java.sun.com/xml/ns/j2ee" | xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" | xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee | http://java.sun.com/xml/ns/j2ee/ejb-jar_2_1.xsd" | version="2.1"> | | <enterprise-beans> | <entity> | <ejb-name>Book</ejb-name> | <home>BookHome</home> | <remote>Book</remote> | <ejb-class>BookEntity</ejb-class> | <persistence-type>Container</persistence-type> | <prim-key-class>java.lang.Integer</prim-key-class> | <reentrant>false</reentrant> | <cmp-version>2.x</cmp-version> | <abstract-schema-name>Book</abstract-schema-name> | <cmp-field> | <field-name>bookid</field-name> | </cmp-field> | <cmp-field> | <field-name>title</field-name> | </cmp-field> | | <primkey-field>bookid</primkey-field> | </entity> | | <entity> | <ejb-name>Customer</ejb-name> | <home>CustomerHome</home> | <remote>Customer</remote> | <ejb-class>CustomerEntity</ejb-class> | <persistence-type>Container</persistence-type> | <prim-key-class>java.lang.Integer</prim-key-class> | <reentrant>false</reentrant> | <cmp-version>2.x</cmp-version> | <abstract-schema-name>Customer</abstract-schema-name> | <cmp-field> | <field-name>customerid</field-name> | </cmp-field> | <cmp-field> | <field-name>name</field-name> | </cmp-field> | | <primkey-field>customerid</primkey-field> | </entity> | | | <relationships> | <ejb-relation> | <ejb-relation-name>Customer-Book</ejb-relation-name> | | <ejb-relationship-role> | <ejb-relationship-role-name>Book-has-customer</ejb-relationship-role-name> | <multiplicity>Many</multiplicity> | <relationship-role-source> | <ejb-name>BookEntity</ejb-name> | </relationship-role-source> | <cmr-field> | <cmr-field-name>customerid</cmr-field-name> | </cmr-field> | </ejb-relationship-role> | | <ejb-relationship-role> | <ejb-relationship-role-name>Customer-has-books</ejb-relationship-role-name> | <multiplicity>One</multiplicity> | <relationship-role-source> | <ejb-name>CustomerEntity</ejb-name> | </relationship-role-source> | <cmr-field> | <cmr-field-name>books</cmr-field-name> | <cmr-field-type>java.util.Collection</cmr-field-type> | </cmr-field> | </ejb-relationship-role> | </ejb-relation> | </relationships> | </enterprise-beans> | </ejb-jar> | jbosscmp-jdbc.xml: | <?xml version="1.0" encoding="UTF-8"?> | | <jbosscmp-jdbc> | <relationships> | <ejb-relation> | <ejb-relation-name>Customer-Book</ejb-relation-name> | <foreign-key-mapping/> | </ejb-relation> | </relationships> | | </jbosscmp-jdbc> | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4135273#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...