I get the following error when trying to create a bean:
14:58:04,751 ERROR [entity/License] Could not create entity
java.sql.SQLException: Unexpected token: / in statement [INSERT INTO LICENSE (id, license_number, entity/User_license) VALUES (1, NULL, NULL)]
When I remove this relation from the two xml files the bean is created just fine. Please help because the error does not make much sense at all. I am attaching the xml files as well.
Wow, I am not alone. I also get a similar exception using Oracle. My JBoss container assumes a column name (god knows how) that is similar to the relationship name in my table! I don't know how to get rid of it and it is annoying.
I am guessing that when JBoss3.0 or any software is released, developers must have tested the functionalities. So is there a list of things JBoss is compliant with EJB 2.0? If so, can developers show us their test samples as examples to follow? Because I have no idea how to do most of the things specific to JBoss and the JBoss doc is not available for JBoss 3 yet. All I have is a generic EJB book.
This is your problem...
Defined in your ejb-jar file
remove the forward slash
Sorry about that. Please ignore. I see it now
The forward slash is not a problem. I have tested it without the forward slash, and I still get the same error. The problem is in the underlying mapping code. It is putting the foreign key in the wrong table.
Please whoever did the coding for this part fix it, and let us know, because this is a major functionality of ejb2.0 and is simply not working.
The problem is you have the keys on the wrong side of the relationship.