(Updated 2005-07-03)
This page lists the most current information about databases and JDBC drivers that has been tested with DbVisualizer. Information about what file(s) to load in the driver manager 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.
» Oracle | » DB2 UDB | » SQL Server | » Sybase ASE | » Informix | » MySQL |
» PostgreSQL | » MaxDB | » FrontBase | » Sybase ASA | » HSQL | » Pointbase |
» Mckoi | » Mimer | » Pervasive | » DaffodilDB | » JDataStore | » Cache |
» ODBC enabled data sources | |||||
» Other databases |
Files: | ojdbc14.jar |
Driver Class: | oracle.jdbc.OracleDriver |
URL: | jdbc:oracle:thin:@<host>:<port1521>:<sid> jdbc:oracle:oci:@<host>:<port1521>:<sid> |
Important Notes:
» Oracle JDBC FAQ |
Files: | db2jcc.jar db2jcc_license_cu.jar |
Driver Class: | com.ibm.db2.jcc.DB2Driver |
URL: | jdbc:db2://<host>:<port50000>/<database> |
How to locate the driver at the IBM web site:
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. |
Files: | mssqlserver.jar msbase.jar msutil.jar |
Driver Class: | com.microsoft.jdbc.sqlserver.SQLServerDriver |
URL: | jdbc:microsoft:sqlserver://<host>:<port1433>;DatabaseName=<database> |
Installation Notes: Download and install setup.exe (Windows) or mssqlserver.tar (Unix) | |
Files: | jtds.jar |
Driver Class: | net.sourceforge.jtds.jdbc.Driver |
URL: | jdbc:jtds:<server_type>://<server>[:<port>][/<database>] |
Installation Notes: Download the zip file, unzip it and then load the jtds-0.9.1.jar file in the driver manager |
Files: | jconn2.jar |
Driver Class: | com.sybase.jdbc2.jdbc.SybDriver |
URL: | jdbc:sybase:Tds:<host>:<port2048>/<database> |
Installation Notes: Download and unzip the jconnect55.zip file, locate the jconn2.jar file and load it into the driver manager |
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 |
Files: | mysql-connector-java-3.0.16-ga-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 locaded the jar file that should be loaded. | |
Files: | mysql-connector-java-3.1.5-gamma-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 locate the jar file that should be loaded. |
Files: | pg74.215.jdbc2ee.jar |
Driver Class: | org.postgresql.Driver |
URL: | jdbc:postgresql://<host>:<port5432>/<database> |
Installation Notes: Just load the saved file in the driver manager |
Files: | sapdbc.jar |
Driver Class: | com.sap.dbtech.jdbc.DriverSapDB |
URL: | jdbc:sapdb://<host>:<port>/<database> |
Download Notes: In the download page, locate the Client downloads section and from its listing choose the JDBC Driver Binary download. Once installed then just load the file in the driver manager. |
Files: | frontbasejdbc.jar |
Driver Class: | com.frontbase.jdbc.FBJDriver |
URL: | jdbc:FrontBase://<host>:<port>/<database> |
Links: » Driver README |
Files: | jconn2.jar |
Driver Class: | com.sybase.jdbc2.jdbc.SybDriver |
URL: | jdbc:sybase:Tds:<host>:<port2638>/<database> |
Installation Notes: Download and unzip the jconnect55.zip file, locate the jconn2.jar file and load it into the driver manager |
Files: | hsqldb.jar |
Driver Class: | org.hsqldb.jdbcDriver |
URL: | jdbc:hsqldb:<database> |
Note: The JDBC driver file is part of the database software | |
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 |
Files: | pbembedded.jar |
Driver Class: | com.pointbase.jdbc.jdbcUniversalDriver |
URL: | |
Files: | pbclient.jar |
Driver Class: | com.pointbase.jdbc.jdbcUniversalDriver |
URL: | jdbc:pointbase:server://<host>:<port>/<database> |
Files: | pbmicro.jar |
Driver Class: | com.pointbase.me.jdbc.jdbcDriver |
URL: |
Files: | mkjdbc.jar |
Driver Class: | com.mckoi.JDBCDriver |
URL: | jdbc:mckoi://<host>/ |
Note: The JDBC driver file is part of the database software |
Files: | mimjdbc.jar |
Driver Class: | com.mimer.jdbc.Driver |
URL: | jdbc:mimer://<host>:<port>/<database> |
Files: | pvjdbc2.jar |
Driver Class: | com.pervasive.jdbc.v2.Driver |
URL: | jdbc:pervasive://<host>:<port>/<database> |
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 | |
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 |
Files: | jdsserver.jar |
Driver Class: | com.borland.datastore.jdbc.DataStoreDriver |
URL: | jdbc:borland:dslocal:<file> |
Files: | jdsremote.jar |
Driver Class: | com.borland.datastore.jdbc.DataStoreDriver |
URL: | jdbc:borland:dslocal:<file> |
Files: | CacheDB.jar |
Driver Class: | com.intersys.jdbc.CacheDriver |
URL: | jdbc:Cache://<host>:<port>/<namespace> |
The JDBC-ODBC bridge is normally included in all Java VM's and require no additional download.
Please read more in the Load JDBC Driver and Get Connected document how to utilize this bridge driver.
Note: the JDBC-ODBC bridge driver is not officially supported by DbVisualizer even though many users use it. The general recommendation is to use a database specific driver in favor od the JDBC-ODBC bridge.
Users have reported successful use with DbVisualizer and the following databases: