• Databases and JDBC Drivers
• Free Computer Books

Databases and JDBC Drivers

This page lists the information about databases and JDBC drivers that has been tested with DB Cruiser. Information about driver files (JAR files) as well as information about driver classes and URL formats are also provided.

You may also visit the JDBC section at Sun Microsystems. They host an extensive list of JDBC drivers.

DB2 on Windows/Linux Informix IDS JavaDB/Derby Mimer MySQL Oracle PostgreSQL Microsoft SQL Server Sybase ASE

DaffodilDB FrontBase HSQL MaxDB Pervasive Pointbase Sybase ASA Cache ODBC enabled data sources

Oracle

Oracle 10.2.0.1.0	Oracle JDBC Driver 10.2.0.1.0 (Download Driver)
	Files:	ojdbc14.jar
	Driver Class:	oracle.jdbc.OracleDriver
	URL:	jdbc:oracle:thin:@<host>:<port1521>:<sid> jdbc:oracle:oci:@<host>:<port1521>:<sid>
	Important Notes: It is generally recommended that you use the latest version of the driver based on that it is supported by the version of Java you are using It is the same driver file used for both thin and OCI connections Links: » Oracle JDBC FAQ

DB2 on Windows/Linux

DB2 8.2	IBM DB2 JDBC Universal Driver 2.8.46 (Download Driver)
	Files:	db2jcc.jar db2jcc_license_cu.jar
	Driver Class:	com.ibm.db2.jcc.DB2Driver
	URL:	jdbc:db2://<host>:<port50000>/<database>
	Installation Notes: Once you have saved the zip file then unzip it and load the db2jcc.jar and db2jcc_license_cu.jar files listed above in the driver manager Useful Info: The driver property retrieveMessagesFromServerOnGetMessage can be very useful to set. Its purpose is to tell the JDBC driver to present informative messages in the SQL Commander instead of anonymous codes. Add it to the driver properties list for the actual database connection. Set the value to true.

Microsoft SQL Server

SQL Server 2000 8.00.2039  SQL Server 2005 09.00.1399	Only for SQL Server 2000: SQL Server Driver 2.2.0040 (Download Driver)
	Files:	mssqlserver.jar msbase.jar msutil.jar
	Driver Class:	com.microsoft.jdbc.sqlserver.SQLServerDriver
	URL:	jdbc:microsoft:sqlserver://<host>:<port1433>;DatabaseName=<database>
	Installation Notes: See installation notes in driver download page
	SQL Server Driver 1.0.809.102 (Download Driver)
	Files:	sqljdbc.jar
	Driver Class:	com.microsoft.sqlserver.jdbc.SQLServerDriver
	URL:	jdbc:sqlserver://<host>[:<port1433>];databaseName=<database>
	Installation Notes: See installation notes in driver download page
	jTDS 1.2 (Download Driver)
	Files:	jtds-1.2.jar
	Driver Class:	net.sourceforge.jtds.jdbc.Driver
	URL:	jdbc:jtds:<server_type>://<host>[:<port>][/<database>]
	Installation Notes: Download the jtds-1.2-dist.zip file, unpack it and load the jtds-1.2.jar in the driver manager or in the connection wizard.

Sybase ASE

Sybase ASE 12.5.3  Sybase ASE 15	jConnect 6.05 EBF13044 (Download Driver)
	Files:	jconn3.jar
	Driver Class:	com.sybase.jdbc3.jdbc.SybDriver
	URL:	jdbc:sybase:Tds:<host>:<port2048>/<database>
	Installation Notes: Download and unzip the jConnect-6_05.zip file, load the classes/jconn3.jar file in the driver manager
	jTDS 1.2 (Download Driver)
	Files:	jtds-1.2.jar
	Driver Class:	net.sourceforge.jtds.jdbc.Driver
	URL:	jdbc:jtds:<server_type>://<host>[:<port>][/<database>]
	Installation Notes: Download the jtds-1.2-dist.zip file, unpack it and load the jtds-1.2.jar in the driver manager or in the connection wizard.

Informix IDS

Informix 9.40	Informix 2.21.JC6 (Download Driver)
	Files:	ifxjdbc.jar
	Driver Class:	com.informix.jdbc.IfxDriver
	URL:	jdbc:informix-sqli://<host>:<port>/<database>:informixserver=<dbservername>
	Installation Notes: Follow the instructions provided with the downloaded file

MySQL

MySQL 4.1.19  MySQL 5.0.21	mysql-connector-java-3.1.12 (Download Driver)
	Files:	mysql-connector-java-3.1.12-bin.jar
	Driver Class:	com.mysql.jdbc.Driver
	URL:	jdbc:mysql://<host>:<port3306>/<database>
	Installation Notes: The saved archive file must be unpacked in order to located the jar file that should be loaded.

PostgreSQL

PostgreSQL 8.1.4	PostgreSQL 8.1 JDBC3 with SSL (build 407) (Download Driver)
	Files:	postgresql-8.1-407.jdbc3.jar
	Driver Class:	org.postgresql.Driver
	URL:	jdbc:postgresql://<host>:<port5432>/<database>
	Installation Notes: Just load the saved file in the driver manager

MaxDB

MaxDB 7.6	SAP DB JDBC Driver 7.6.0 (Download Driver)
	Files:	sapdbc.jar
	Driver Class:	com.sap.dbtech.jdbc.DriverSapDB
	URL:	jdbc:sapdb://<host>:<port>/<database>
	Download Notes: Download the jar file and load it in the driver manager.

FrontBase

FrontBase 4.2.4	FBJDriver 2.5.2 (Download Driver)
	Files:	frontbasejdbc.jar
	Driver Class:	com.frontbase.jdbc.FBJDriver
	URL:	jdbc:FrontBase://<host>:<port>/<database>
	Links: » Driver README

Sybase ASA

Sybase ASA 9.0.2.2452	jConnect 6.05 EBF13044 (Download Driver)
	Files:	jconn3.jar
	Driver Class:	com.sybase.jdbc3.jdbc.SybDriver
	URL:	jdbc:sybase:Tds:<host>:<port2638>/<database>
	Installation Notes: Download and unzip the jconnect60.zip file, load the classes/jconn3.jar file in the driver manager

HSQL

HSQL 1.8.0 Embedded	HSQL Database Engine Driver 1.8.0 (Download Driver)
	Files:	hsqldb.jar
	Driver Class:	org.hsqldb.jdbcDriver
	URL:	jdbc:hsqldb:<database>
	Note: The JDBC driver file is part of the database software
HSQL 1.8.0 Server	HSQL Database Engine Driver 1.8.0 (Download Driver)
	Files:	hsqldb.jar
	Driver Class:	org.hsqldb.jdbcDriver
	URL:	jdbc:hsqldb:hsql://<host>:<port>
	Note: The JDBC driver file is part of the database software

Pointbase

Pointbase 5.4 Embedded	Pointbase JDBC Driver 5.4 (Download Driver)
	Files:	pbembedded.jar
	Driver Class:	com.pointbase.jdbc.jdbcUniversalDriver
	URL:
Pointbase 5.4 Server	Pointbase JDBC Driver 5.4 (Download Driver)
	Files:	pbclient.jar
	Driver Class:	com.pointbase.jdbc.jdbcUniversalDriver
	URL:	jdbc:pointbase:server://<host>:<port>/<database>
Pointbase 5.4 Micro	Pointbase JDBC Driver 5.4 (Download Driver)
	Files:	pbmicro.jar
	Driver Class:	com.pointbase.me.jdbc.jdbcDriver
	URL:

Mimer

Mimer 9.2.4 Server	Mimer 3.16 (Download Driver)
	Files:	mimjdbc3.jar
	Driver Class:	com.mimer.jdbc.Driver
	URL:	jdbc:mimer://<host>:<port>/<database>

Pervasive

Pervasive 8.10 Server	Pervasive JDBC Driver 2.2 (Download Driver)
	Files:	pvjdbc2.jar
	Driver Class:	com.pervasive.jdbc.v2.Driver
	URL:	jdbc:pervasive://<host>:<port>/<database>

DaffodilDB

DaffodilDB 2.2 Embedded	DaffodilDBDriver 2.2 (Download Driver)
	Files:	DaffodilDB_Embedded.jar DaffodilDB_Common.jar
	Driver Class:	in.co.daffodil.db.jdbc.DaffodilDBDriver
	URL:	jdbc:daffodilDB_embedded:<database>
	Note: The JDBC driver file is part of the database software
DaffodilDB 2.2 Server	DaffodilDBDriver 2.2 (Download Driver)
	Files:	DaffodilDB_client.jar
	Driver Class:	in.co.daffodil.db.rmi.RmiDaffodilDBDriver
	URL:	jdbc:daffodilDB://<host>:<port3456>/<database>
	Note: The JDBC driver file is part of the database software

Cache

Cache 5.0 Server	InterSystems Cache JDBC 5.0 (Download Driver)
	Files:	CacheDB.jar
	Driver Class:	com.intersys.jdbc.CacheDriver
	URL:	jdbc:Cache://<host>:<port>/<namespace>

Java DB/Derby

JavaDB/Derby 10.1.3.1	Apache Derby 10.1.3.1 (Download Driver)
	Files:	derbyclient.jar
	Driver Class:	org.apache.derby.jdbc.ClientDriver
	URL:	jdbc:derby:net://<host>:<port1527>/<databaseName>