JDBC Connection Strings for Popular RDBMS

来源：互联网发布：有了网站怎么做seo 编辑：程序博客网时间：2024/05/01 21:14

Connecting to an RDBMS

The following code snippet illustrates how the connection parameters are used to retrieve a database connection.

1try{
2    Class.forName("com.mysql.jdbc.Driver").newInstance();//using MySQL JDBC Driver
3    String url ="jdbc:mysql://hostname:port/database"; //format of MySQL connection string
4    conn = DriverManager.getConnection(url,"username", "password"); 
5     
6} catch(Exception e){...}
7finally {
8    conn.close();
9}

JDBC Connection Strings

The following table lists the Connection Strings of some of the popular RDBMS.

DataBase TypeDriverClassNameConnection StringMySQLcom.mysql.jdbc.Driverjdbc:mysql://<hostname>:<portNumber>/<databaseName>

Default host: 127.0.0.1
Port# 3306

PostgreSqlorg.postgresql.Driverjdbc:postgresql://<hostname>:<portNumber>/<databaseName>

Default host: 127.0.0.1
Port# 5432

SQLServercom.microsoft.sqlserver.jdbc.SQLServerDriverjdbc:sqlserver://<hostname>:<portNumber>;<databaseName>

Default host: 127.0.0.1
Port# 1433

Oracleoracle.jdbc.driver.OracleDriverjdbc:oracle:thin:@<hostname>:<portNumber>:<databaseName>

Default host: 127.0.0.1
Port# 1521

DB2COM.ibm.db2os390.sqlj.jdbc.DB2SQLJDriver
(DB2 JDBC Type 4 Driver)jdbc:db2://<hostname>:<portNumber>/<databaseName>

Default host: 127.0.0.1
Port# 50000

DB2
(on As/400)com.ibm.as400.access.AS400JDBCDriverjdbc:as400://<hostname>:<portNumber>/<databaseName>;Sybasecom.sybase.jdbc.SybDriverjdbc:Sybase:Tds:<hostname>:<portNumber>/<databaseName>Sybasenet.sourceforge.jtds.jdbc.Driver
(jTDS driver)jdbc:jtds:Sybase://<hostname>:<portNumber>/<databaseName>Sybasecom.sybase.jdbc2.jdbc.SybDriver
(jdbc2 driver version)jdbc:Sybase:Tds:<hostname>:<port>?ServiceName=<databaseName>

src: http://examples.javacodegeeks.com/enterprise-java/sql-enterprise-java/jdbc-connection-strings-popular-rdbms/

0 0