상세 컨텐츠

본문 제목

Databases and JDBC Drivers

카테고리 없음

by 이현민 (지후지율아빠) 2008. 2. 19. 12:25

본문

반응형

발췌 : http://blog.naver.com/multibox?Redirect=Log&logNo=60040285407

Databases and JDBC Drivers

(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

Oracle - Oracle 10.1.0.2.0
Oracle JDBC Driver 10.1.0.2.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:
  • It is generally recommended that you use the latest version of the driver based on that it is supported by the version of Java you are using
  • It is the same driver file used for both thin and OCI connections
Links:
»
Oracle JDBC FAQ

DB2 UDB - DB2 8.2
IBM DB2 JDBC Universal Driver 2.3.63 (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:
  1. Goto the web site by pressing the Download Driver link
  2. In the web page select Trials and betas link
  3. In the Search for: field enter "jdbc"
  4. You will probably get one match:
    DB2 Personal Developer's Edition: Redistributable JDBC Type 4 Driver
  5. Press the link and then follow the instructions
Installation Notes:
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 8.00.760
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:
Download and install setup.exe (Windows) or mssqlserver.tar (Unix)
jTDS 0.9.1 (Download Driver)
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

Sybase ASE - Sybase ASE 12.5
JConnect 5.5 (Download Driver)
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

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.0.22, MySQL 5.0.2
mysql-connector-java-3.0.16-ga (Download Driver)
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.
mysql-connector-java-3.1.5-gamma (Download Driver)
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.

PostgreSQL - PostgeSQL 7.4.6
PostgreSQL 7.4.4 JDBC2 with SSL (build 215) (Download Driver)
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

MaxDB - MaxDB 7.4.3
SAP DB JDBC Driver 7.4.4 (Download Driver)
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.

FrontBase - FrontBase 3.6.21
FBJDriver 2.4.7 (Download Driver)
Files: frontbasejdbc.jar
Driver Class: com.frontbase.jdbc.FBJDriver
URL: jdbc:FrontBase://<host>:<port>/<database>
Links:
»
Driver README

Sybase ASA - Sybase ASA 8.2.0.3608
JConnect 5.5 (Download Driver)
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

HSQL - HSQL 1.7.2 Embedded, HSQL 1.7.2 Server
HSQL Database Engine Driver 1.7.2 (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 Database Engine Driver 1.7.2 (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 - 4.6GA Embedded, 4.6GA Server, 4.6GA Micro
Pointbase JDBC Driver 4.6GA (Download Driver)
Files: pbembedded.jar
Driver Class: com.pointbase.jdbc.jdbcUniversalDriver
URL:  
Pointbase JDBC Driver 4.6GA (Download Driver)
Files: pbclient.jar
Driver Class: com.pointbase.jdbc.jdbcUniversalDriver
URL: jdbc:pointbase:server://<host>:<port>/<database>
Pointbase JDBC Driver 4.6GA (Download Driver)
Files: pbmicro.jar
Driver Class: com.pointbase.me.jdbc.jdbcDriver
URL:  

Mckoi - Mckoi 1.0.2 Server
Mckoi JDBC Driver 1.0 (Download Driver)
Files: mkjdbc.jar
Driver Class: com.mckoi.JDBCDriver
URL: jdbc:mckoi://<host>/
Note:
The JDBC driver file is part of the database software

Mimer - Mimer 9.1.3 Server
Mimer 2.10 (Download Driver)
Files: mimjdbc.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, DaffodilDB 2.2 Server
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
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, JDataStore 6.7.25 Server
DataStore Driver 6.0 (Download Driver)
Files: jdsserver.jar
Driver Class: com.borland.datastore.jdbc.DataStoreDriver
URL: jdbc:borland:dslocal:<file>
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>

JDBC-ODBC Bridge

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.

Other databases

Users have reported successful use with DbVisualizer and the following databases:

  • Adabas 10
  • Ingres
  • AS/400
  • Microsoft SQL 7 (via the JDBC-ODBC bridge)
  • Firebird
  • HP3000 TurboImage DB using the JDBC Driver of Minisoft
  • FirstSQL/J
  • Teradata
반응형