I developed a little application with an entity bean with container managed persistense using eclipse (2.1) and jboss-ide and mysql (3.23). (JBoss 3.2.1)
After deploying my application, I get the following exception:
" org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax near ' CONSTRAINT pk_DB PRIMARY KEY ())' at line 1") ".
Has anybody a solution for this problem?
You've incorrectly specified your primary key in ejb-jar.xml (or have omitted it completely).