MySQLSyntaxErrorException: Invalid default value for 'NEXTDATE' in JBoss EAP?
Issue
- I am tring to persist ejbtimers on mysql but i get this exception:
ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] Error installing to Start: name=jboss.ejb:persistencePolicy=database,service=EJBTimerService state=Create mode=Manual requiredState=Installed
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'NEXTDATE'
Environment
- JBoss Enterprise Application Platform (EAP) 5.x
- MySQL 5.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.