Symptoms

One or more SQL Macro returns the following error:

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

Cause

After upgrading Confluence or your application server, this error can occur if your data source configuration is out of date. 

Resolution

Look for something like factory="org.apache.commons.dbcp.BasicDataSourceFactory" in your server.xml. Either remove it or rename it to factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory".