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 Sun?Microsystems.

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

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.0 Build 25308

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.12: mysql-connector-java-3.1.8

Files: mysql-connector-java-3.1.8-bin.jar

Driver Class: com.mysql.jdbc.Driver

URL: jdbc:mysql://<host>:<port3306>/<database>

?Download Driver

?

MySQL 5.0.2: mysql-connector-java-3.1.5-gamma

Files: mysql-connector-java-3.1.5-gamma-bin.jar

Driver Class: com.mysql.jdbc.Driver

URL: jdbc:mysql://<host>:<port3306>/<database>

?Download Driver

?

PostgeSQL 7.4.8: PostgreSQL 7.4.4 JDBC2 with SSL

Files: pg74.215.jdbc2ee.jar

Driver Class: org.postgresql.Driver

URL: jdbc:postgresql://<host>:<port5432>/<database>

?Download Driver

?

MaxDB 7.4.3: SAP DB JDBC Driver 7.4.4

Files: sapdbc.jar

Driver Class: com.sap.dbtech.jdbc.DriverSapDB

URL: jdbc:sapdb://<host>:<port>/<database>

?Download Driver

?

FrontBase 3.6.21: FBJDriver 2.4.7

Files: frontbasejdbc.jar

Driver Class: com.frontbase.jdbc.FBJDriver

URL: jdbc:FrontBase://<host>:<port>/<database>

?Download Driver

?

Sybase ASA 9.0.2.2452: jConnect 6.0 Build 25308

Files: jconn3.jar

Driver Class: com.sybase.jdbc3.jdbc.SybDriver

URL: jdbc:sybase:Tds:<host>:<port2638>/<database>

?Download Driver

?

JDataStore 6.7.25 Embedded: DataStore Driver 6.0

Files: jdsserver.jar

Driver Class: com.borland.datastore.jdbc.DataStoreDriver

URL: jdbc:borland:dslocal:<file>

?Download Driver

?

JDataStore 6.7.25 Server: DataStore Driver 6.0

Files: jdsremote.jar

Driver Class: com.borland.datastore.jdbc.DataStoreDriver

URL: jdbc:borland:dslocal:<file>

?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