$customHeader
Skip to end of banner
Go to start of banner

How to convert an application server defined data source profile to a connection string profile

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 26 Current »

Removed support for application server defined data source in Confluence 8.x

The SQL for Confluence app version 11.x does not support the application server defined data source (global data source) profiles with Confluence 8.x. We recommend reconfiguring the application server defined data source profile to the connection string profile.

Atlassian has ended support for the data source connections in Confluence 8.0. The recommendation is to switch from the existing JNDI data source connections and move to a direct JDBC connection. For more information, refer to Configuring a data source connection.

Reconfigure the application server defined data source profile to a connection string profile

To convert the application server defined data source profile to a connection string profile, you can either:

Option 1: Modify and provide the connection string details with the Data source name as None.

Option 2: Modify and choose a configured local data source.

Modify the application server defined data source (global data source) profile

  1. Log in as a user with the Confluence administrator's Global Permission.

  2. Navigate to Manage apps > SQL for Confluence Configuration > View and modify data source profiles.

  3. The page displays a list of data source profiles and their connection status. The application server defined data source profile rows are highlighted and show UNSUPPORTED. The Connection status shows Failed.

  4. To modify the application server defined data source (global data source) profile, click Edit to the right of the data source profile.

  5. The Edit Profile window opens. To convert the application server defined data source profile to a connection string profile, you have two options:

  • Option 1: Provide the connection string details with the Data source name as None.

  • Option 2: Choose the data source already configured with the connection string details of the database.

To know more about the setup type and field details, refer to Configure Data Source Profiles - 11.x.

8. Once you reconfigure the data source profile to the connection string profile and save the profile, the corresponding row gets unhighlighted in the View and modify data source profiles page.

Reconfigure the application server defined data source profile to a connection string profile.

SQL for Confluence 11.x app updates in Confluence 8.x

The SQL for Confluence app version 11.x supports only data source profiles using a direct JDBC connection in Confluence 8.x.

  • The application server defined data source (global data source) profile is not supported in Confluence 8.x. Warning messages are displayed in View and modify data source profiles page, confluence page rendering SQL macro with global data source profile, and SQL macro editor.

  • In the View and modify data source profiles page, the pre-configured application server defined data sources show the Connection status as Failed. The rows are highlighted and show UNSUPPORTED.

  • Once the application server defined data source is converted to a connection string profile, the row gets unhighlighted in the View and modify data source profiles page. The warning message in the Confluence page and SQL macro editor disappears.

SQL for Confluence 11.x app compatibility with Confluence 7.x

The SQL for Confluence app version 11.x works seamlessly with Confluence 7.x (Confluence 7.4 to Confluence 7.20) versions, including support for application server defined data sources (JNDI data source connections).

  • No labels