List of Suggested JDBC Drivers
The following is a list of JDBC drivers for different relational database systems.
RDBMS | Recommended Driver | Example of JAR File | Driver Class | Download From |
|---|---|---|---|---|
H2 | H2 driver | h2-1.3.171.jar | org.h2.Driver | |
MySQL | Connector/J | mysql-connector-java-8.0.25.jar | com.mysql.cj.jdbc.Driver | |
Oracle | Oracle JDBC driver | ojdbc8.jar | oracle.jdbc.driver.OracleDriver | https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html |
PostgreSQL | PostgreSQL JDBC driver | postgresql-42.6.0.jar | org.postgresql.Driver | |
SQL Server | Microsoft JDBC Driver | mssql-jdbc-12.8.1.jre8.jar | com.microsoft.sqlserver.jdbc.SQLServerDriver | https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server |
Sybase | jTDS | jtds-1.3.0.jar | net.sourceforge.jtds.jdbc.Driver | |
Teradata | Teradata driver | terajdbc4.jar and tdgssconfig.jar | com.teradata.jdbc.TeraDriver |
In most cases, the only file you need to download is the .jar driver file (note that the version number may be different to the one shown in the examples here).
The exception to this is the Microsoft JDBC driver for SQL Server. This is supplied in an self extracting ZIP archive; there are other files in the archive that are required in order to use the driver, so you will need the entire archive.
H2 file mode is not supported by the SuperCHANNEL GUI and can only by used with SNU (the SuperCHANNEL Command Line Utility). H2 server mode works with both the GUI and SNU.