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".