data source reference?

[krishna prasad gunasekaran]

is data source reference a Connection object?

[Wei Dai]

No. It stores connection information, and DataSource.getConnection() can be used to establish a connection with the data source that this DataSource object represents.

[krishna prasad gunasekaran]

so what's a data source object?

what's the difference between
DriverManager.getConnnection("jdbcdbc:dsn",�un�,�pw�);
and
DataSource.getConnection();

[krishna prasad gunasekaran]

so what's a data source object?

what's the difference between
DriverManager.getConnnection("jdbcdbc:dsn",�un�,�pw�);
and
DataSource.getConnection();

[Muhammad Saifuddin]

DriverManager is used to register and load drivers and then establish connection and the DataSource interface for establishing connections. Just the Way a DriverManager returns a Connection object.

DataSource returns a Connection object when a method getConnection() is called. While the DriverManger loads driver classes(actually the drivers register with the DriverManager when they are loaded).
[ August 31, 2006: Message edited by: Saif Uddin ]