Program to connect Oracle Database using DataSource interface

Question

I want to connect to Oracle database using DataSource interface not using DriverManager in java. I don't have an idea about this. Please provide me a sample program to do so.

Answer 1

When you want to use a DataSource here is the way to go:

// Setup the datasource
DataSource ds = new OracleDataSource();// There is other DataSource offered by Oracle , check the javadoc for more information
ds.setDriverType("thin");
ds.setServerName("myServer");
ds.setPortNumber(1521);
ds.setDatabaseName("myDB");
ds.setUser("SCOTT");
ds.setPassword("TIGER");

// Get a JDBC connection
Connection c = ds.getConnection();

This what is roughtly done under the cover.

However, in real life project, you won't often do this. Let's say you build a web application. Usually, you'll configure a datasource in text format and drop this configuration on your container. Later, you can retreive the datasource through JNDI (see @Radhamani Muthusamy answer).