Meaningless Drivel is fun!
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
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!