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 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 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 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>
 SAP ASE Info Site (Driver is part of the SDK for the installation)

 

IBM Informix 9.40

  • Files: ifxjdbc.jar
  • Driver Class: com.informix.jdbc.IfxDriver
  • URL: jdbc:informix-sqli://<host>:<port>/<database>:informixserver=<dbservername>
 Contact IBM Informix JDBC for information about obtaining the driver

 

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 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 Download Driver

 

PostgeSQL 10.1

  • Files: pg74.216.jdbc3.jar
  • Driver Class: org.postgresql.Driver
  • URL: jdbc:postgresql://<host>:<port5432>/<database>
Download 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 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 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 Download Driver