1:1 CMR & Jboss CMP - strange problem

[eli_w]

Hi all!

I have a strange problem using 1:1 CMR with CMP EJB. When I create an entity bean with given cmr field content - it's ok, no problem has arised and all content in the database . But if I want to create another bean with different primary key but with the same cmr field value - it also creates without any problem, but in the database the record that corresponds to previously created bean updates with NULL value on the column that corresponds to the cmr field, and then the new record is created.
No unique settings for the DB table, foreign keys are created.
JBoss 3.0.4 with Tomcat, MS SQL 2000.
Thanks in advance for any useful advice.

[lorensrosen]

If I understand what you did correctly, JBoss worked as expected. You established a relationship between, say,
A1 and Z1. Then you tried to establish a relationship
between A2 and Z1. But Z1 can't be related to both
A1 and A2 since the relation is supposed to be 1-to-1.

[eli_w]

It looks like many-to-one unidirectional - at least that's how I can see it now.
Thanks for explanation.