Error when trying to use MySQL for Camunda

[Josef Tufan]

Hi there,

i actually just tried to use mysql on a Camunda Tomcat installation.

What did I do?

- copied the connector jar into the tomcat lib folder

- changed to necessary dependency data in the server.xml

- created the tables as in the sql\create\mysql_engine_7.3.0.sql  and mssql_identity_7.3.0.sql files.

My Database looks good so far, the mysql console shows me :

mysql> SHOW TABLES;
+-------------------------+
| Tables_in_camundabpm    |
+-------------------------+
| act_ge_bytearray        |
| act_ge_property         |
| act_hi_actinst          |
| act_hi_attachment       |
| act_hi_caseactinst      |
| act_hi_caseinst         |
| act_hi_comment          |
| act_hi_detail           |
| act_hi_incident         |
| act_hi_job_log          |
| act_hi_op_log           |
| act_hi_procinst         |
| act_hi_taskinst         |
| act_hi_varinst          |
| act_id_group            |
| act_id_info             |
| act_id_membership       |
| act_id_user             |
| act_re_case_def         |
| act_re_deployment       |
| act_re_procdef          |
| act_ru_authorization    |
| act_ru_case_execution   |
| act_ru_case_sentry_part |
| act_ru_event_subscr     |
| act_ru_execution        |
| act_ru_filter           |
| act_ru_identitylink     |
| act_ru_incident         |
| act_ru_job              |
| act_ru_jobdef           |
| act_ru_meter_log        |
| act_ru_task             |
| act_ru_variable         |
+-------------------------+
34 rows in set (0.00 sec)

Well but when I try to startup the server, I get a severe error:

Jun 01, 2015 11:31:06 AM org.apache.tomcat.jdbc.pool.ConnectionPool init
SCHWERWIEGEND: Unable to create initial connections of pool.
java.sql.SQLException: Driver:com.mysql.jdbc.Driver@5bcab519 returned null for URL:mysql:jdbc:mysql://localhost:3306/camundabpm?autoReconnect=true
 at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:296)
 at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
 at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:701)
 at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:635)
 at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:486)
 at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:144)
 at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
 at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
 at org.apache.tomcat.jdbc.pool.DataSourceFactory.createDataSource(DataSourceFactory.java:554)
 at org.apache.tomcat.jdbc.pool.DataSourceFactory.getObjectInstance(DataSourceFactory.java:242)
 at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:141)
 at javax.naming.spi.NamingManager.getObjectInstance(Unknown Source)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:842)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:167)
 at org.apache.catalina.core.NamingContextListener.addResource(NamingContextListener.java:1103)
 at org.apache.catalina.core.NamingContextListener.createNamingContext(NamingContextListener.java:682)
 at org.apache.catalina.core.NamingContextListener.lifecycleEvent(NamingContextListener.java:271)
 at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
 at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)
 at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:731)
 at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
 at org.apache.catalina.startup.Catalina.start(Catalina.java:689)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:321)
 at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:455)


Jun 01, 2015 11:31:06 AM org.apache.naming.NamingContext lookup
WARNUNG: Unexpected exception resolving reference
java.sql.SQLException: Driver:com.mysql.jdbc.Driver@5bcab519 returned null for URL:mysql:jdbc:mysql://localhost:3306/camundabpm?autoReconnect=true
 at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:296)
 at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
 at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:701)
 at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:635)
 at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:486)
 at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:144)
 at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
 at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
 at org.apache.tomcat.jdbc.pool.DataSourceFactory.createDataSource(DataSourceFactory.java:554)
 at org.apache.tomcat.jdbc.pool.DataSourceFactory.getObjectInstance(DataSourceFactory.java:242)
 at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:141)
 at javax.naming.spi.NamingManager.getObjectInstance(Unknown Source)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:842)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:167)
 at org.apache.catalina.core.NamingContextListener.addResource(NamingContextListener.java:1103)
 at org.apache.catalina.core.NamingContextListener.createNamingContext(NamingContextListener.java:682)
 at org.apache.catalina.core.NamingContextListener.lifecycleEvent(NamingContextListener.java:271)
 at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
 at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)
 at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:731)
 at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
 at org.apache.catalina.startup.Catalina.start(Catalina.java:689)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:321)
 at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:455)


Jun 01, 2015 11:31:06 AM org.apache.catalina.core.NamingContextListener addResource
WARNUNG: Failed to register in JMX: javax.naming.NamingException: Driver:com.mysql.jdbc.Driver@5bcab519 returned null for URL:mysql:jdbc:mysql://localhost:3306/camundabpm?autoReconnect=true
Jun 01, 2015 11:31:06 AM org.camunda.bpm.container.impl.tomcat.deployment.TomcatParseBpmPlatformXmlStep lookupBpmPlatformXmlFromCatalinaConfDirectory
INFORMATION: Found camunda bpm platform configuration in CATALINA_BASE/CATALINA_HOME conf directory [C:\Tomcat2\server\apache-tomcat-7.0.62\conf\bpm-platform.xml] at file:/C:/Tomcat2/server/apache-tomcat-7.0.62/conf/bpm-platform.xml
Jun 01, 2015 11:31:06 AM org.camunda.bpm.engine.impl.jobexecutor.JobExecutor start
INFORMATION: Starting up the JobExecutor[org.camunda.bpm.engine.impl.jobexecutor.RuntimeContainerJobExecutor].
Jun 01, 2015 11:31:06 AM org.camunda.bpm.engine.impl.jobexecutor.SequentialJobAcquisitionRunnable run
INFORMATION: JobExecutor[org.camunda.bpm.engine.impl.jobexecutor.RuntimeContainerJobExecutor] starting to acquire jobs
Jun 01, 2015 11:31:06 AM org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl invokePreInit
INFORMATION: PLUGIN ProcessApplicationEventListenerPlugin activated on process engine default
Jun 01, 2015 11:31:06 AM org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl invokePreInit
INFORMATION: PLUGIN SpinProcessEnginePlugin activated on process engine default
Jun 01, 2015 11:31:06 AM org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl invokePreInit
INFORMATION: PLUGIN ConnectProcessEnginePlugin activated on process engine default
Jun 01, 2015 11:31:06 AM org.apache.tomcat.jdbc.pool.ConnectionPool init
WARNUNG: maxIdle is larger than maxActive, setting maxIdle to: 20
Jun 01, 2015 11:31:06 AM org.apache.tomcat.jdbc.pool.ConnectionPool init
SCHWERWIEGEND: Unable to create initial connections of pool.
java.sql.SQLException: Driver:com.mysql.jdbc.Driver@6f53b8a returned null for URL:mysql:jdbc:mysql://localhost:3306/camundabpm?autoReconnect=true
 at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:296)
 at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
 at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:701)
 at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:635)
 at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:486)
 at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:144)
 at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
 at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
 at org.apache.tomcat.jdbc.pool.DataSourceFactory.createDataSource(DataSourceFactory.java:554)
 at org.apache.tomcat.jdbc.pool.DataSourceFactory.getObjectInstance(DataSourceFactory.java:242)
 at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:141)
 at javax.naming.spi.NamingManager.getObjectInstance(Unknown Source)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:842)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:167)
 at org.apache.naming.SelectorContext.lookup(SelectorContext.java:156)
 at javax.naming.InitialContext.lookup(Unknown Source)
 at org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl.initDataSource(ProcessEngineConfigurationImpl.java:674)
 at org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl.init(ProcessEngineConfigurationImpl.java:498)
 at org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:468)
 at org.camunda.bpm.container.impl.jmx.services.JmxManagedProcessEngineController.start(JmxManagedProcessEngineController.java:34)
 at org.camunda.bpm.container.impl.jmx.MBeanServiceContainer.startService(MBeanServiceContainer.java:67)
 at org.camunda.bpm.container.impl.jmx.MBeanServiceContainer.startService(MBeanServiceContainer.java:53)
 at org.camunda.bpm.container.impl.deployment.StartProcessEngineStep.performOperationStep(StartProcessEngineStep.java:114)
 at org.camunda.bpm.container.impl.spi.DeploymentOperation.execute(DeploymentOperation.java:117)
 at org.camunda.bpm.container.impl.jmx.MBeanServiceContainer.executeDeploymentOperation(MBeanServiceContainer.java:148)
 at org.camunda.bpm.container.impl.spi.DeploymentOperation$DeploymentOperationBuilder.execute(DeploymentOperation.java:209)
 at org.camunda.bpm.container.impl.tomcat.TomcatBpmPlatformBootstrap.deployBpmPlatform(TomcatBpmPlatformBootstrap.java:69)
 at org.camunda.bpm.container.impl.tomcat.TomcatBpmPlatformBootstrap.lifecycleEvent(TomcatBpmPlatformBootstrap.java:55)
 at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
 at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)
 at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:402)
 at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:347)
 at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:732)
 at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
 at org.apache.catalina.startup.Catalina.start(Catalina.java:689)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:321)
 at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:455)


Jun 01, 2015 11:31:06 AM org.apache.naming.NamingContext lookup
WARNUNG: Unexpected exception resolving reference
java.sql.SQLException: Driver:com.mysql.jdbc.Driver@6f53b8a returned null for URL:mysql:jdbc:mysql://localhost:3306/camundabpm?autoReconnect=true
 at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:296)
 at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
 at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:701)
 at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:635)
 at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:486)
 at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:144)
 at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
 at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
 at org.apache.tomcat.jdbc.pool.DataSourceFactory.createDataSource(DataSourceFactory.java:554)
 at org.apache.tomcat.jdbc.pool.DataSourceFactory.getObjectInstance(DataSourceFactory.java:242)
 at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:141)
 at javax.naming.spi.NamingManager.getObjectInstance(Unknown Source)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:842)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:167)
 at org.apache.naming.SelectorContext.lookup(SelectorContext.java:156)
 at javax.naming.InitialContext.lookup(Unknown Source)
 at org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl.initDataSource(ProcessEngineConfigurationImpl.java:674)
 at org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl.init(ProcessEngineConfigurationImpl.java:498)
 at org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:468)
 at org.camunda.bpm.container.impl.jmx.services.JmxManagedProcessEngineController.start(JmxManagedProcessEngineController.java:34)
 at org.camunda.bpm.container.impl.jmx.MBeanServiceContainer.startService(MBeanServiceContainer.java:67)
 at org.camunda.bpm.container.impl.jmx.MBeanServiceContainer.startService(MBeanServiceContainer.java:53)
 at org.camunda.bpm.container.impl.deployment.StartProcessEngineStep.performOperationStep(StartProcessEngineStep.java:114)
 at org.camunda.bpm.container.impl.spi.DeploymentOperation.execute(DeploymentOperation.java:117)
 at org.camunda.bpm.container.impl.jmx.MBeanServiceContainer.executeDeploymentOperation(MBeanServiceContainer.java:148)
 at org.camunda.bpm.container.impl.spi.DeploymentOperation$DeploymentOperationBuilder.execute(DeploymentOperation.java:209)
 at org.camunda.bpm.container.impl.tomcat.TomcatBpmPlatformBootstrap.deployBpmPlatform(TomcatBpmPlatformBootstrap.java:69)
 at org.camunda.bpm.container.impl.tomcat.TomcatBpmPlatformBootstrap.lifecycleEvent(TomcatBpmPlatformBootstrap.java:55)
 at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
 at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)
 at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:402)
 at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:347)
 at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:732)
 at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
 at org.apache.catalina.startup.Catalina.start(Catalina.java:689)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:321)
 at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:455)


Jun 01, 2015 11:31:06 AM org.camunda.bpm.engine.impl.jobexecutor.JobExecutor shutdown
INFORMATION: Shutting down the JobExecutor[org.camunda.bpm.engine.impl.jobexecutor.RuntimeContainerJobExecutor].
Jun 01, 2015 11:31:06 AM org.camunda.bpm.engine.impl.jobexecutor.SequentialJobAcquisitionRunnable run
INFORMATION: JobExecutor[org.camunda.bpm.engine.impl.jobexecutor.RuntimeContainerJobExecutor] stopped job acquisition
Jun 01, 2015 11:31:06 AM org.apache.catalina.startup.Catalina start
SCHWERWIEGEND: The required Server component failed to start so Tomcat is unable to start.
org.apache.catalina.LifecycleException: Failed to start component [StandardServer[8005]]
 at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:154)
 at org.apache.catalina.startup.Catalina.start(Catalina.java:689)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:321)
 at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:455)
Caused by: org.camunda.bpm.engine.ProcessEngineException: Exception while performing 'deploy BPM platform => Start process engine default': couldn't lookup datasource from java:jdbc/ProcessEngine: Driver:com.mysql.jdbc.Driver@6f53b8a returned null for URL:mysql:jdbc:mysql://localhost:3306/camundabpm?autoReconnect=true
 at org.camunda.bpm.container.impl.spi.DeploymentOperation.execute(DeploymentOperation.java:134)
 at org.camunda.bpm.container.impl.jmx.MBeanServiceContainer.executeDeploymentOperation(MBeanServiceContainer.java:148)
 at org.camunda.bpm.container.impl.spi.DeploymentOperation$DeploymentOperationBuilder.execute(DeploymentOperation.java:209)
 at org.camunda.bpm.container.impl.tomcat.TomcatBpmPlatformBootstrap.deployBpmPlatform(TomcatBpmPlatformBootstrap.java:69)
 at org.camunda.bpm.container.impl.tomcat.TomcatBpmPlatformBootstrap.lifecycleEvent(TomcatBpmPlatformBootstrap.java:55)
 at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
 at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)
 at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:402)
 at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:347)
 at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:732)
 at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
 ... 7 more
Caused by: org.camunda.bpm.engine.ProcessEngineException: couldn't lookup datasource from java:jdbc/ProcessEngine: Driver:com.mysql.jdbc.Driver@6f53b8a returned null for URL:mysql:jdbc:mysql://localhost:3306/camundabpm?autoReconnect=true
 at org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl.initDataSource(ProcessEngineConfigurationImpl.java:676)
 at org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl.init(ProcessEngineConfigurationImpl.java:498)
 at org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:468)
 at org.camunda.bpm.container.impl.jmx.services.JmxManagedProcessEngineController.start(JmxManagedProcessEngineController.java:34)
 at org.camunda.bpm.container.impl.jmx.MBeanServiceContainer.startService(MBeanServiceContainer.java:67)
 at org.camunda.bpm.container.impl.jmx.MBeanServiceContainer.startService(MBeanServiceContainer.java:53)
 at org.camunda.bpm.container.impl.deployment.StartProcessEngineStep.performOperationStep(StartProcessEngineStep.java:114)
 at org.camunda.bpm.container.impl.spi.DeploymentOperation.execute(DeploymentOperation.java:117)
 ... 17 more
Caused by: javax.naming.NamingException: Driver:com.mysql.jdbc.Driver@6f53b8a returned null for URL:mysql:jdbc:mysql://localhost:3306/camundabpm?autoReconnect=true
 at org.apache.naming.NamingContext.lookup(NamingContext.java:859)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
 at org.apache.naming.NamingContext.lookup(NamingContext.java:167)
 at org.apache.naming.SelectorContext.lookup(SelectorContext.java:156)
 at javax.naming.InitialContext.lookup(Unknown Source)
 at org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl.initDataSource(ProcessEngineConfigurationImpl.java:674)
 ... 24 more


Jun 01, 2015 11:31:06 AM org.camunda.bpm.container.impl.tomcat.TomcatBpmPlatformBootstrap undeployBpmPlatform
INFORMATION: camunda BPM platform stopped.
Jun 01, 2015 11:31:06 AM org.apache.catalina.util.LifecycleBase destroy
WARNUNG: Calling stop() on failed component [StandardServer[8005]] to trigger clean-up did not complete.
org.apache.catalina.LifecycleException: Failed to stop component [StandardServer[8005]]
 at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:236)
 at org.apache.catalina.util.LifecycleBase.destroy(LifecycleBase.java:272)
 at org.apache.catalina.startup.Catalina.start(Catalina.java:693)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:321)
 at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:455)
Caused by: org.apache.catalina.LifecycleException: An invalid Lifecycle transition was attempted ([before_stop]) for component [StandardService[Catalina]] in state [INITIALIZED]
 at org.apache.catalina.util.LifecycleBase.invalidTransition(LifecycleBase.java:409)
 at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:219)
 at org.apache.catalina.core.StandardServer.stopInternal(StandardServer.java:760)
 at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:232)
 ... 8 more


Jun 01, 2015 11:31:06 AM org.apache.coyote.AbstractProtocol destroy
INFORMATION: Destroying ProtocolHandler ["http-bio-8080"]
Jun 01, 2015 11:31:06 AM org.apache.coyote.AbstractProtocol destroy
INFORMATION: Destroying ProtocolHandler ["ajp-bio-8009"]

I actually do not understand why it says "returned null for url"

Any ideas?

Regards,

Josef

[Sebastian Menski]

Hi Josef,

it seems your database URL is wrong. The "mysql:jdbc:mysql" part looks strange. I think it should start only with "jdbc:mysql".

Cheers,

Sebastian

[thorben.lindhauer]

Hi Josef,

Your JDBC url appears to be malformed.

Instead of

mysql:jdbc:mysql://localhost:3306/camundabpm?autoReconnect=true

it should be

jdbc:mysql://localhost:3306/camundabpm?autoReconnect=true

Please ask these kind of questions on the user forum [1] in the future.

Cheers,
Thorben

...

[Josef Tufan]

Thanks very much! You are absolutelty right. Works like charm now.

[Josef Tufan]

Actually now my deploys are not working anymore. If i drop the .war package to the webapps folder, I do not get any deploy messages in the tomcat console. Plus the process is not available  to start in the tasklist.