René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Java: creating a datasource for Oracle

Thick ??? driver

  OracleDataSource data_source = new OracleDataSource();

  data_source.setURL("jdbc:oracle:oci:@XE");
  data_source.setUser("rene");
  data_source.setPassword("my_secret");

  OracleDataSource data_source = new OracleDataSource();

  data_source.setURL("jdbc:oracle:oci:rene/my_secret@XE");

Thin driver

  OracleDataSource data_source = new OracleDataSource();

  data_source.setURL(jdbc:oracle:thin:@//localhost:1521/XE);
  data_source.setUser("rene");
  data_source.setPassword("my_secret");

  OracleDataSource data_source = new OracleDataSource();

  data_source.setURL("jdbc:oracle:thin:rene/my_secret@localhost:1521:XE");

Connection

After the datasource is created, a connection can be optained: 
  Connection connection = data_source.getConnection();
Alternatively, the connection can also be optained 
Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "rene", "my_secret");