I'm working with mpforste on this problem. Only having tr_type (the foreign key) as a cmr-field means when JBoss creates the table in mySQL, the foreign key field is a BLOB. The foreign key is supposed to be a BIGINT and creating transactions fails when it is a BIGINT.
When I leave it as a BLOB, code works as I expected, including creating a transaction with a transtype object, retrieving an associated transtype from a transaction and setting its description, which appears in the transtype table. In other words, we have CMR but using an object reference, not a foreign key field. Surely this can't be JBoss's method of persisting relationships? It can't be made to use a relational model or have I misconfigured something? I would prefer to use a relational persistence scheme so other reporting tools can read the database. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3830119#3830119 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3830119 ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
