I'm going craaaaazy!

[crowley]

I'm using JBoss 3.2Beta3 and after spending some time reading posts in this forum I found out that it's possible to have a CMR field as a primary key in this version of JBoss, but how do I set it up? I have the documentation but that's not covered in there. All I want to do is to define a 1-n relation between A and B, with B containing the id of A. There are hundreds of posts from people struggeling with this matter, but no direct answer. Where can I find the solution?

[adrian.brock]

Support for this was added AFTER the 3.2Beta3 (1.43.2.6)
release, see 1.43.2.7

http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/jboss/jboss/src/main/org/jboss/ejb/plugins/cmp/jdbc/bridge/JDBCCMRFieldBridge.java?only_with_tag=Branch_3_2

There have been other fixes since, the last one in
3.2RC2

http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/jboss/jboss/src/main/org/jboss/ejb/plugins/cmp/jdbc/bridge/JDBCCMP2xFieldBridge.java?only_with_tag=Branch_3_2

Regards,
Adrian

[crowley]

So 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?

[crowley]

So 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?

[adrian.brock]

Yes, it compares the column names of the CMR
meta data against the CMP meta data.

Try posting your deployment descriptors.
Also, you are likely to get more help if you post in the
CMP forum.

Regards,
Adrian

[crowley]

I've created a simple example, have a look at the dd's and please find what's missing, thanks!

[crowley]

Ok, posting the DD's again since it seems that it didn't work the first time...