Oracle
Oracle 10.2.0.1.0 | Oracle JDBC Driver 10.2.0.1.0 (Download Driver) | |
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 |
DB2 UDB
DB2 8.2 | IBM DB2 JDBC Universal Driver 2.8.46 (Download Driver) | |
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. |
SQL Server
SQL Server 2000 8.00.2039 SQL Server 2005 09.00.1399 | Only for SQL Server 2000: SQL Server Driver 2.2.0040 (Download Driver) | |
Files: | mssqlserver.jar msbase.jar msutil.jar | |
Driver Class: | com.microsoft.jdbc.sqlserver.SQLServerDriver | |
URL: | jdbc:microsoft:sqlserver://<host>:<port1433>;DatabaseName=<database> | |
Installation Notes: See installation notes in driver download page | ||
SQL Server Driver 1.0.809.102 (Download Driver) | ||
Files: | sqljdbc.jar | |
Driver Class: | com.microsoft.sqlserver.jdbc.SQLServerDriver | |
URL: | jdbc:sqlserver://<host>[:<port1433>];databaseName=<database> | |
Installation Notes: See installation notes in driver download page | ||
jTDS 1.2 (Download Driver) | ||
Files: | jtds-1.2.jar | |
Driver Class: | net.sourceforge.jtds.jdbc.Driver | |
URL: | jdbc:jtds:<server_type>://<host>[:<port>][/<database>] | |
Installation Notes: Download the jtds-1.2-dist.zip file, unpack it and load the jtds-1.2.jar in the driver manager or in the connection wizard. |
Sybase ASE
Sybase ASE 12.5.3 Sybase ASE 15 | jConnect 6.05 EBF13044 (Download Driver) | |
Files: | jconn3.jar | |
Driver Class: | com.sybase.jdbc3.jdbc.SybDriver | |
URL: | jdbc:sybase:Tds:<host>:<port2048>/<database> | |
Installation Notes: Download and unzip the jConnect-6_05.zip file, load the classes/jconn3.jar file in the driver manager | ||
jTDS 1.2 (Download Driver) | ||
Files: | jtds-1.2.jar | |
Driver Class: | net.sourceforge.jtds.jdbc.Driver | |
URL: | jdbc:jtds:<server_type>://<host>[:<port>][/<database>] | |
Installation Notes: Download the jtds-1.2-dist.zip file, unpack it and load the jtds-1.2.jar in the driver manager or in the connection wizard. |
Informix
Informix 9.40 | Informix 2.21.JC6 (Download Driver) | |
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 |
MySQL
MySQL 4.1.19 MySQL 5.0.21 | mysql-connector-java-3.1.12 (Download Driver) | |
Files: | mysql-connector-java-3.1.12-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 located the jar file that should be loaded. |
PostgreSQL
PostgeSQL 7.4.12 | PostgreSQL 7.4.5 JDBC3 with SSL (build 216) (Download Driver) | |
Files: | pg74.216.jdbc3.jar | |
Driver Class: | org.postgresql.Driver | |
URL: | jdbc:postgresql://<host>:<port5432>/<database> | |
Installation Notes: Just load the saved file in the driver manager |
MaxDB
MaxDB 7.6 | SAP DB JDBC Driver 7.6.0 (Download Driver) | |
Files: | sapdbc.jar | |
Driver Class: | com.sap.dbtech.jdbc.DriverSapDB | |
URL: | jdbc:sapdb://<host>:<port>/<database> | |
Download Notes: Download the jar file and load it in the driver manager. |
FrontBase
FrontBase 4.2.4 | FBJDriver 2.5.2 (Download Driver) | |
Files: | frontbasejdbc.jar | |
Driver Class: | com.frontbase.jdbc.FBJDriver | |
URL: | jdbc:FrontBase://<host>:<port>/<database> | |
Links: » Driver README |
Sybase ASA
Sybase ASA 9.0.2.2452 | jConnect 6.05 EBF13044 (Download Driver) | |
Files: | jconn3.jar | |
Driver Class: | com.sybase.jdbc3.jdbc.SybDriver | |
URL: | jdbc:sybase:Tds:<host>:<port2638>/<database> | |
Installation Notes: Download and unzip the jconnect60.zip file, load the classes/jconn3.jar file in the driver manager |
HSQL
HSQL 1.8.0 Embedded | HSQL Database Engine Driver 1.8.0 (Download Driver) | |
Files: | hsqldb.jar | |
Driver Class: | org.hsqldb.jdbcDriver | |
URL: | jdbc:hsqldb:<database> | |
Note: The JDBC driver file is part of the database software | ||
HSQL 1.8.0 Server | HSQL Database Engine Driver 1.8.0 (Download Driver) | |
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 |
Pointbase
Pointbase 5.4 Embedded | Pointbase JDBC Driver 5.4 (Download Driver) | |
Files: | pbembedded.jar | |
Driver Class: | com.pointbase.jdbc.jdbcUniversalDriver | |
URL: | ||
Pointbase 5.4 Server | Pointbase JDBC Driver 5.4 (Download Driver) | |
Files: | pbclient.jar | |
Driver Class: | com.pointbase.jdbc.jdbcUniversalDriver | |
URL: | jdbc:pointbase:server://<host>:<port>/<database> | |
Pointbase 5.4 Micro | Pointbase JDBC Driver 5.4 (Download Driver) | |
Files: | pbmicro.jar | |
Driver Class: | com.pointbase.me.jdbc.jdbcDriver | |
URL: |
Mimer
Mimer 9.2.4 Server | Mimer 3.16 (Download Driver) | |
Files: | mimjdbc3.jar | |
Driver Class: | com.mimer.jdbc.Driver | |
URL: | jdbc:mimer://<host>:<port>/<database> |
Pervasive
Pervasive 8.10 Server | Pervasive JDBC Driver 2.2 (Download Driver) | |
Files: | pvjdbc2.jar | |
Driver Class: | com.pervasive.jdbc.v2.Driver | |
URL: | jdbc:pervasive://<host>:<port>/<database> |
DaffodilDB
DaffodilDB 2.2 Embedded | DaffodilDBDriver 2.2 (Download Driver) | |
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 | ||
DaffodilDB 2.2 Server | DaffodilDBDriver 2.2 (Download Driver) | |
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 |
JDataStore
JDataStore 6.7.25 Embedded | DataStore Driver 6.0 (Download Driver) | |
Files: | jdsserver.jar | |
Driver Class: | com.borland.datastore.jdbc.DataStoreDriver | |
URL: | jdbc:borland:dslocal:<file> | |
JDataStore 6.7.25 Server | DataStore Driver 6.0 (Download Driver) | |
Files: | jdsremote.jar | |
Driver Class: | com.borland.datastore.jdbc.DataStoreDriver | |
URL: | jdbc:borland:dslocal:<file> |
Cache
Cache 5.0 Server | InterSystems Cache JDBC 5.0 (Download Driver) | |
Files: | CacheDB.jar | |
Driver Class: | com.intersys.jdbc.CacheDriver | |
URL: | jdbc:Cache://<host>:<port>/<namespace> |