This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes what is the different between Basic DataSource and pooled DataSource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "what is the different between Basic DataSource and pooled DataSource" Watch "what is the different between Basic DataSource and pooled DataSource" New topic
Author

what is the different between Basic DataSource and pooled DataSource

Samanthi perera
Ranch Hand

Joined: Jan 08, 2010
Posts: 510
1) what is the different between Basic DataSource and pooled DataSource ?
2) I need to know what is the different between PooledConnection object and physical connection ?
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30138
    
150

A pooled data source is a data source that keeps multiple connections in the pool. A basic datasource does not.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Samanthi perera
Ranch Hand

Joined: Jan 08, 2010
Posts: 510
what is the most expensive keeping pooled connection or making new connection ?
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8

Samanthi perera wrote:what is the most expensive keeping pooled connection or making new connection ?

Expensive in what sense?


OCUP UML fundamental and ITIL foundation
youtube channel
Samanthi perera
Ranch Hand

Joined: Jan 08, 2010
Posts: 510
i heard that making a new connection each time is expensive/
is it true?
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8

It takes some time to make that connection, yes.
But I would like to understand what you mean with expensive.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30138
    
150

Samanthi perera wrote:i heard that making a new connection each time is expensive/
is it true?

Yes. Compared to not doing so.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: what is the different between Basic DataSource and pooled DataSource
 
Similar Threads
jdbc
Diff between Hinernate Template and HibernateDAOSupport ?
DataSource and ConnectionPool
Connection Pooling
xa connection & pooled connection