1 Reply Latest reply on Jun 15, 2003 7:16 PM by Juha Lindfors

    Create table error

    10squared Newbie

      I'm not sure where to start looking for the source of this problem, although I have searched the archive for "unexpected token".

      In a schema with one or more tables having defined primary keys, I am seeing an error associated with creation of the last table when generating CMP entity beans:

      MBeans waiting for other MBeans:
      [ObjectName: jboss.j2ee:jndiName=CategoryEntity,service=EJB
      state: FAILED
      I Depend On:
      Depends On Me: org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (java.sql.SQLException: Unexpected token: ) in statement [CREATE TABLE CATEGORYENTITY (catId DECIMAL, name VARCHAR(256), parent DECIMAL, CONSTRAINT PK_CATEGORYENTITY PRIMARY KEY ())])]
      15:34:40,013 INFO [URLDeploymentScanner] Started
      15:34:40,125 INFO [MainDeployer] Deployed package: file:/usr/jboss/jboss-3.2.0/server/default/conf/jboss-service.xml


      Where might the extra token be coming from, or is this an indication of a configurtion error? TIA.

      Jim