Databases and JDBC Drivers

This page contains information about databases and some of their recommended JDBC drivers that can be used to import data or extract XML Schema from database structure features. This information is meant to provide general details to help you get started, but you should refer to the documentation or website for your particular type of database to make sure the details are accurate.

An extensive list of JDBC drivers is also available at JDBC section at Oracle.

Oracle JDBC Driver 10.1.0.2.0

• Files: ojdbc14.jar
• Driver Class: oracle.jdbc.OracleDriver
• URL: jdbc:oracle:thin:@<host>:<port1521>:<sid>
• jdbc:oracle:oci:@<host>:<port1521>:<sid>
• OBS: The same driver file used for both thin and OCI connections

 Download Driver

DB2 8.2: IBM DB2 JDBC Universal Driver 2.8.46

• Files: db2jcc.jar, db2jcc_license_cu.jar
• Driver Class: com.ibm.db2.jcc.DB2Driver
• URL: jdbc:db2://<host>:<port50000>/<database>

 Download Driver

Microsoft JDBC Driver 10.2 for SQL Server

• Files: mssqlserver.jar, msbase.jar, msutil.jar
• Driver Class: com.microsoft.jdbc.sqlserver.SQLServerDriver
• URL: jdbc:microsoft:sqlserver://<host>:<port1433>;DatabaseName=<database>

 Download Driver

SAP ASE jConnect Driver 12.5.4

• Files: jconn3.jar
• Driver Class: com.sybase.jdbc3.jdbc.SybDriver
• URL: jdbc:sybase:Tds:<host>:<port2048>/<database>

IBM Informix 9.40

• Files: ifxjdbc.jar
• Driver Class: com.informix.jdbc.IfxDriver
• URL: jdbc:informix-sqli://<host>:<port>/<database>:informixserver=<dbservername>

MySQL 4.1.19: mysql-connector-java-3.1.12

• Files: mysql-connector-java-3.1.12-bin.jar
• Driver Class: com.mysql.jdbc.Driver
• URL: jdbc:mysql://<host>:<port3306>/<database>

 Download Driver

MySQL 5.7: mysql-connector-java-3.1.12

• Files: mysql-connector-java-3.1.12-bin.jar
• Driver Class: com.mysql.jdbc.Driver
• URL: jdbc:mysql://<host>:<port3306>/<database>

 Download Driver

PostgeSQL 10.1

• Files: pg74.216.jdbc3.jar
• Driver Class: org.postgresql.Driver
• URL: jdbc:postgresql://<host>:<port5432>/<database>

 Download Driver

Sybase ASA 9.0.2.2452: jConnect 6.05 EBF13044

• Files: jconn3.jar
• Driver Class: com.sybase.jdbc3.jdbc.SybDriver
• URL: jdbc:sybase:Tds:<host>:<port2638>/<database>

 Download Driver

Cache 5.0 Server: InterSystems Cache JDBC 5.0

• Files: CacheDB.jar
• Driver Class: com.intersys.jdbc.CacheDriver
• URL: jdbc:Cache://<host>:<port>/<namespace>

 Download Driver

MariaDB Connector/J 2.2 Series

• Files: mariadb-java-client-1.1.7.jar
• Driver Class: org.mariadb.jdbc.Driver
• URL: jdbc:mysql://<host>:<port3360>

 Download Driver