My Oracle Support Banner

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

Last updated on APRIL 12, 2018

Applies to:

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


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(
    at weblogic.scheduler.TimerServiceImpl.schedule(
    at weblogic.scheduler.ejb.internal.EJBTimerManagerImpl.schedule(


Caused by: weblogic.scheduler.TimerException: Unable to create timer
    at weblogic.scheduler.DBTimerBasisImpl.createTimer(
    at weblogic.scheduler.TimerServiceImpl.createTimerInternal(
    at weblogic.scheduler.TimerServiceImpl.schedule(
    ... 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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.