Symptoms

One or more SQL Macro returns the following error:

org.apache.tomcat.dbcp.dbcp.SQLNestedException:
Cannot load JDBC driver class
Unable to load database driver: org.postgresql.Driver. Make sure your configuration is correct.
Unable to load database driver: net.sourceforge.jtds.jdbc.Driver

Cause

The Data Source is unable to locate your JDBC driver and therefore cannot connect to the database it references. 

Resolution

App server: JDBC driver must be installed in a location that is on the classpath of your application server. For standalone installations, that would be <install-directory>/lib.

Profile: dbJar must point to the correct location of the JDBC jar file. Try absolute addressing if relative addressing is not working for you (especially if on Windows).