Hi,
I am using Jboss 4.0.0 and MySql 5.0 and I am trying to use MySql as DefaultDS.
I have followed the steps indicated in
http://wiki.jboss.org/auth/wiki/en/SetUpAMysqlDatasource?action=e&win...
But now I have a problem. When I start Jboss, at then console messages I read,
15:44:30,395 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
MBeans waiting for other MBeans:
ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
state: FAILED
I Depend On: jboss.jca:service=DataSourceBinding,name=DefaultDS
Depends On Me: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 'INTERVAL bigint,
INSTANCEPK other,
INFO other,
' at line 5
MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
state: FAILED
I Depend On: jboss.jca:service=DataSourceBinding,name=DefaultDS
Depends On Me: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 'INTERVAL bigint,
INSTANCEPK other,
INFO other,
' at line 5
If anyone can help me I will appreciate.
Regarding,
Jose Alvarez de Lara (pepelara)
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4151630#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...