I'm using jboss3.0.4 and mysql4 and tried to change the HypersonicDS to MySqlDS in the example program, that comes with the free jboss Getting Started docu.
I configured jboss and deployed all necessary files for use of mysql within jboss.
When I invoke the test client, the table "testentity" on my mysql database is created by jboss, but the creation of the entity fails, there are no data entries made into the testentity-table in the mysql-database.
I get the following error:
Caugth exception: EJBException:; nested exception is: javax.ejb.EJBException: Remote exception occured while removing generator session bean: Sequence number is broken; nested exception is: javax.ejb.EJBException: Sequence number is broken
I use the mysql-service.xml from the examples, just changed the database URL,user,passw. I use mysql-connector-java-2.0.14.
What could be the problem? Something to do with the mapping in jbosscmp-jdbc.xml?