MySQL syntax error with 3.0.3 creating table

[bartmoree]

Hello,


I just started with EJB 2.0 CMP, and I use MySQL 3.23.49. While deploying, JBoss 3.0.3 gives the following error:

.
.
.
.
15:57:37,761 INFO [EjbModule] Deploying CommunicatieAdresBean
15:57:37,891 INFO [EjbModule] Deploying AdresManagerBean
15:57:37,931 INFO [EjbModule] Created
15:57:37,931 INFO [EjbModule] Starting
15:57:39,384 WARN [ServiceController] Problem starting service jboss.j2ee:jndiN
ame=CommunicatieAdresBean,service=EJB
org.jboss.deployment.DeploymentException: Error while creating table; - nested t
hrowable: (java.sql.SQLException: Syntax error or access violation: You have an
error in your SQL syntax near '))' at line 1)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStart
Command.java:175)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartComm
and.java:84)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDB
CStoreManager.java:457)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManage
r.java:369)
at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManag
er.java:198)
.
.
.
.
.

Although I don't know a way (???) to inspect the create table query generated by JBoss, it seems to me that it is syntactically incorrect.

By the way, if I connect to MySQL with same user en password, I CAN create a table.

Can anybody help me on this?


Thanx

Bart


Maybe you are interested in the following fragment of my deployment descripter:


<display-name>CommunicatieAdres</display-name>
<ejb-name>CommunicatieAdresBean</ejb-name>
nl.tlo.schemas.adresschema.communicatieadres.ejb.CommunicatieAdresHome
nl.tlo.schemas.adresschema.communicatieadres.ejb.CommunicatieAdres
<ejb-class>nl.tlo.schemas.adresschema.communicatieadres.ejb.CommunicatieAdresBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>nl.tlo.schemas.common.ejb.EntityPk</prim-key-class>
False
<cmp-version>2.x</cmp-version>
<abstract-schema-name>CommunicatieAdresBean</abstract-schema-name>
<cmp-field>
<field-name>entityId</field-name>
</cmp-field>
<cmp-field>
<field-name>idValue</field-name>
</cmp-field>
<cmp-field>
<field-name>soortValue</field-name>
</cmp-field>

[efingal]

I am also seeing this problem. If I use a composite primary key then I don't have the problem. But when I declare the primary key to be of type "java.lang.String" or any other basic type, I get this problem. Have you found any solution to this?

[bartmoree]

adding
<primkey-field>entityId</primkey-field>

to the deployment descripter (of course!) should solve the problem.