1 Reply Latest reply on Aug 13, 2002 5:18 PM by Dain Sundstrom

    CMR Problem Unidirectional 1 to 1

    Anthony Campos Newbie

      Hi

      Anyone knows what is it??

      I have this tables:

      Customers
      ----------
      Id
      FullName
      Phone

      Accounts
      ----------
      Id
      IdCustomer
      Email
      Password
      Active

      I am using relationships and this is my ejb-jar.xml look like:


      <ejb-relation> <ejb-relation-name>AccountshasCustomers</ejb-relation-name>
      <ejb-relationship-role> <ejb-relationship-role-name>Accounts</ejb-relationship-role-name>
      One
      <relationship-role-source>
      <ejb-name>Accounts</ejb-name>
      </relationship-role-source>
      <cmr-field> <cmr-field-name>idCustomer</cmr-field-name>
      </cmr-field>
      </ejb-relationship-role>
      <ejb-relationship-role>
      <ejb-relationship-role-name>Customers</ejb-relationship-role-name>
      One
      <relationship-role-source>
      <ejb-name>Customers</ejb-name>
      </relationship-role-source>
      </ejb-relationship-role>
      </ejb-relation>


      But when I run my jsp I get this error:

      HTTP ERROR: 500 Could not create entity:java.sql.SQLException: ERROR: Relation 'customers' does not have attribute 'accounts_idcustomer'

      But if I make this relationship One to many it works very well...

      Someone knows where is my mistake??

      Thanks..