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
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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31079
    
163

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: 2516
    
  10

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: 2516
    
  10

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

Joined: May 26, 2003
Posts: 31079
    
163

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

Yes. Compared to not doing so.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: what is the different between Basic DataSource and pooled DataSource