JDBC Connection for Oracle
Using JDBC to get a connection to Oracle Database.
Connection string: jdbc:oracle:thin:@server:1521:sid
try{
Properties props = new Properties();
props.setProperty("user", "Scott");
props.setProperty("password", "tiger");
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection con = DriverManager.getConnection(
"jdbc:oracle:thin:@server:1521:sid", props);
return con;
}catch(ClassNotFoundException cnfe){
cnfe.printStackTrace();
}catch(InstantiationException ie){
ie.printStackTrace();
}catch(IllegalAccessException iae){
iae.printStackTrace();
}catch(SQLException sqlex){
sqlex.printStackTrace();
}