Database drivers

MySQL

• Required File(s): mysql-connector-java-nn-bin.jar
• Java Driver Class: com.mysql.jdbc.Driver
• URL Pattern: jdbc:mysql://<host>:<port3306>/<db>
• Website: MySQL

Oracle

• Required File(s): ojdbc15.jar (For Java 1.5), ojdbc16.jar (For Java 1.6)
• Java Driver Class: oracle.jdbc.OracleDriver
• URL Pattern: jdbc:oracle:thin://<host>:<port>/<service> jdbc:oracle:thin:<host>:<port>:<SID> jdbc:oracle:thin:<TNSName> (from 10.2.0.1.0)
• Website: Oracle

PostgreSQL

• Required File(s): postgresql-nn.jdbc3.jar
• Java Driver Class: org.postgresql.Driver
• URL Pattern: jdbc:postgresql://<host>:<port5432>/<db>
• Website: PostgreSQL

HSQLDB

HSQLDB may run in two modes: local and server mode. In the local mode the database engine is started directly by the driver, and the software will run in the same thread, locally.

• Required File(s): hsqldb.jar
• Java Driver Class: org.hsqldb.jdbcDriver
• URL Pattern: jdbc:hsqldb:<db> or jdbc:hsqldb:hsql://<host>:<port> for the server mode
• Website: HSQLDB

JavaDB/Derby

• Required File(s): derbyclient.jar
• Java Driver Class: org.apache.derby.jdbc.ClientDriver
• URL Pattern: jdbc:derby:net://<host>:<port1527>/<db>
• Website: Apache Software Foundation

Mimer

• Required File(s): mimjdbc3.jar
• Java Driver Class: com.mimer.jdbc.Driver
• URL Pattern: jdbc:mimer://<host>:<port>/<db>
• Website: Mimer Information Technology

Pervasive

• Required File(s): pvjdbc2.jar
• Java Driver Class: com.pervasive.jdbc.v2.Driver
• URL Pattern: jdbc:pervasive://<host>:<port>/<db>
• Website: Pervasive

Informix

• Required File(s): ifxjdbc.jar
• Java Driver Class: com.informix.jdbc.IfxDriver
• URL Pattern: jdbc:informix-sqli://<host>:<port>/<db>:informixserver=<dbservername>
• Website: IBM

Microsoft SQL Server

• Required File(s): sqlserver.jar
• Java Driver Class: com.microsoft.jdbc.sqlserver.SQLServerDriver
• URL Pattern: jdbc:microsoft:sqlserver://<host>:<port1433>;DatabaseName=<db>
• Website: Microsoft

jTDS JDBC Driver

Download the jtds-nn-dist.zip file, unzip it and then load the jtds.jar file

• Required File(s): jtds-1.2.2.jar
• Java Driver Class: net.sourceforge.jtds.jdbc.Driver
• URL Pattern: jdbc:jtds:sqlserver://<host>[:<port>][/<db>]
• Website: jTDS web site

Microsoft SQL Server 2005

• Required File(s): sqljdbc.jar
• Java Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
• URL Pattern: jdbc:sqlserver://<host>[:<port1433>];databaseName=<db>
• Website: Microsoft

jTDS JDBC Driver

Download the jtds-nn-dist.zip file, unzip it and then load the jtds.jar file

• Required File(s): jtds-1.2.2.jar
• Java Driver Class: net.sourceforge.jtds.jdbc.Driver
• URL Pattern: jdbc:jtds:sqlserver://<host>[:<port>][/<db>]
• Website: jTDS web site

Microsoft Access

The standard jdbc-odbc driver does not implement the required methods, so you can only try one of the commercial drivers like Easysoft one. It is also possible to install one of the SQLServers and import the Access database in. Than follow the SQLServer instructions to import the schema in DbSchema.

Cache

• Required File(s): CacheDB.jar
• Java Driver Class: com.intersys.jdbc.CacheDriver
• URL Pattern: jdbc:Cache://<host>:<port>/<namespace>
• Website: Cache

DaffodilDB

DaffodilDb may run in two modes: local and server mode. In the local mode the database engine is started directly by the driver, and the software will run in the same thread, locally.

Local version

• Required File(s): DaffodilDB_Embedded.jar, DaffodilDB_Common.jar
• Java Driver Class: in.co.daffodil.db.jdbc.DaffodilDBDriver
• URL Pattern: jdbc:daffodilDB_embedded:<db>
• Website: DaffodilDB

Server version

• Required File(s): DaffodilDB_client.jar
• Java Driver Class: in.co.daffodil.db.rmi.RmiDaffodilDBDriver
• URL Pattern: jdbc:daffodilDB://<host>:<port3456>/<db>
• Website: DaffodilDB

DB2 for Windows/Linux

• Required File(s): db2jcc.jar, db2jcc4.jar, db2jcc_license_cu.jar (optional)
• Java Driver Class: com.ibm.db2.jcc.DB2Driver
• URL Pattern: jdbc:db2://<host>:<port50000>/<db>
• Website: IBM

FrontBase

• Required File(s): frontbasejdbc.jar
• Java Driver Class: com.frontbase.jdbc.FBJDriver
• URL Pattern: jdbc:FrontBase://<host>:<port>/<db>
• Website: FrontBase

PointBase

HSQLDB may run in two modes: local and server mode. In the local mode the database engine is started directly by the driver, and the software will run in the same thread, locally.

Local version

• Required File(s): pbembedded.jar
• Java Driver Class: com.pointbase.jdbc.jdbcUniversalDriver
• URL Pattern: jdbc:pointbase:embedded:PBPUBLIC
• Website: PointBase

Server version

• Required File(s): pbclient.jar
• Java Driver Class: com.pointbase.jdbc.jdbcUniversalDriver
• URL Pattern: jdbc:pointbase:server://<host>:<port>/<db>
• Website: PointBase

Sqlite

Download the driver from here. The driver does not implement all the interface methods. Therefore the reverse engineering of Foreign Keys does not work.

• Required File(s): sqlitejdbc-v056.jar
• Java Driver Class: org.sqlite.JDBC
• URL Pattern: jdbc:sqlite:<DB>
• Website: Sqlite

Sybase SQL Anywhere

The driver is usually delivered as zip file. First you need to unzip this file and locate then jconn3.jar file which usually is stored in the classes directory.

• Required File(s): jconn3.jar
• Java Driver Class: com.sybase.jdbc3.jdbc.SybDriver
• URL Pattern: jdbc:sybase:Tds:<host>:<port>?ServiceName=<db>
• Website: Sybase

Sybase ASE

• Required File(s): jtds-1.2.2.jar
• Java Driver Class: net.sourceforge.jtds.jdbc.Driver
• URL Pattern: jdbc:jtds:sybase://<host>[:<port>][/<db>]
• Website: JTDS