...
Warning | ||
---|---|---|
| ||
This page has been replaced by Configure Application Server-based Data Sources and Data source configuration - problem determination. Some of the information is out of date with respect to new releases of the add-on. However, we have kept the page as it has comments and answers that may still be helpful. |
...
Section | |||||||||
---|---|---|---|---|---|---|---|---|---|
|
...
Modify <install-dir>/conf/server.xml to add one or more datasource resource elements. User's Guide is an example of adding a few datasources for various local and non-local databases.
The essential element is something like the following, where the datasource name is myDS:
...
- In the WebLogic console, under Services > JDBC, create a data source (see WebLogic's documentation on how to Configure JDBC data sources for more information).
- Take note of the JNDI name you used to create the data source.
- Point the SQL macro to that JNDI name (datasource parameter).
...
Check your application server (server.xml) configuration and ensure the DNS host name is valid on the server running confluence
No Format sql: Unexpected program error: com.atlassian.renderer.v2.macro.MacroException: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unknown server host name 'myserver'.)
Error - port
Database The database may not be listening on the requested port - verify the port configuration in server.xml and database
No Format sql: Unexpected program error: com.atlassian.renderer.v2.macro.MacroException: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Network error IOException: Connection refused)
...
- Make sure your database server is accepting connections from the Confluence server TCP address and the user is authorized to connect.
...
Add a validation query to your configuration. This helps the application server connection pool to recover from database connection problems.
...