常用JDBC连接驱动

• » Cache
• » DaffodilDB
• » DB2 UDB
• » FrontBase
• » HSQL
• » Informix
• » JDataStore
• » MaxDB
• » Mimer
• » MySQL
• » Oracle
• » Pervasive
• » Pointbase
• » PostgreSQL
• » SQL Server
• » Sybase ASA
• » Sybase ASE
  
• » ODBC enabled data sources
• » Other databases

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