Bugs item #569122, was opened at 2002-06-14 18:16 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=569122&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: None Priority: 5 Submitted By: Frank Langelage (lafr) Assigned to: Nobody/Anonymous (nobody) Summary: 3.0.1, CMR: add constraint fails Initial Comment: JBoss 3.0.1RC1 on ReliantUNIX 5.45, JDK 1.3.1, Informix 7.31 DB. The creation of tables and constraints seems to be corrupted in 3.0.1RC1. All works fine in 3.0.0 final. When deploying the jar with the ejb's I get messages about successful creation of tables feature, item and unit_of_measure. After this, a foreign-key-constraint on item, referencing unit_of_measure should be created. This fails with "referenced table unit_of_measure not found". If I look at the tables existing in the database after this, only the table named item does exist. The table feature, which was created first, does not exist. Nor does the table unit_of_measure exist. The server.log is attached. ---------------------------------------------------------------------- >Comment By: David Jencks (d_jencks) Date: 2002-06-14 20:45 Message: Logged In: YES user_id=60525 Are you using informix xa? I believe the cmp code was recently changed to rely on one of the following being the case: 1. DDL executes outside a tx. 2. Connector autocommits outside an explicit tx. (2) is true for the new Local Tx wrapper but probably not for the old xa wrapper. If (1) is false for informix, this could be the problem. ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=569122&group_id=22866 _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas - http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development