Databases and JDBC Drivers

This page lists the most current information about databases and some of their JDBC drivers that can be used to import data or extract XML Schema from database structure features. Information about what file(s) to load in the Preferences->Database->JDBC Drivers, as well as information about driver classes and URL formats, are also provided. An extensive list of JDBC drivers is also available at JDBC section at Oracle.

Oracle 10.2.0.1.0: 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

 

SQL Server 2000 - 8.00.2039: SQL Server Driver 2.2.0040

  • 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

 

Sybase ASE 12.5.3: jConnect 6.05 EBF13044

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

 

Informix 9.40: Informix 2.21.JC6

  • Files: ifxjdbc.jar
  • Driver Class: com.informix.jdbc.IfxDriver
  • URL: jdbc:informix-sqli://<host>:<port>/<database>:informixserver=<dbservername>
Download Download 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.0.21: 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 7.4.12: PostgreSQL 7.4.5 JDBC3 with SSL (build 216)

  • 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: JDBC Driver 1.1.7

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