Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-43367

Inconsistent documentation about not changing Postgres JDBC driver for JIRA standalone

XMLWordPrintable

    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      Hi,
      Recently I had an issue about the Postgres JDBC driver and I found an inconsistence at JIRA documents.
      The standalone installation of JIRA does not require changing the JDBC driver if JIRA is not WAR (Connecting JIRA to PostgreSQL|https://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+PostgreSQL]), but the Supported Platforms document says or seems to say that he DB version should match the JDBC version. This information is causing some noise at the customers and took me some time to understand what should I do. I think is important to clear this out to reduce this friction.

      I'm not sure about the solution. Maybe is recommend leave the old JDBC 9.0 with newer versions of Postgres since this is the bundle driver or is recommend follow the JIRA war process to install the JDBC new driver. The comment from James Rice (at references below) resumes this inconsistence.

      References for this request:

      Thanks a lot,
      Daniel P Santos

          Form Name

            [JRASERVER-43367] Inconsistent documentation about not changing Postgres JDBC driver for JIRA standalone

            William Crighton [CCC] added a comment -

            dsantos
            Ran across this looking for a good answer on upgrading to J7 with an expired support license.
            I cannot read the references on your request so this comment might be redundant.

            When I look at the referenced 'connect jira to psql' page the text next to the drivers reads:

            • Supported PostgreSQL databases use the latest JDBC driver listed here.

            And on the linked page (https://jdbc.postgresql.org/) there's a simple download link. Some interesting intel in the FAQ however:

            1. If you are using older versions of Postgres (7 and 8) for in-house applications and JIRA the older versions of the JDBC driver worked better

              By default, 8.x versions of the driver use protocol version 3 when communicating with servers 7.4 or higher. This protocol allows for more efficient query execution and enables true server-side prepared statements,

            NOTE: your supported platforms link brings up a Confluence/Platforms page, not a JIRA/Platforms page

            ...in hindsight, that's not all that interesting. Still...in my experience the latest 9x JDBC driver from PostGreSQL has always worked, and worked well, with v9 databases. And reading through the language on the referenced JIRA/PGSQL config the language seems pretty clear. However, you are right that postgres keeps releasing new versions that aren't marked 'supported' for JIRA, and that seems a bit wrong.

            William Crighton [CCC] added a comment - dsantos Ran across this looking for a good answer on upgrading to J7 with an expired support license. I cannot read the references on your request so this comment might be redundant. When I look at the referenced 'connect jira to psql' page the text next to the drivers reads: Supported PostgreSQL databases use the latest JDBC driver listed here. And on the linked page ( https://jdbc.postgresql.org/ ) there's a simple download link. Some interesting intel in the FAQ however : If you are using older versions of Postgres (7 and 8) for in-house applications and JIRA the older versions of the JDBC driver worked better By default, 8.x versions of the driver use protocol version 3 when communicating with servers 7.4 or higher. This protocol allows for more efficient query execution and enables true server-side prepared statements, NOTE: your supported platforms link brings up a Confluence/Platforms page, not a JIRA/Platforms page ...in hindsight, that's not all that interesting. Still...in my experience the latest 9x JDBC driver from PostGreSQL has always worked, and worked well, with v9 databases. And reading through the language on the referenced JIRA/PGSQL config the language seems pretty clear. However, you are right that postgres keeps releasing new versions that aren't marked 'supported' for JIRA, and that seems a bit wrong.

              rreidl Robin Reidl (Inactive)
              dsantos Daniel Santos (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: