How to resolve a Class not found error - 10.x

Symptoms

One or more SQL Macro returns the following error:

java.lang.ClassNotFoundException:
org.apache.commons.dbcp.BasicDataSourceFactory

Cause

This error can occur if your data source configuration is out of date after upgrading Confluence or your application server. 

Resolution

  1. Look for something similar to factory="org.apache.commons.dbcp.BasicDataSourceFactory" in your server.xml.
  2. Either, remove the entry, or, replace with factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory".Â