[JBoss-user] CMP Bug ?

[Greg Turner]

This is for JBoss 3.2. Using CMP 2.0. Using mySql as a database. JBoss is trying to create a table to handle my many to many relationship. When the ejb.jar is deployed, JBoss reports an SQL exception complaining about the sql statement that creates the table. See error below. I believe error has to do with the forward slash '/' in the table name, which is prohibited according to mySql docs.

2002-11-12 13:45:55,719 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.performer/PerformerBean] Executing SQL: CREATE TABLE imagecollection/ImageCollectionBean_performers_performe_1y1es3n (IMAGECOLLECTION_ID INTEGER NOT NULL, PERFORMER_ID INTEGER NOT NULL, CONSTRAINT pk_imagecollection/ImageCollectionBean_performers_perfor_twvroq PRIMARY KEY (IMAGECOLLECTION_ID, PERFORMER_ID))

2002-11-12 13:45:55,759 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.performer/PerformerBean] Could not create table imagecollection/ImageCollectionBean_performers_performe_1y1es3n

2002-11-12 13:45:55,759 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.parentTraceEnabled=true
2002-11-12 13:45:55,759 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=false
2002-11-12 13:45:55,759 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting=true

2002-11-12 13:45:55,769 ERROR [org.jboss.ejb.EntityContainer] Starting failed
org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax near '/ImageCollectionBean_performers_performe_1y1es3n (IMAGECOLLECTION_ID INTEGER NOT' at line 1)

Greg







-------------------------------------------------------
This sf.net email is sponsored by: To learn the basics of securing your web site with SSL, click here to get a FREE TRIAL of a Thawte Server Certificate: http://www.gothawte.com/rd522.html
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user