Databases and JDBC Drivers

This page lists the most current information about databases and some of their JDBC drivers that can be used for 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 (formerly from Sun).

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

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