Connecting to an RDBMS

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

			
							1
						
							try{
						
							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){...}
						
							7
						
							finally {
						
							8
						
							    conn.close();
						
							9
						
							}

JDBC Connection Strings

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

DataBase Type	DriverClassName	Connection String
MySQL	com.mysql.jdbc.Driver	jdbc:mysql://<hostname>:<portNumber>/<databaseName> Default host: 127.0.0.1 Port# 3306
PostgreSql	org.postgresql.Driver	jdbc:postgresql://<hostname>:<portNumber>/<databaseName> Default host: 127.0.0.1 Port# 5432
SQLServer	com.microsoft.sqlserver.jdbc.SQLServerDriver	jdbc:sqlserver://<hostname>:<portNumber>;<databaseName> Default host: 127.0.0.1 Port# 1433
Oracle	oracle.jdbc.driver.OracleDriver	jdbc:oracle:thin:@<hostname>:<portNumber>:<databaseName> Default host: 127.0.0.1 Port# 1521
DB2	COM.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.AS400JDBCDriver	jdbc:as400://<hostname>:<portNumber>/<databaseName>;
Sybase	com.sybase.jdbc.SybDriver	jdbc:Sybase:Tds:<hostname>:<portNumber>/<databaseName>
Sybase	net.sourceforge.jtds.jdbc.Driver (jTDS driver)	jdbc:jtds:Sybase://<hostname>:<portNumber>/<databaseName>
Sybase	com.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/

ITPub博客

JDBC Connection Strings for Popular RDBMS

Connecting to an RDBMS

JDBC Connection Strings

最新文章