Runtime error in Clustered EJB Timer with MySQL database (Doc ID 1931122.1)

Last updated on NOVEMBER 05, 2016

Applies to:

Oracle WebLogic Server - Version 10.3.6 and later
Information in this document applies to any platform.

Symptoms

Facing runtime error on clustered EJB timer with MySQL:

javax.ejb.EJBException: EJB Exception: : java.lang.IllegalStateException: weblogic.scheduler.TimerException: Unable to create timer
    at weblogic.scheduler.TimerServiceImpl.schedule(TimerServiceImpl.java:59)
    at weblogic.scheduler.TimerServiceImpl.schedule(TimerServiceImpl.java:91)
    at weblogic.scheduler.ejb.internal.EJBTimerManagerImpl.schedule(EJBTimerManagerImpl.java:51)

...

Caused by: weblogic.scheduler.TimerException: Unable to create timer
    at weblogic.scheduler.DBTimerBasisImpl.createTimer(DBTimerBasisImpl.java:213)
    at weblogic.scheduler.TimerServiceImpl.createTimerInternal(TimerServiceImpl.java:174)
    at weblogic.scheduler.TimerServiceImpl.schedule(TimerServiceImpl.java:57)
    ... 51 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.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, TIMER_MANAGER_NAME, DOMAIN_NAME, CLUSTER_NAME ) VALUES ( '1@@ManagedSe' at line 1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms