I am trying to use mysql 5.0 with jboss 4.2.3 I have created all the required configuration xml file. and when i try to launch jboss it gives me an error saying :
Unable to get timer handles for containerId: jboss.j2ee:service=EJB3,ear=server.ear,jar=server.jar,name=UserManagerBean com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'test.timers' doesn't exist
since this is something related to the persistence of timer services, so i ignored it.
but my entity bean is also giving problem. the prblem is :
Unsuccessful: create table UserBean (id integer generated by default as identity (start with 1), name varchar(255), primary key (id)) 17:16:35,000 ERROR [SchemaExport] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'generated by default as identity (start with 1), name varchar(255), primary key ' at line 1
from the error message what i could understand is that jboss is trying to create db scheme from entity beans and it is not able to.. but why? I have my entity beans' primary key as int with @Id and @AutoGenerated annotation.. what could be wrong?
and how do i fix the timer error as well? Please help..
Hi Gopi Chand. I know this is an old question. I've faced the same problem and found this thread.
Probably you've already found the solution, but I'll answer here in case of anyone come here searching for answers.
I solved the problem adding this to my persistence.xml: