PostgresSQL JDBC connection URL
jdbc:postgresql:template1
org.postgresql.Driver
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
To reference the Oracle SID (Service name), you have to apply // in front of the host name .
jdbc:oracle:thin:myusername/mypassword@//localhost:1521/PROD.OCZH.CH
To connect to your database using a tnsnames.ora entry ,
System.setProperty("oracle.net.tns_admin",
"D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN");
or
Doracle.net.tns_admin=D:oracleproduct10.2.0db_1NETWORKADMIN
jdbc:oracle:thin:@mysvcname
Firebird JDBC connection URL
jdbc:firebirdsql:localhost/3050:/firebird/test.gdb
org.firebirdsql.jdbc.FBDriver
Configuring CharSet
jdbc:firebirdsql:localhost/3050:/firebird/test.gdb?lc_ctype=ISO8859_1
Microsoft SQL Server JDBC connection URL
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=northwind
com.microsoft.jdbc.sqlserver.SQLServerDriver
msbase.jar;mssqlserver.jar;msutil.jar
Microsoft SQL Server 2005 JDBC connection URL
jdbc:sqlserver://serverNameinstance:port[;user=value][;password=value][;property=value]
com.microsoft.sqlserver.jdbc.SQLServerDriver
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
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
Hypersonic SQL (in-process) JDBC connection URL
jdbc:hsqldb:file:/opt/db/testdb
org.hsqldb.jdbcDriver
Hypersonic SQL (in-memory) JDBC connection URL
jdbc:hsqldb:mem:aname
org.hsqldb.jdbcDriver
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
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
Derby JDBC network connection URL
jdbc:derby://localhost:1527/sample;user=judy;password=no12see
jdbc:derby://localhost:1527/c:/my-db-dir/my-db-name;user=judy;password=no12see
org.apache.derby.jdbc.ClientDriver
Note that authentication is off by default. To enable user authentication, the property derby.connection.requireAuthentication must be set to true. This is set in the derby.properties file.
Sybase JDBC connection URL
jdbc:sybase:Tds:localhost:2048/MyDatabase
com.sybase.jdbc2.jdbc.SybDriver
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
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