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
Your primary key declatation is broken and you are getting a blank primary key declaration.