Overview Editions & Features Screenshots Download Drivers Purchase Support

JDBC Database drivers

DbSchema can connect to any relational database compatible with the JDBC standard. You may connect also to databases which are not listed here, but provides a JDBC driver. Here we have listed a summary of the most known databases and links to their drivers and websites.

The workflow is:

  1. download and install DbSchema
  2. connect to the database you wish. The database driver is required for this. DbSchema has already included few drivers, like for MySql, PostgreSql, Derby, Oracle and SqlServer. The driver is a file with the extension .jar, usually provided by the company who wrote the database software. Therefore the driver file can be found in the database installation files. Most of the times the database company website provides detailed information about the compatible drivers. You may upload the driver in DbSchema when connecting to the database from the application.

Attention ! When using the drivers we have included in our software you should check the version compatibility between the driver and the database you use.

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
Few MySql installation tips: Install MySql from http://www.mysql.com. During installation go for a detailed install, and when you are prompted for the user password check the 'Enable root access from remote machines'. This will enable to connect to this database even when you run DbSchema from another machine. If this is not checked, you will get 'Connection refused' messages when you will try to connect. Also remember the password you type here in, it will be requested in DbSchema ( connect from DbSchema using user root and password you enter here ).

Configure MySql for remote connections

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 here.
  • Required File(s): sqlite-jdbc-xxx.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

Firebird

  • Required File(s): jaybird-full-xxx.jar
  • Java Driver Class: org.firebirdsql.jdbc.FBDriver
  • URL Pattern: jdbc:firebirdsql://<HOST>:<PORT:3050>/<FILE>
  • Website: Firebird