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