JBOSS 3.0.0 + JDK1.4 + MySql
I have two tables T1 and T2, the T1 want to point to T2. I set the primary key of T2 as the same one in T1. For my previous experience, one field can be either CMP or CMR field, not both. A conflict is obviously existed, the primary key of T2 must be specified as CMP, meantime, CMR is needed for it as well. How can I get this 1:1 working? I totally have no idea, need your help!
A CMR field and a CMP field can not be mapped to the same column. JBossCMP does not support foreign keys in primary keys.