Database JDBC Drivers

This page provides the download links for the JDBC drivers for all databases currently supported for Confluence. You will need to make the driver available to your application server, as described in the appropriate setup guide.

Note: We bundle some JDBC drivers with Confluence, as shown below. If you are using a direct JDBC connection, you do not need to download or install the drivers that are bundled. If you are connecting via a datasource, or if you are using a database whose driver is not bundled, you will need to download and install the drivers manually.

Database

JDBC driver bundled with Confluence?

JDBC drivers

Notes More information

PostgreSQL

(tick)

9.2-1004 JDBC 4 driver download

The JDBC 4 driver will work under the 1.7 JVM. If you want to use other drivers, you can download it from the PostgreSQL website. However, we recommend that you use the bundled JDBC 4 driver. Database Setup for PostgreSQL

Microsoft SQL Server

(tick)

jTDS 1.2.2 driver download

The above version is the version bundled with Confluence. All our testing is done on that version. We do not know of any issues with later versions, so you are free to use them if you have tested them and find there are no issues in your environment. However, later versions are technically not supported. That means that if you do run into any problems, Atlassian Support may require you to move back to the above fully- tested version for troubleshooting.

Database setup for Microsoft SQL Server

MySQL

(error)

Connector\J 5.1.30 driver download

Note: In Confluence 5.1 and later, the MySQL drivers are no longer included in the Confluence distribution. For more information please refer to the Confluence 5.1 Upgrade Notes.

Database setup for MySQL

Oracle

(error)

JDBC driver downloads

  • For Oracle 11.1, use the 11.1.0.7.0 driver (ojdbc6.jar).
  • For Oracle 11.2, use the 11.2.0.4.0 driver (ojdbc6.jar).
  • For Oracle 12c use the 12.1.0.1 driver (ojdbc7.jar)

We recommend using the thin drivers only.

See the Oracle JDBC driver FAQ.

Database setup for Oracle

Was this helpful?

Thanks for your feedback!

23 Archived comments

  1. User avatar

    Anonymous

    JTDS is now at v1.2.5 -- is there any reason to use 1.2.2 over 1.2.5 for JIRA's sake?

    25 Jan 2011
  2. User avatar

    Robert Glover

    A word of warning to PostgreSQL users.    It is not clearly stated that using PostgreSQL version 9 with Confluence 3.5 (and other versions of Confluence as well) will cause the Plugin Manager to not work.  The solution is easy if you know about it but debilitating it you don't.  Here are the links to the solution: 

    http://confluence.atlassian.com/display/CONFKB/Cannot+install+new+plugins+-+ZipException+-+error+in+opening+zip+file

    http://confluence.atlassian.com/display/CONFKB/Getting+ZipException+Error+when+Installing+a+New+Plugin+Due+to+Postgres+9+Configuration

    http://forums.atlassian.com/message.jspa?messageID=257357112

    25 Apr 2011
  3. User avatar

    John Rehill

    I'm wondering the same as above, Confluence 3.5.2 comes with jtds 1.2.2 but 1.2.5 is now available.

    Can I simply replace 1.2.2 with 1.2.5 as I am only using Confluence and use no JIRA installation?

    Is there any performance/usablity issues/improvements either way?

    10 May 2011
  4. User avatar

    Anonymous

    I'm using 1.2.6. Seems to work fine.

    22 Oct 2012
  5. User avatar

    Paul Buckle

    I would also like to know the official standpoint on using later versions of JTDS.

    This page implies only 1.2.2 is supported, yet this one directs you to the JTDS Project page, where I suggest most people would automatically download the latest version available, as there is no instruction to the contrary.

    I have been happily using 1.2.6 for a while now, but that has since been superceded by 1.2.7 and now 1.3.0.

    Could Atlassian please comment?

    Thank you.

    21 Dec 2012
  6. User avatar

    Sarah Maddox [Atlassian]

    Hallo Paul, John and all enquiring about the JTDS version (smile)

    I've forwarded your questions to one of our database experts. I'm sure he'll respond soon. If not, I'll chase this up further.

    Cheers, Sarah

    23 Dec 2012
    1. User avatar

      Paul Buckle

      Thank you Sarah.

      24 Dec 2012
      1. User avatar

        Sarah Maddox [Atlassian]

        Hallo Paul

        I think my database expert must be away for the holidays. Just letting you know I haven't forgotten, and have just now forwarded the question to the support team.

        Cheers, Sarah

        27 Dec 2012
        1. User avatar

          Denise Unterwurzacher [Atlassian]

          Hi all. We currently bundle JTDS 1.2.2 with Confluence, and all our testing is done on that version. Having said that, we don't know of any issues with later versions, so you're free to use them if you have tested them and find there are no issues in your environment, but they are technically not supported. That means that if you do run into any problems, Support may require you to move back to 1.2.2 for troubleshooting.

          Hope this helps!

          28 Dec 2012
          1. User avatar

            Paul Buckle

            Hi Denise, thank you for this information.

            I'm surprised Atlassian still test/develop on a version that's now over 5 years old, but if that's how it is then I would at least suggest this page should be suitably amended: As I mentioned above, I imagine most people would automatically download the latest version available (as there is no instruction to the contrary) and would therefore unwittingly end up building a "technically not supported" Confluence instance.

            31 Dec 2012
            1. User avatar

              Sarah Maddox [Atlassian]

              Hallo Paul and Denise

              Thank you for following up on this. I have updated both this page and the SQL Server setup page, to clarify the information about the driver versions.

              Cheers, Sarah

               

              01 Jan 2013
  7. User avatar

    Orlando Caro

    Confluence 5.1.2 is compatible with Java 7, but uses jTDS 1.2.2?  Only jTDS 1.3.0 is compatible with Java 7.

    RE: Microsoft SQL Server

    08 May 2013
  8. User avatar

    Anonymous

    What about if you want to use No SQL db?

    17 May 2013
  9. User avatar

    Johan

    Hi,

    it say "For Oracle 11.2, use the 11.2.0.1.0 driver (Java 6 ojdbc6.jar)."  in upgrader instructions (v 3.5.15 -> 4x ->5.x)
    Is that still valid or is it better/ok to use 11.2.0.2.0 (Java 6 ojdbc6.jar) when runnning 11.2.0.2.0?

    05 Jul 2013
  10. User avatar

    Adeel Ahmed

    I have been using NetBeans IDE for quite long time. It automatically installs every driver, plugin or package for Java development. There might exist some issues regarding connectivity due to firewall policies. Otherwise , the databases can be easily accessed through these drivers. Great post

    23 Apr 2014
  11. User avatar

    Stephen Gramm

    Which Oracle JDBC file should be used for Oracle version 11.2.0.2.3?

    14 Jul 2014
  12. User avatar

    David Nelsen

    Can anyone tell me where the MySQL jconnector jar should be placed on a linux confluence install? The directions that I am seeing to put it in the WEB-INF/lib file don't produce any results neither does the original confluence lib folder.  

    Thanks.

    05 May 2015
    1. User avatar

      Lachlan Dally

      Hi David,

      The WEB-INF/lib path is what you're after. If you're seeing problems with this, please reach out to http://support.atlassian.com/ and we'll figure out what the issue is (smile)

      Cheers,
      Lachlan

      07 May 2015
  13. User avatar

    Bill Hamilton

    What is the oldjbc7.jar for Oracle 12c? I've never heard of such a jar file and it's not listed on their website.

    08 Jul 2015
    1. User avatar

      Giles Brunning [Atlassian Technical Writer]

      Hi Bill,

      Looks like a typo; it should be ojdbc7.jar.

      20 Jul 2015
  14. User avatar

    Jonathan Hult

    Can the MariaDB connector (which also works for MySQL databases) be bundled since it is released under LGPL?

    https://downloads.mariadb.org/connector-java/

    05 Aug 2015
    1. User avatar

      Rachel Robins [Atlassian Tech Writer]

      Hi Jonathan, I'm afraid we don't support running Confluence with MariaDB.  See Supported Platforms for more info. 

      06 Aug 2015
    1. User avatar

      Jonathan Hult

      I understand that MariaDB is not supported. However, their driver supports MySQL. Thus, you could bundle their driver and not require downloading a separate driver for MySQL.

      07 Aug 2015
Powered by Confluence and Scroll Viewport