Atleast one role of a foreign-key mapped relationship must h

[j_sorin]

"j_sorin" wrote:

"j_sorin" wrote:

"j_sorin" wrote:
Could someone tell me please why I have the error message below and what should I do to solve the problem ?

org.jboss.deployment.DeploymentException: Atleast one role of a foreign-key mapped relationship must have key fields: ejb-relation-name=Location-City
at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCRelationMetaData.<init>(JDBCRelationMetaData.java:321)
at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCApplicationMetaData.<init>(JDBCApplicationMetaData.java:325)
at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCXmlFileLoader.load(JDBCXmlFileLoader.java:67)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadJDBCEntityMetaData(JDBCStoreManager.java:677)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:389)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:339) .............

[j_sorin]

"j_sorin" wrote:

"j_sorin" wrote:

"j_sorin" wrote:
Why if I used in ejb-jar.xml instead of my defined primary key class a java standard class the error message is not displayed anymore ?

[oscpro]

"oscpro" wrote:

"oscpro" wrote:
I have the same problem.

Did you find a solution besides using java classes as primary keys?

Oscar

[oscpro]

"oscpro" wrote:

"oscpro" wrote:

"oscpro" wrote:
Hi,

I found a solution. In jbosscmp-jdbd.xml you add:

 <relationships>
 ...
 <ejb-relation>
 <ejb-relationship-role>
 <ejb-relationship-role-name>role-name</ejb-relationship-role-name>
 <key-fields>
 <key-field>
 <field-name><!-- include here the name of the primary key field of the other side (ie. id)--></field-name>
 <column-name><!-- include here the name you want to give to you foreign key column (ie. address_id)--></column-name>
 </key-field>
 </key-fields>

 </ejb-relationship-role>
 ...

 </ejb-relation>
 </relationships>

If you use xdoclet you just add:

...
*
* @jboss.relation
* related-pk-field = "id"
* fk-column = "adress_id"
*
...

[seng2000]

"seng2000" wrote:

"seng2000" wrote:

"seng2000" wrote:
by using @jboss.relation, u receive complain.? :)

give
@jboss.target-relation a try. :)