Overview Features & Editions Screenshots Download Drivers Purchase Support

Databases and Drivers

DbSchema can connect to any relational databases !. To connect you need the proper JDBC driver.

After downloading and installing DbSchema you will be prompted to connect to database. You can choose your database from a list. For some databases a JDBC driver is already included in the application. If your driver is not present please search for a driver :

... in the database software. Usually each software is shipped with a JDBC driver. The driver is a file with the extension '.jar', and a name with 'jdbc' or similar.
Search in internet for the driver, like 'mysql jdbc driver'.

Drivers can be uploaded in DbSchema using the Jdbc Drivers Manager Dialog. If you cannot connect to the database using the uploaded driver please check that the driver and the database are on compatible versions and that the driver URL is correct. Also make sure no firewall or antivirus are restricting the access to the database and the database is up an running.

Major Databases And How To Connect

Cache
DaffodilDB
DB2 for Windows/Linux
Firebird
FrontBase
Informix
JavaDB/Derby

Microsoft_SQL_Server
Microsoft_SQL_Server_2005
Microsoft_Access
Microsoft_Azure
TDS JDBC Driver
Mimer
MySQL

Oracle
Pervasive
PointBase
PostgreSQL
Sqlite
Sybase_SQL_Anywhere
Sybase_ASE

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':

Enabling this you will be allowed to connect to MySql from another computer. Remember the password you set here, it will be requested when connecting to the database as user root.

Tip how to enable remote access to MySql after installation :

On the server type in the command prompt or terminal mysql -u root -p <root_password> The mysql console should start.
List the databases using show databases
View the configured grants using select * from db;
Enable remote access for a user foo using GRANT ALL ON foo.* TO bar@'202.54.10.20' IDENTIFIED BY 'PASSWORD'; Here you have to edit the user ( put your user instead of foo ), the IP of the client machine and the root password.

If this didn't help, please try to search the web for tutorials.

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

Watch a You Tube video How to configure SqlServer 2008 for jdbc connections.

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.

Microsoft Azure

Azure is a cloud database. Check how to connect here.

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