File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes DriverManager vs Datasource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "DriverManager vs Datasource" Watch "DriverManager vs Datasource" New topic

DriverManager vs Datasource

scott miles
Ranch Hand

Joined: Jun 16, 2011
Posts: 70
I have seen some applications using drivermanager though spome others are using DataSource. One high level advantage i know of using DataSource over drivermanager is that it provides connectionPooling. Is it the main advantage of using DataSource over drivermanager ?

Another question is what kind of advantage it provides even if we are getting the connection from pool instead of drivermanager? i mean dont we have to worry about connection close in connectionpooling or some other advantages are there? what happens if we dont close the connection in case of datasource . will it keep it in pool even we are not closing the connection or will it still be considered as a case of connection leak?
joy b chakravarty
Ranch Hand

Joined: May 16, 2011
Posts: 62

dataSource vs driverManager

Cheers, Joy [SCJP 1.4, SCBCD 5.0]
get high on alcohol, algorithm or both
I agree. Here's the link:
subject: DriverManager vs Datasource
It's not a secret anymore!