Data Source - RDBMS Version Support Chart

Prev Next

summary

Corresponding table of driver versions used in the Data Source RDBMS-based Connector.

Data Source Connector TROCCO Supported Versions remarks
Amazon Redshift PostgreSQL JDBC Driver 9.4-1205-JDBC41 Uses the same drivers as PostgreSQL
Microsoft SQL Server
  • Microsoft SQLServer JDBC Driver 8.2
  • jTDS Driver 1.3.1
    		•  See Microsoft SQL Server Compatibility below for details.
    MySQL MySQL Connector Java 5.1.49 The left column can also work with MySQL 8.0 series.
    However, the caching_sha2_password authentication feature added to MySQL 8.0 series is not supported.
    Oracle Database Supported JDBC jar files and Oracle Database versions are as follows

    • ojdbc7.jar
      • 12.1 or 12cR1
    • ojdbc8.jar
      • 12.2 or 12cR2
      • 18.x
      • 19.x
      • 21.x
    		 See FAQ on Oracle JDBC for more information
    PostgreSQL
  • PostgreSQL JDBC Driver 42.5.1
  • PostgreSQL JDBC Driver 9.4-1205-JDBC41
    		•  -

    supplement

    Microsoft SQL Server Compatibility

    The supported DB versions are as follows
    For more information, see the JDBC Driver for Microsoft SQL Server support table andThe jTDS Project.

    DB version \ TROCCO-supported driver Microsoft SQLServer JDBC Driver 8.2 jTDS Driver 1.3.1
    Microsoft SQL Server 2019 ✓ -
    Microsoft SQL Server 2017 ✓ -
    Microsoft SQL Server 2016 ✓ -
    Microsoft SQL Server 2014 ✓ -
    Microsoft SQL Server 2012 ✓ ✓
    Microsoft SQL Server 2008 - ✓
    Microsoft SQL Server 2005 - ✓
    Microsoft SQL Server 2000 - ✓
    Microsoft SQL Server 7 - ✓
    Microsoft SQL Server 6.5 - ✓