1 Reply Latest reply on Sep 6, 2002 5:49 PM by Dain Sundstrom

    SQL Exception Error on deployment of CMP2.0

    stephen smithstone Newbie

      I have created a example CMP bean to try and run however when i deploy the file i get SQLException in the log screen heres a snippit

      Caused by: java.sql.SQLException: Column not found: ) in statement [CREATE TABLE PRODUCT (productID VARCHAR(256), name VARCHAR(256), description VARCHAR(256), CONSTRAINT PK_PRODUCT PRIMARY KEY ())]
      at org.hsqldb.Trace.getError(Trace.java:180)
      at org.hsqldb.Result.(Result.java:175)
      at org.hsqldb.jdbcConnection.executeHSQL(jdbcConnection.java:907)
      at org.hsqldb.jdbcConnection.execute(jdbcConnection.java:718)
      at org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:686)
      at org.hsqldb.jdbcStatement.executeUpdate(jdbcStatement.java:85)
      at org.jboss.resource.adapter.jdbc.local.LocalStatement.executeUpdate(LocalStatement.java:231)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:169)
      ... 51 more

      However ive stated differnt values in my jbosscmp-jdbc.xml
      i wud be greatfull if some 1 could look over these and post me some advice

      My datasource is workin cos ive tested it with an BMP bean and its java:/MySqlDS