aspose file tools*
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 Java 8 in Action this week in the Java 8 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: 29274
    
140

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: 2477
    
    7

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: 2477
    
    7

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: 29274
    
140

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
DataSource and ConnectionPool
jdbc
xa connection & pooled connection
Connection Pooling
Diff between Hinernate Template and HibernateDAOSupport ?