JDBC Connection Url Samples and Patterns for JDBC Drivers

Oracle JDBC Driver

oracle.jdbc.driver.OracleDriver

jdbc:oracle:thin:@{hostname}[:port]:{database}

Example:
jdbc:oracle:thin:@hostname:1521:dbname

 

IBM DB2 JDBC Driver

com.ibm.db2.jcc.DB2Driver

jdbc:db2://{hostname}{:port}/{database}

Example:
jdbc:db2://hostname:50000/dbname:retrieveMessagesFromServerOnGetMessage=true;

COM.ibm.db2.jdbc.net.DB2Driver

jdbc:db2://{hostname}[:port]/{database}

Example: 
jdbc:db2://hostname:50000/dbname

COM.ibm.db2.jdbc.app.DB2Driver

jdbc:db2:{database}

Example:
jdbc:db2:dbname

IBM Informix JDBC Driver

com.informix.jdbc.IfxDriver

jdbc:informix-sqli://{hostname}[:port]/{database}[:Informixserver=servername]

Example:
jdbc:informix-sqli://hostname:1526/dbname:Informixserver=servername

 

MICROSOFT SQL SERVER 2005 JDBC DRIVER

com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc:sqlserver://{hostname}[:port][;DatabaseName={database}]

Example:
jdbc:sqlserver://hostname:1433;DatabaseName=master;

MICROSOFT SQL SERVER 2000 JDBC DRIVER

com.microsoft.jdbc.sqlserver.SQLServerDriver

jdbc:microsoft:sqlserver://{hostname}[:port][;DatabaseName={database}][;SelectMethod=Cur sor;]

Example:
jdbc:microsoft:sqlserver://hostname:1433;DatabaseName=master;SelectMethod=Cursor;

 

MySQL JDBC DRIVER

com.mysql.jdbc.Driver

jdbc:mysql://{host}[,failoverhost...][:port]/{dbname}[?param1=value1][&param2=value2]

Example:
jdbc:mysql://hostname:3306/dbname

 

APACHE Derby (Embedded Mode) aka JavaDB

org.apache.derby.jdbc.EmbeddedDriver

jdbc:derby:{database}

Example:
jdbc:derby:C:\databases\dbname

APACHE Derby (Network Server)

org.apache.derby.jdbc.ClientDriver

jdbc:derby://{host}[:port]/dbname{:param1=value;param2=value2;

Example:
jdbc:derby://localhost:1527/dbname:create=true;

 

Sybase JDBC Driver

com.sybase.jdbc.SybDriver

jdbc:sybase:Tds:{hostname}[:port]/{database}

Example: 
jdbc:sybase:Tds:hostname:4100/dbname

com.sybase.jdbc2.jdbc.SybDriver

jdbc:sybase:Tds:{hostname}[:port]/{database}

Example:
jdbc:sybase:Tds:hostname:4100/dbname

ODBC (JDBC-ODBC BRIDGE FROM SUN)

sun.jdbc.odbc.JdbcOdbcDriver

jdbc:odbc:{DSN}

Example:
jdbc:odbc:ODBC_DSN_NAME

 

Postgres JDBC DRIVER

org.postgresql.Driver

jdbc:postgresql://{host}[:port]/{database}

Example:
jdbc:postgresql://localhost:5432/testdb

 

IBM Lotus Domino JDBC DRIVER

lotus.jdbc.domino.DominoDriver

jdbc:domino:/{database}

Example:
jdbc:domino:/dbname


출처 :  http://www.jdbcurl.com/