difference between Driver Manager and Data Source

[Inder Kumar Rathore]

how to use these two in the program.......
i read java tutorial but could not understand.....

[Jeanne Boyarsky]

A DataSource is an externally managed connection - usually used with a connection pool. A Driver Manager creats the connection directly in code for one time use.

[Lalit Mehra]

a data source is one where you get your entries from usually a database

a DataManager is an interface in java JDBC that provides you with the comfort of creating connections to that data source

regards,
Lucky

[Prashant Hurria]

You create a JDBC Connection using Driver manager by using something like the following code

String driver ="oracle.jdbc.OracleDriver";
Class.forName(driver).newInstance();
System.out.println("Initiating Connection to the Database");
conn = DriverManager.getConnection(url,"USERNAME","PASSWORD");
System.out.println("Database Connected conn="+conn);

now this operation is expesive so you might want to implement a factory which creates a conection pool.
Also you might not want to right the boiler plate code again and again so dtasource to the rescue ....
Use a Project like apache DBCP http://commons.apache.org/dbcp/
create an instance of org.apache.commons.dbcp.BasicDataSource class supply it with the Driver Name,Username ,Password ,URL
Simply get the connection by calling a getter no boiler plate code needed.

BasicDataSource dataSource = (BasicDataSource) context.getBean("dataSource");// I am using Springs here if you do not know how to use Springs 
// instantiate using new BasicDataSource() and use the setter methods to supply username password etc.
System.out.println("dataSource-->"+dataSource);
Connection conn = dataSource.getConnection();