Unable to Start Due to 'configure JDBC Driver class not found com.mysql.jdbc.Driver'
Symptoms
This occurs during an upgrade process:
2008-01-16 19:44:11,497 FATAL [main] [sf.hibernate.connection.C3P0ConnectionProvider] configure JDBC Driver class not found: com.mysql.jdbc.Driver
2008-01-16 19:44:11,504 ERROR [main] [springframework.web.context.ContextLoader] initWebApplicationContext Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultTxAdvice': Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager';
nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [databaseSubsystemContext.xml]:
Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory';
nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [productionDatabaseContext.xml]:
Invocation of init method failed;
nested exception is net.sf.hibernate.HibernateException: JDBC Driver class not found: com.mysql.jdbc.Driver
Cause
The appropriate jdbc driver (in this example the MySQL jdbc driver) has not been installed or copied from the old instance.
Resolution
Copy the jdbc from your old installation to your new installation, or download the latest driver from the manufacturer's website. The driver can be found either at common/lib
directory or confluence/WEB-INF/lib
directory.
For MySQL, please see the complete list of steps to download and install the JDBC driver in this page.