Versions Compared

Old Version 17

changes.mady.by.user Nisha Shantilal

Saved on

compared with

New Version Current

changes.mady.by.user Nisha Shantilal

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

The SQL for Confluence (Pro Edition) 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.

...

  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.

    Image RemovedImage Added

  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.

    Image RemovedImage Added

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

    Image RemovedImage Added
Info

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 , the warning message disappears in the SQL macro editor. Alsoand save the profile, the corresponding row gets unhighlighted in the View and modify data source profiles page.

...

Modify Reconfigure the application server defined data source and provide the connection string details with the Data source name as Noneprofile to a connection string profile.

SQL for Confluence (Pro Edition) 11.x app updates in Confluence 8.x

The SQL for Confluence (Pro Edition) 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 and you may see warning messages in . Warning messages are displayed in View and modify data source profiles page page, confluence page rendering SQL macro with global data source profile, and SQL macro editor.

    Image Added

  • In

    the

    the View and modify data source profiles

    page

     page, the pre-configured application server defined data sources

    shows the

    show the Connection status

    as

     as Failed. The

    global data source profile

    rows are highlighted and

    shows

    show UNSUPPORTED.

  • The View and modify data source profiles page and the SQL macro editor shows warning message for application server defined data sources.

  • Once

    you convert

    the application server defined data source is converted to a connection string profile, the row

    highlighted

    gets unhighlighted in

    in

    the View and modify data source profiles

    page, the

     page. The warning message in the Confluence page and SQL macro editor disappears.

SQL for Confluence (Pro Edition) 11.x app compatibility with Confluence 7.x

The SQL for Confluence (Pro Edition) 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).