You are currently reviewing an older revision of this page.

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 a the following message observed in the application server log:

2021-04-13 04:14:52 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:

20.4 onwards?