Archives: DriverManager

Java JDBC – Connect to PostgreSQL Database

August 1, 2010 | By Prasanna Sherekar | Post comment

Download PostgreSQL JDBC Driver:
http://jdbc.postgresql.org/download.html

Class.forName("org.postgresql.Driver");
Connection connection = null;
connection = DriverManager.getConnection("jdbc:postgresql://hostname:port/dbname", "username", "password");
connection.close();

Class.forName("org.postgresql.Driver");

Connection connection = null;

connection = DriverManager.getConnection("jdbc:postgresql://hostname:port/dbname", "username", "password");

connection.close();

Java JDBC – Connect to MySQL Database

July 30, 2010 | By Prasanna Sherekar | Post comment

Download MySQL JDBC Driver:
http://dev.mysql.com/downloads/connector/j/

Class.forName("com.mysql.jdbc.Driver");
Connection connection = null;
connection = DriverManager.getConnection("jdbc:mysql://hostname:port/dbname", "username", "password");
connection.close();

Class.forName("com.mysql.jdbc.Driver");

Connection connection = null;

connection = DriverManager.getConnection("jdbc:mysql://hostname:port/dbname", "username", "password");

connection.close();

Java JDBC – Connect to Oracle Database

July 10, 2010 | By Prasanna Sherekar | Post comment

Get Oracle JDBC Driver:
http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

Code Snippet:

Class.forName("oracle.jdbc.driver.OracleDriver");
Connection connection = null;
connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:empdb",
"username","password");
connection.close();

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection connection = null;

connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:empdb",

"username","password");

connection.close();