foreign key constraint fails

[shogun]

Hi out there,

I have a problem with CMP under jboss Version 3.0 RC1 and mysql. I want to create an entity, which has two foreign keys (associations to other classes). I placed the setter for the both foreign keys into the ejbPostCreate-method. Befor the setter can work, the INSERT INTO ... command is sent to the DB and I get an exception, that the row can not be added into the Database, because a foreign key constraint fails.

When I put the setter into ejbCreate, than an exception occurs, saying that I have to place CMR setter into ejbPostCreate.

Thanks for your help.

Shogun

[frodo]

This problem exists with RC2 and MySQL as well. The only way way I could get around it was to remove the not null attribute on the foreign key column in MySQL. Can a set method for a non null foreign key column be placed in ejbPostCreate()?

Thanks for your help.

[shogun]

I reported this behavior as a bug. This bug was closed with the comment, that with Version 3.1 it should be possible to set CMR fields before the physical insert into the database.
Till now, the only workaround is do delete the foreign (indexed row)in the mysql database. But after this, you have no referential integrity. Under Bea Weblogic you can place your setter into the ejbPostCreate() method. I think, with 3.1 it will also be possible with JBoss.