各种数据库的JDBC链接

Microsoft SQL Server JDBC connection URL

jdbc
:microsoft:sqlserver
://localhost:1433;DatabaseName=northwind

com.microsoft.jdbc
.sqlserver
.SQLServerDriver

msbase.jar;mssqlserver.jar;msutil.jar

download

l

Microsoft SQL Server 2005 JDBC connection URL

jdbc
:sqlserver
://serverNameinstance:port[;user=value][;password=value][;property=value]

com.microsoft.sqlserver
.jdbc
.SQLServerDriver

sqljdbc.jar

download SQL Server 2005 driver

Microsoft SQL Server (JTurbo) JDBC connection URL

jdbc
:JTurbo://<HOST>:<PORT>/<DB>

com.ashna.jturbo.driver.Driver

Microsoft SQL Server (Sprinta) JDBC connection URL

jdbc
:inetdae7:<HOST>:<PORT>?database=<DB>

com.inet.tds.TdsDrive

download

Cloudscape JDBC connection URL

jdbc
:cloudscape:MyDataBase

COM.cloudscape.core.JDBCDriver

Cloudscape RMI JDBC connection URL

jdbc
:rmi://hostname:portnumber/jdbc
:cloudscape:MyDatabase

RmiJdbc.RJDriver

Hypersonic SQL (server) JDBC connection URL

jdbc
:hsqldb:hsql://localhost

org.hsqldb.jdbcDriver

hsqldb.jar

download (SourceForge)

Hypersonic SQL (in-process) JDBC connection URL

jdbc
:hsqldb:file:/opt/db/testdb

org.hsqldb.jdbcDriver

hsqldb.jar

Hypersonic SQL (in-memory) JDBC connection URL

jdbc
:hsqldb:mem:aname

org.hsqldb.jdbcDriver

hsqldb.jar

H2 Database (embedded)

jdbc
:h2:test

H2 Database (Client Server)

jdbc
:h2:tcp://localhost:9092/test

H2 Database (Client Server, Clustered)

jdbc
:h2:tcp://localhost:9092,backuphost.com:9092/test

H2 Database (In Memory)

jdbc
:h2:{ {.|mem:}[name] | [file:]fileName | {tcp|ssl}:[//]server[:port][,server2[:port]]/name }[;key=value...]

Informix JDBC connection URL

jdbc
:informix-sqli://hostname:portnumber/MyDatabase:INFORMIXSERVER=MyServerName

com.informix.jdbc
.IfxDriver

MySQL JDBC connection URL

jdbc
:mysql:///test

jdbc
:mysql://[host][,failoverhost...][:port]/[database][?propertyName1][=propertyValue1][&propertyName2][=propertyValue2]...

com.mysql.jdbc
.Driver

Oracle JDBC connection URL

jdbc
:oracle:thin:@localhost:1521:MyDatabase

oracle.jdbc
.driver.OracleDriver

classes12.zip

PostgresSQL JDBC connection URL

jdbc
:postgresql:template1

org.postgresql.Driver

DB2 JDBC connection URL

jdbc
:db2:test

com.ibm.db2.jdbc
.app.DB2Driver

TimesTen in-memory database JDBC connection URL

jdbc
:timesten:direct:test

com.timesten.jdbc
.TimesTenDriver

DB2/400 (native) JDBC connection URL

jdbc
:db2://systemname

com.ibm.db2.jdbc
.app.DB2Driver

DB2/400 (toolbox) JDBC connection URL

jdbc
:as400://systemname

com.ibm.as400.access.AS400JDBCDriver

Derby JDBC connection URL

jdbc
:derby:/test;create=true

org.apache.derby.jdbc
.EmbeddedDriver

Sybase JDBC connection URL

jdbc
:sybase:Tds:localhost:2048/MyDatabase

com.sybase.jdbc2.jdbc
.SybDriver

jconn2.jar

download

Mckoi SQL JDBC connection URL

jdbc
:mckoi:local://C:/mckoi1.0.3/db.conf

com.mckoi.JDBCDriver

SAP DB JDBC connection URL

jdbc
:sapdb://localhost/TST

com.sap.dbtech.jdbc
.DriverSapDB

JSQL JDBC connection URL

jdbc
:JSQLConnect://localhost/test

com.jnetdirect.jsql.JSQLDriver

JTurbo JDBC connection URL

jdbc
:JTurbo://localhost:1433/test

com.newatlanta.jturbo.driver.Driver

jTDS JDBC connection URL

jdbc
:jtds:sqlserver
://localhost/test

net.sourceforge.jtds.jdbc
.Driver

Interbase (Java driver) JDBC connection URL

jdbc
:firebirdsql:localhost/3050:/firebird/test.gdb

org.firebirdsql.jdbc
.FBDriver

Interbase (Interclient driver) JDBC connection URL

jdbc
:interbase://localhost:3060/C:/firebird/test.gdb

interbase.interclient.Driver

PointBase JDBC connection URL

jdbc
:pointbase:embedded:sample

com.pointbase.jdbc
.jdbcUniversalDriver

Ingres JDBC connection URL

ca.edbc.jdbc .EdbcDriver
jdbc :edbc://localhost:II7/database

Mimer SQL JDBC connection URL

jdbc
:mimer:multi1

com.mimer.jdbc
.Driver