Hi, I'm having problems with Entity Beans. The problem is, i cannot insert any row (using ejbCreate) to a table that has a foreign key coloumn. I've tried using CMP and BMP, nothing worked. This is weird, all find, update, and remove methods work, except the create method. I've also checked the deployment descriptors, they're okay. Has someone had this kind of problem? Can somebody help me? By the way, i'm using Forte 3.0 EE, iPlanet Application Server 6.0 SP3, and MS-SQL Server 2000.
Sounds like an FK constraint. Best way to try is to construct a similar SQL query similar to the EJB-QL that you use and see what the result is if you enter it to your DB console. Only after the SQL works that you port it to EJB-QL.