You are currently reviewing an older revision of this page.

DRAFT KB-XXXX Application server startup fails with "java.sql.SQLException: Unable to load class: org.mysql.jdbc.Driver" exception

Symptoms

When starting Tomcat via start-appserver.sh or start-appserver.bat, the startup fails with the following message observed in the application server log:

SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
java.sql.SQLException: Unable to load class: org.mysql.jdbc.Driver from ClassLoader:java.net.URLClassLoader@31221be2;ClassLoader:AppianWebappClassLoader
context: suite
delegate: false
----------> Parent Classloader:
java.net.URLClassLoader@31221be2

Cause:

The classname for the mysql drivers should be prefaced with 'com', rather than 'org'.

 Action:

Change the driverClassName found in tomcatResources.xml file located in in <APPIAN_HOME>/conf and restart the application server.

driverClassName="com.mysql.jdbc.Driver"

Affected Versions:

18.3 onwards