2 Replies Latest reply on Oct 28, 2002 4:48 AM by Bart Moree

    MySQL syntax error with 3.0.3 creating table

    Bart Moree Newbie

      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>