RE:Conectar ORACLE & JAVA
// Load the Oracle JDBC driver
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
// Connect to the database
Connection conn =
DriverManager.getConnection("jdbc:oracle:thin:usuario/password@hostname:puerto:SID");
// Create a Statement
Statement stmt = conn.createStatement ();
// Select the PROGRAM field from the V$SESSION table
ResultSet rset = stmt.executeQuery ("select program from v$session");
// Iterate through the result
while (rset.next ())
System.out.println (rset.getString (1));
Los driver de oracle te los puesdes descargar de aqui:
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html