数据库JDBC驱动下载大全

1.数据库驱动下载地址

Cache : http://www.cachemonitor.de/intersystems-documentation/cache-jdbc-driver

DB2 : http://www-01.ibm.com/support/docview.wss?uid=swg21363866

Derby : http://db.apache.org/derby/derby_downloads.html

FireBird : http://www.firebirdsql.org/en/jdbc-driver/

FrontBase : http://www.frontbase.com/cgi-bin/WebObjects/FBWebSite

H2 : http://www.h2database.com/html/download.html

HSQLDB : http://sourceforge.net/projects/hsqldb/files/hsqldb/hsqldb_2_2/

Informix : http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc

Ingres : http://community.actian.com/w/index.php/Ingres_JDBC_Driver_Downloads

MariaDB : https://downloads.mariadb.org/client-java/

MaxDB : http://www.sapdb.org/sap_db_jdbc.htm

Mckoi : http://www.mckoi.com/originalmckoisql/index.html

MongoDB : https://github.com/mongodb/mongo-java-driver/downloads

MySQL : http://dev.mysql.com/downloads/connector/j/

Oracle(Thin SID) : http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

Pervasive : http://www.pervasivedb.com/support/Pages/PSQLSDK-Archives.aspx

PostgresSQL : http://jdbc.postgresql.org/download.html

Solid : the jar file can be found in Solid installation directory JDBC folder

SQLServer : http://www.microsoft.com/en-us/download/details.aspx?id=11774

Sybase : http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect

 

2.数据库连接字符串

Cache
user = _SYSTEM
pwd =
driver = com.intersys.jdbc.CacheDriver
jar = C:\\JDBC\\Cache\\CacheDB.jar
url = jdbc:Cache://localhost:1972/SAMPLES

DB2 (APP)
user = db2admin
pwd =
driver = COM.ibm.db2.jdbc.app.DB2Driver
jar = C:\\JDBC\\DB2\\db2java.zip
url = jdbc:db2:TESTDB

DB2 (JCC)
user = db2admin
pwd =
driver = com.ibm.db2.jcc.DB2Driver
jar = C:\\JDBC\\DB2\\db2jcc.jar;C:\\JDBC\\DB2\\db2jcc_license_cu.jar
url = jdbc:db2://localhost:50000/TESTDB

Derby
user =
pwd =
driver = org.apache.derby.jdbc.ClientDriver
jar = C:\\JDBC\\Derby\\derby.jar;C:\\JDBC\\Derby\\derbyclient.jar
url = jdbc:derby://localhost:1527/test;create=true

FireBird
user = sysdba
pwd =
driver = org.firebirdsql.jdbc.FBDriver
jar = C:\\JDBC\\Firebird\\jaybird-full-2.1.6.jar
url = jdbc:firebirdsql://localhost:3050/C:\\Program Files\\Firebird\\Firebird_2_1\\examples\\empbuild\\EMPLOYEE.FDB

FrontBase
user = testuser
pwd =
driver = com.frontbase.jdbc.FBJDriver
jar = C:\\JDBC\\FrontBase\\frontbasejdbc.jar
url = jdbc:FrontBase://localhost/firstdb

H2
user = sa
pwd =
driver = org.h2.Driver
jar = C:\\JDBC\\H2\\h2-1.2.126.jar
url = jdbc:h2:~/test

H2 (Embedded)
user = sa
pwd =
driver = org.h2.Driver
jar = C:\\JDBC\\H2\\h2-1.2.126.jar
url = jdbc:h2:file:C:\\Program Files\\H2\\bin\\test.h2.db

HSQLDB (Embedded)
user = SA
pwd =
driver = org.hsqldb.jdbcDriver
jar = C:\\JDBC\\HSQLDB\\hsqldb.jar
url = jdbc:hsqldb:file:C:\\JDBC\\HSQLDB\\test

Informix
user = dtsql
pwd =
driver = com.informix.jdbc.IfxDriver
jar = C:\\JDBC\\Infomix\\ifxjdbc.jar
url = jdbc:informix-sqli://localhost:9088/testdb:INFORMIXSERVER=ol_svr_custom

Note: if your OS locale is different from your database locale, please specify locale in the URL to avoid locale mismatch error :
url = jdbc:informix-sqli://localhost:9088/testdb:INFORMIXSERVER=ol_svr_custom;

DB_LOCALE=EN_US.UTF8;CLIENT_LOCALE=EN_US.UTF8;charSet=UTF8

Ingres
user =
pwd =
driver = com.ingres.jdbc.IngresDriver
jar = C:\\JDBC\\Ingres\\iijdbc.jar
url = jdbc:ingres://localhost:II7/demodb

JDataStore
user = sysdba
pwd =
driver = com.borland.datastore.jdbc.DataStoreDriver
jar = C:\\JDBC\\JDataStore\\jds.jar;C:\\JDBC\\JDataStore\\jdsremote.jar
url = jdbc:borland:dsremote://localhost/c:\\JDataStore\\datastores\\employee.jds

MariaDB
user = root
pwd =
driver = org.mariadb.jdbc.Driver
jar = C:\\JDBC\\mariadb\\mariadb-java-client-1.1.7.jar
url = jdbc:mysql://localhost:3306/test

MaxDB
user = DBADMIN
pwd =
driver = com.sap.dbtech.jdbc.DriverSapDB
jar = C:\\JDBC\\MaxDB\\sapdbc.jar
url = jdbc:sapdb://localhost:7210/MAXDB1

Mckoi
user = test_user
pwd = la:ldj6::
driver = com.mckoi.JDBCDriver
jar = C:\\JDBC\\Mckoi\\mkjdbc.jar
url = jdbc:mckoi:local://C:/mckoiddb_1.1.01/demo/sdb/client.conf?create=true

MongoDB
user =
pwd =
host = localhost
port = 27017

MySQL
user = root
pwd =
driver = com.mysql.jdbc.Driver
jar = C:\\JDBC\\MySQL\\mysql-connector-java-5.1.8-bin.jar
url = jdbc:mysql://localhost:3306/test

Oracle(Thin SID)
user = SYSTEM
pwd =
driver = oracle.jdbc.driver.OracleDriver
jar = C:\\JDBC\\Oracle\\ojdbc14.jar
url = jdbc:oracle:thin:@localhost:1521:XE

Pervasive
user =
pwd =
driver = com.pervasive.jdbc.v2.Driver
jar = C:\\JDBC\\Pervasive\\jpscs.jar;C:\\JDBC\\Pervasive\\pvjdbc2.jar;C:\\JDBC\\Pervasive\\pvjdbc2x.jar
url = jdbc:pervasive://localhost:1583/demodata

PointBase
user =
pwd =
driver = com.pointbase.jdbc.jdbcUniversalDriver
jar = C:\\JDBC\\PointBase\\pbclient44.jar
url = jdbc:pointbase:server://localhost/sample

PostgresSQL
user = postgres
pwd = ji:l,ka:
driver = org.postgresql.Driver
jar = C:\\JDBC\\Postgres\\postgresql-8.4-701.jdbc3.jar
url = jdbc:postgresql://localhost:5432/test

Solid
user = dba
pwd =
driver = solid.jdbc.SolidDriver
jar = C:\\JDBC\\SolidDB\\SolidDriver2.0.jar
url = jdbc:solid://localhost:1315

SQLite
user =
pwd =
driver = org.sqlite.JDBC
jar = C:\\JDBC\\SQLite\\sqlitejdbc-v056.jar
url = jdbc:sqlite:C:\\sqlite\\sqlite-shell-win32-x86-3070400\\test.db

SQLServer (Microsoft 2005)
user = sa
pwd =
driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
jar = C:\\JDBC\\SQLServer\\sqljdbc4.jar
url = jdbc:sqlserver://localhost:1433;DatabaseName=testdb

Sybase SQL Anywhere
user = DBA
pwd =
driver = com.sybase.jdbc3.jdbc.SybDriver
jar = C:\\JDBC\\Sybase\\jconn3.jar
url = jdbc:sybase:Tds:localhost:2638?DatabaseName=demo

Sybase ASE:
user = sa
pwd =
driver = com.sybase.jdbc3.jdbc.SybDriver
jar = C:\\JDBC\\Sybase\\jconn3.jar
url = jdbc:sybase:Tds:192.168.1.102:5000?DatabaseName=demo