Contents x
    Data Source - RDBMS Version Support Chart
      • Print
      • PDF
      Contents

      Data Source - RDBMS Version Support Chart

        • Print
        • PDF
        Article summary

        summary

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

        Data Source ConnectorTROCCO Supported Versionsremarks
        Amazon RedshiftPostgreSQL JDBC Driver 9.4-1205-JDBC41Uses 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.
        MySQLMySQL Connector Java 5.1.49The 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 DatabaseSupported 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 driverMicrosoft SQLServer JDBC Driver 8.2jTDS 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-✓
        Was this article helpful?
        What's Next