Troubleshooting Application Server-based Data Sources

Below are some common errors and examples.

• Double check all the configuration values and that the JDBC driver is installed in the correct location
• Make sure you restarted Confluence after making configuration changes to server.xml or equivalent application server configuration (when a different application server is being used)
• Make sure your database is configured from remote access from the Confluence server with the user and password provided. If you have problems, connect using an independent SQL client from the server to verify access. Consult your database documentation for how to configure remote access and database permissions

The resolution can be different for application server based Data Sources (application server) or Data Source Profiles which extend a Data Source. In most cases, you will see Error rendering macro 'sql' or Error rendering macro 'sql-query'

• Access Denied
• Authentication Failed
• Broken Connections
• Class Not Found
• Could Not Connect to Database Server
• Data Source Name Not Found
• Database Server Not Found
• Generic SQL Exception
• Invalid Database Port
• Invalid Syntax Server.xml
• isValid Exceptions
• Listener refused connection
• No JDBC Driver
• User Authority
• Validation Query Throwing Exception
• Validation Query Throwing Oracle Exception
• Copy of Invalid Syntax Server.xml