I do not believe that MySQL is a supported database for the scheduler scheduler. The list of databases that are definitely supported are listed here:
http://publib.boulder.ibm.com/infoce...tsch_data.html
This is a discussion on Please Help:how do I configure Websphere EJB timer servicesettings&MySql - Websphere ; I configured MySql datasource on Websphere 6.1 successfully, but when I restarted server, gave me the following error: it looks like scheduler instance Scheduler not correctly, how do I fix it? thanks ================================================== ================================================== =============== 7/31/09 16:51:56:296 EDT] 00000018 EJBContainerI ...
I configured MySql datasource on Websphere 6.1 successfully, but when I restarted server, gave me the following error:
it looks like scheduler instance Scheduler not correctly, how do I fix it? thanks
================================================== ================================================== ===============
7/31/09 16:51:56:296 EDT] 00000018 EJBContainerI E WSVR0040E: addEjbModule failed for LoyaltyCentralEjb.jar [class com.ibm.ws.runtime.component.DeployedEJBModuleImpl]
com.ibm.websphere.csi.EJBContainerException: EJB Timer Service not started
at com.ibm.ws.runtime.component.EJBContainerImpl.getS chedulerInstance(EJBContainerImpl.java:2426)
at com.ibm.ws.runtime.component.EJBContainerImpl.inst all(EJBContainerImpl.java:2771)
at com.ibm.ws.runtime.component.EJBContainerImpl.star t(EJBContainerImpl.java:3693)
at com.ibm.ws.runtime.component.ApplicationMgrImpl.st art(ApplicationMgrImpl.java:1301)
at com.ibm.ws.runtime.component.DeployedApplicationIm pl.fireDeployedObjectStart(DeployedApplicationImpl .java:1138)
at com.ibm.ws.runtime.component.DeployedModuleImpl.st art(DeployedModuleImpl.java:569)
at com.ibm.ws.runtime.component.DeployedApplicationIm pl.start(DeployedApplicationImpl.java:817)
at com.ibm.ws.runtime.component.ApplicationMgrImpl.st artApplication(ApplicationMgrImpl.java:950)
at com.ibm.ws.runtime.component.ApplicationMgrImpl$Ap pInitializer.run(ApplicationMgrImpl.java:2120)
at com.ibm.wsspi.runtime.component.WsComponentImpl$_A synchInitializer.run(WsComponentImpl.java:341)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:1469)
Caused by: com.ibm.ws.scheduler.exception.SchedulerDataStoreE xception: com.ibm.ws.extensionhelper.exception.UnknownDataba seException: Could not detect database vendor. Vendor string was MySQL
at com.ibm.ws.scheduler.WASSchedulerCfgHelper.createT ables(WASSchedulerCfgHelper.java:542)
at com.ibm.ws.runtime.component.EJBContainerImpl.crea teTimerTables(EJBContainerImpl.java:2636)
at com.ibm.ws.runtime.component.EJBContainerImpl.getS chedulerInstance(EJBContainerImpl.java:2367)
... 10 more
Caused by: com.ibm.ws.extensionhelper.exception.UnknownDataba seException: Could not detect database vendor. Vendor string was MySQL
at com.ibm.ws.extensionhelper.db.impl.DatabaseHelperI mpl.connect(DatabaseHelperImpl.java:634)
at com.ibm.ws.extensionhelper.db.impl.DatabaseHelperI mpl.initialize(DatabaseHelperImpl.java:465)
at com.ibm.ws.extensionhelper.db.impl.DatabaseHelperI mpl. (DatabaseHelperImpl.java:246)
at com.ibm.ws.extensionhelper.impl.ExtensionHelperSer viceImpl.getDatabaseHelper(ExtensionHelperServiceI mpl.java:116)
at com.ibm.ws.scheduler.DBHelperImpl.(DBHelperImpl.ja va:106)
at com.ibm.ws.scheduler.WASSchedulerCfgHelper.getData baseHelper(WASSchedulerCfgHelper.java:962)
at com.ibm.ws.scheduler.WASSchedulerCfgHelper.createT ables(WASSchedulerCfgHelper.java:537)
... 12 more
[7/31/09 16:51:56:343 EDT] 00000018 EJBContainerI I WSVR0041I: Stopping EJB jar: LoyaltyCentralEjb.jar
I do not believe that MySQL is a supported database for the scheduler scheduler. The list of databases that are definitely supported are listed here:
http://publib.boulder.ibm.com/infoce...tsch_data.html