Troubleshoot Application Server Based Data Sources - 10.x

Description

This page lists the most common errors and examples. The resolution steps for data source profiles or application server based data sources (application server) might differ. In most cases, you will see common error messages like Error rendering macro 'sql' or Error rendering macro 'sql-query'

Double check the configuration values and verify if your JDBC driver is installed in the correct location.
Make sure you restart Confluence after you make configuration changes to server.xml or an equivalent application server (if you are using a different application server).
Make sure your database is configured using remote access to the Confluence server with a user name and password. If you face any problems, connect using an independent SQL client from the server to verify the access. Consult your database documentation to know how to configure remote access and database permissions.