3 Replies Latest reply on May 11, 2002 6:43 AM by Slava

    CMP2 Problem with mysql

    Slava Newbie

      I have this problem in jboss-3RC2 + tomcat
      Can anybody help with where to look at. I know it has to do
      wiht database. It work with hypersonic, but not with
      mysql or postgresql
      06:40:23,523 INFO [OrderBean] Created table 'OrderBean' successfully.
      06:40:23,732 ERROR [EntityContainer] Exception in service lifecyle operation: start
      06:40:23,739 ERROR [STDERR] java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax near 'order VARCHA
      R(255) BINARY, CONSTRAINT pk_LineItemBean PRIMARY KEY (lineItemID))' at line 1
      06:40:23,741 ERROR [STDERR] at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
      06:40:23,742 ERROR [STDERR] at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source)
      06:40:23,743 ERROR [STDERR] at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)