Cache

Intersystems Cache JDBC

The Cache JDBC Driver is a pure Java driver.

Required File(s)
CacheDB.jar

Default Driver Class
com.intersys.jdbc.CacheDriver

JDBC URL Format
jdbc:Cache://<host>:<port>/<namespace>

More information and download
Cache

DaffodilDB

DaffodilDBDriver - Embedded

In the Embedded Edition of Daffodil DB (when invoked from an application running on the same JVM as Daffodil DB), the JDBC driver supports connections to a Daffodil DB database in the local mode. Network transport is not required to access the database. In Networked (Client/Server) mode, the client application dispatches JDBC requests to the Daffodil DB server over a network.

Applications running in embedded mode use a different driver from that used by applications running in the client/server mode.

Required File(s)
DaffodilDB_Embedded.jar
DaffodilDB_Common.jar

Default Driver Class
in.co.daffodil.db.jdbc.DaffodilDBDriver

JDBC URL Format
jdbc:daffodilDB_embedded:<database>

More information and download
DaffodilDB

Notes
The JDBC driver files are part of the database software

DaffodilDBDriver - Server

The Daffodil DB JDBC driver is a native protocol for all Java drivers (Type #4 among the categories defined by Sun Microsystems). Type 4 drivers are direct-to-database, pure Java drivers ("thin" driver). Type 4 drivers takes JDBC calls and translates them into the network protocol (proprietary protocol) used directly by any Database Management System (DBMS). Thus, client machines or application servers can make direct calls to the DBMS server. Type 4 drivers provide faster performance and direct access to DBMS features.

Required File(s)
DaffodilDB_client.jar

Default Driver Class
in.co.daffodil.db.rmi.RmiDaffodilDBDriver

JDBC URL Format
jdbc:daffodilDB://<host>:<port3456>/<database>

More information and download
DaffodilDB

Notes
The JDBC driver files are part of the database software

DB2 LUW

IBM DB2 JDBC Universal Driver

The IBM Data Server Driver for JDBC and SQLJ (formerly known as IBM Driver for JDBC and SQLJ) is a single application driver to support the most demanding Java applications. This agile driver can be used as in type 4 mode.

This driver is co-packaged with DbVisualizer.

Required File(s)
db2jcc.jar

Default Driver Class
com.ibm.db2.jcc.DB2Driver

JDBC URL Format
jdbc:db2://<host>:<port50000>/<database>

More information and download
IBM

Notes
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.

FrontBase

FrontBase JDBC Driver

FrontBase JDBC driver

Required File(s)
frontbasejdbc.jar

Default Driver Class
com.frontbase.jdbc.FBJDriver

JDBC URL Format
jdbc:FrontBase://<host>:<port>/<database>

More information and download
FrontBase

Notes
Driver Read Me

HSQLDB

HSQLDB Database Engine Driver - Embedded

HSQLDB JDBC Driver

Required File(s)
hsqldb.jar

Default Driver Class
org.hsqldb.jdbcDriver

JDBC URL Format
jdbc:hsqldb:<database>

More information and download
HSQLDB Community

Notes
The JDBC driver file is part of the database software

HSQLDB Database Engine Driver - Server

HSQLDB JDBC Driver

Required File(s)
hsqldb.jar

Default Driver Class
org.hsqldb.jdbcDriver

JDBC URL Format
jdbc:hsqldb:hsql://<host>:<port>

More information and download
HSQLDB Community

Notes
The JDBC driver file is part of the database software

Informix

Informix JDBC Driver

A Java database connectivity (JDBC) driver -- the JavaSoft specification of a standard API that allows Java programs to access database management systems.

Required File(s)
ifxjdbc.jar

Default Driver Class
com.informix.jdbc.IfxDriver

JDBC URL Format
jdbc:informix-sqli://<host>:<port>/<database>:informixserver=<dbservername>

More information and download
IBM

Notes
Follow the instructions provided with the downloaded file

JavaDB/Derby

Apache Derby

JavaDB/Derby is a full-featured, open source relational database management system (RDBMS) that is based on Java™ and SQL.

This driver is co-packaged with DbVisualizer.

Required File(s)
derbyclient.jar

Default Driver Class
org.apache.derby.jdbc.ClientDriver

JDBC URL Format
jdbc:derby:net://<host>:<port1527>/<databaseName>

More information and download
Apache Software Foundation

Microsoft SQL Server

SQL Server 2000 Driver for JDBC

The Microsoft SQL Server 2000 Driver for JDBC is a Type 4 JDBC driver that provides highly scalable and reliable connectivity for the enterprise Java environment. This driver provides JDBC access to SQL Server 2000 through any Java-enabled applet, application, or application server.

Required File(s)
mssqlserver.jar
msbase.jar
msutil.jar

Default Driver Class
com.microsoft.jdbc.sqlserver.SQLServerDriver

JDBC URL Format
jdbc:microsoft:sqlserver://<host>:<port1433>;DatabaseName=<database>

More information and download
Microsoft

Microsoft SQL Server 2005 JDBC Driver

The SQL Server 2005 JDBC Driver is available to all SQL Server users at no additional charge, and provides access to SQL Server 2000 and SQL Server 2005 from any Java application, application server, or Java-enabled applet. This driver is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs).

Required File(s)
sqljdbc.jar

Default Driver Class
com.microsoft.sqlserver.jdbc.SQLServerDriver

JDBC URL Format
jdbc:sqlserver://<host>[:<port1433>];databaseName=<database>

More information and download
Microsoft

jTDS JDBC Driver

jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000 and 2005) and Sybase (10, 11, 12, 15).

This driver is co-packaged with DbVisualizer.

Required File(s)
jtds-1.2.2.jar

Default Driver Class
net.sourceforge.jtds.jdbc.Driver

JDBC URL Format
jdbc:jtds:microsoft://<host>[:<port>][/<database>]

Example:
jdbc:jdtds:microsoft://localhost:5000/myDB
jdbc:jdtds:microsoft://192.168.10.201:5000/SAMPLE

More information and download
jTDS web site

Notes
Installation Notes: Download the jtds-nn-dist.zip file, unzip it and then load the jtds.jar file in the DbVisualizer Tools->Driver Manager or in the Tools->Connection Wizard.

Mimer

Mimer JDBC Driver

Mimer JDBC Drivers provide access to Mimer SQL databases from Java applications and applets.

This zip file contains documentation and jar file for the Mimer JDBC Driver, which supports the JDBC 3 specification. The provided guide describes how the mimjdbc3.jar driver should be used, some programming examples and a change history.

This driver is co-packaged with DbVisualizer.

Required File(s)
mimjdbc3.jar

Default Driver Class
com.mimer.jdbc.Driver

JDBC URL Format
jdbc:mimer://<host>:<port>/<database>

More information and download
Mimer Information Technology

MySQL

MySQL Connector/J JDBC Driver

MySQL Connector/J is the official JDBC driver for MySQL.

This driver is co-packaged with DbVisualizer.

Required File(s)
mysql-connector-java-nn-bin.jar

Default Driver Class
com.mysql.jdbc.Driver

JDBC URL Format
jdbc:mysql://<host>:<port3306>/<database>

Example:
jdbc:mysql://localhost:3306/empdb
jdbc:mysql://192.168.100.98:3306/store

More information and download
MySQL

Oracle

Oracle Thin JDBC Driver

The JDBC Thin driver is a pure Java, Type IV driver that can be used in applications and applets. It is platform-independent and does not require any additional Oracle software on the client-side. The JDBC Thin driver communicates with the server using SQL*Net to access Oracle Database.

The JDBC Thin driver allows a direct connection to the database by providing an implementation of SQL*Net on top of Java sockets. The driver supports the TCP/IP protocol and requires a TNS listener on the TCP/IP sockets on the database server.

Required File(s)
ojdbc15.jar (For Java 1.5)
ojdbc16.jar (For Java 1.6)

Default Driver Class
oracle.jdbc.OracleDriver

JDBC URL Format
jdbc:oracle:thin://<host>:<port>/<service><br> jdbc:oracle:thin:<host>:<port>:<SID><br> jdbc:oracle:thin:<TNSName> (from 10.2.0.1.0)

Example:
jdbc:oracle:thin:@mimmi:1521:ORCL_SID
jdbc:oracle:thin:@192.168.1.12:1521/ORCL_SVC
jdbc:oracle:thin:@(description=(address=(host=localhost)
(protocol=tcp)(port=1521))(connect_data=(sid=ORCL)))
jdbc:oracle:thin:@ML

More information and download
Oracle JDBC

Notes
Read more in: Oracle JDBC Frequently Asked Question

To enable support for Oracles XMLTYPE in DbVisualizer Personal you need to load the xdb.jar and xmlparserv2.jar in the DbVisualizer Driver Manager. These files are available in the Oracle XML Developers Kit. Visit the Oracle web site for download.

Oracle OCI JDBC Driver

The JDBC OCI driver is a Type II driver used with Java applications. It requires an Oracle client installation and, therefore, is Oracle platform-specific. It supports all installed Oracle Net adapters, including interprocess communication (IPC), named pipes, TCP/IP, and Internetwork Packet Exchange/Sequenced Packet Exchange (IPX/SPX).

The JDBC OCI driver uses the OCI libraries, C-entry points, Oracle Net, core libraries, and other necessary files on the client computer where it is installed.

Generally we recommend the Oracle Thin driver over the OCI driver since it works on any platform that supports Java. OCI requires client libraries and these are not available on all platforms.

Required File(s)
ojdbc15.jar (For Java 1.5)
ojdbc16.jar (For Java 1.6)

Default Driver Class
oracle.jdbc.OracleDriver

JDBC URL Format
jdbc:oracle:oci://<host>:<port>/<service><br> jdbc:oracle:oci:<host>:<port>:<SID><br> jdbc:oracle:oci:<TNSName>

Example:
jdbc:oracle:oci:@mimmi:1521:ORCL_SID
jdbc:oracle:oci:@192.168.1.12:1521/ORCL_SVC
jdbc:oracle:oci:@(description=(address=(host=localhost)
(protocol=tcp)(port=1521))(connect_data=(sid=ORCL)))
jdbc:oracle:oci:ML

More information and download
Oracle JDBC
Oracle Instant Client

Notes
Read more in: Oracle JDBC Frequently Asked Question

To enable support for Oracles XMLTYPE in DbVisualizer Personal you need to load the xdb.jar and xmlparserv2.jar in the DbVisualizer Driver Manager. These files are available in the Oracle XML Developers Kit. Visit the Oracle web site for download.

Pervasive

Pervasive JDBC Driver

The Pervasive PSQL v10 JDBC driver is a Type 4, 100% Pure Java certified client driver. The driver supports the JDBCTM 2.0 standard. The driver works on all platforms that support the JVM.

Required File(s)
pvjdbc2.jar

Default Driver Class
com.pervasive.jdbc.v2.Driver

JDBC URL Format
jdbc:pervasive://<host>:<port>/<database>

Example:
jdbc:pervasive://DBSERV:1583/DEMODATA

More information and download
Pervasive

PointBase

PointBase JDBC Driver - Embedded

PointBase JDBC Driver - Embedded

Required File(s)
pbembedded.jar

Default Driver Class
com.pointbase.jdbc.jdbcUniversalDriver

JDBC URL Format
jdbc:pointbase:embedded:PBPUBLIC

More information and download
PointBase

PointBase JDBC Driver - Server

PointBase JDBC Driver - Server

Required File(s)
pbclient.jar

Default Driver Class
com.pointbase.jdbc.jdbcUniversalDriver

JDBC URL Format
jdbc:pointbase:server://<host>:<port>/<database>

More information and download
PointBase

PointBase JDBC Driver - Micro

PointBase JDBC Driver - Micro

Required File(s)
pbmicro.jar

Default Driver Class
com.pointbase.me.jdbc.jdbcDriver

JDBC URL Format
N/A

More information and download
PointBase

PostgreSQL

JDBC PostgreSQL Driver

PostgreSQL™ provides a type 4 JDBC driver. Type 4 indicates that the driver is written in Pure Java, and communicates in the database system's own network protocol. Because of this, the driver is platform independent; once compiled, the driver can be used on any system.

This driver is co-packaged with DbVisualizer.

Required File(s)
postgresql-nn.jdbc3.jar

Default Driver Class
org.postgresql.Driver

JDBC URL Format
jdbc:postgresql://<host>:<port5432>/<database>

More information and download
PostgreSQL

Sybase SQL Anywhere

jConnect for JDBC

jConnect provides high performance native access to the complete family of Sybase products including Adaptive Server Enterprise, Adaptive Server Anywhere, Adaptive Server IQ, and Replication Server.

Required File(s)
jconn3.jar

Default Driver Class
com.sybase.jdbc3.jdbc.SybDriver

JDBC URL Format
jdbc:sybase:Tds:<host>:<port>?ServiceName=<database_name>

Example:
jdbc:sybase:Tds:192.168.2.19:7100?ServiceName=USER

More information and download
Sybase

Notes
The jConnect JDBC 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. In DbVisualizer make sure you load this jconn3.jar file.

Sybase ASE

jTDS JDBC Driver

jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000 and 2005) and Sybase (10, 11, 12, 15).

This driver is co-packaged with DbVisualizer.

Required File(s)
jtds-1.2.2.jar

Default Driver Class
net.sourceforge.jtds.jdbc.Driver

JDBC URL Format
jdbc:jtds:sybase://<host>[:<port>][/<database>]

Example:
jdbc:jdtds:sybase://localhost:5000/myDB
jdbc:jdtds:sybase://192.168.10.201:5000/SAMPLE

More information and download
http://jtds.sourceforge.net/

Notes
Installation Notes: Download the jtds-nn-dist.zip file, unzip it and then load the jtds.jar file in the DbVisualizer Tools->Driver Manager or in the Tools->Connection Wizard.

jConnect for JDBC

jConnect provides high performance native access to the complete family of Sybase products including Adaptive Server Enterprise, Adaptive Server Anywhere, Adaptive Server IQ, and Replication Server.

Required File(s)
jconn3.jar

Default Driver Class
com.sybase.jdbc3.jdbc.SybDriver

JDBC URL Format
jdbc:sybase:Tds:<host>:<port2048>/<database>

Example:
jdbc:sybase:Tds:10.0.0.2:2048
jdbc:sybase:Tds:mupp:5000/dbvistest

More information and download
Sybase

Notes
The jConnect JDBC 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. In DbVisualizer make sure you load this jconn3.jar file.