JDBC Connection URLs for 22 Databases

Here is a non-exhaustive list of JDBC connection URLs for various databases. Corrections welcome!

Microsoft SQL Server JDBC connection URL

jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=northwind
com.microsoft.jdbc.sqlserver.SQLServerDriver
msbase.jar;mssqlserver.jar;msutil.jar
downloadl

Microsoft SQL Server 2005 JDBC connection URL

jdbc:sqlserver://serverName\instance: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/dbName;instance=instanceName
net.sourceforge.jtds.jdbc.Driver

(thanks JoelN for the correction)

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

Sources

• Hibernate
• VisualCase
• Pete’s Guide to JDBC Driver URLs
• devX List of JDBC Drivers