Bugs item #445705, was opened at 2001-07-29 08:12 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=445705&group_id=22866 Category: JBossCMP Group: v2.2.2 (stable) Status: Open Resolution: None Priority: 5 Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: Cannot use pk-constraint with mySQL Initial Comment: There seems to be a problem using the <pk-constraint> tag when JBoss is bound to a mySQL data source.. Jboss refuses to create the underlying tables if the <pk- constraint> tag is included in either the <entity> or <default-entity> tags in jaws.xml. I have tried using this tag in both a specific entity and the default entity, setting it to 'true' or 'false' but JAWS simply refuses to create the tables. Removing the <pk-constraint> tag allows JAWS to create the tables on EJB deployment but this leads to tables with no primary key constraints! Following is a sample from jawx.xml in case the problem is a mistake from my part: <default-entity> <create-table>true</create-table> <remove-table>false</remove-table> <tuned-updates>false</tuned-updates> <read-only>false</read-only> <time-out>300</time-out> <debug>true</debug> <select-for-update>true</select-for-update> <pk-constraint>true</pk-constraint> </default-entity> Regards, Colin Vella [EMAIL PROTECTED] ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=445705&group_id=22866 _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-development
