0 Replies Latest reply on Feb 24, 2003 11:10 AM by Micke

    CMR field as foreign key

    Micke Newbie

      I've installed JBoss 3.2RC2, but I'm still facing the same problem. How do I define the relationship between A and B when the foreign key in B is the same as the primary key in A? I found a post by loubyansky where he says that the column name must be the same in both tables, is this true? Anyway, I get this error: "java.sql.SQLException: ORA-00921: unexpected end of SQL command" which isn't that difficult to understand when my SQL looks like this: "Executing SQL: SELECT COUNT(*) FROM CW_ENUMVALUE WHERE" How do I get JBoss to understand that it shall use the CMR field?