카테고리 없음

Databases and JDBC Drivers

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

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

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:

Goto the web site by pressing the Download Driver link
In the web page select Trials and betas link
In the Search for: field enter "jdbc"
You will probably get one match:
DB2 Personal Developer's Edition: Redistributable JDBC Type 4 Driver
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.

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: Goto the web site by pressing the Download Driver link In the web page select Trials and betas link In the Search for: field enter "jdbc" You will probably get one match: DB2 Personal Developer's Edition: Redistributable JDBC Type 4 Driver 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

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

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

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.

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

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.

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

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

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

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:

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

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>

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>

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

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>

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>

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

Databases and JDBC Drivers

Databases and JDBC Drivers

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

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

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

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

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>

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

Other databases

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

Databases and JDBC Drivers

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

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

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

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>

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>