• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC Connection Pooling Framework

 
Joe Harry
Ranch Hand
Posts: 10124
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Guys,

I would like to know which framework is the ideal one for doing a JDBC connection pooling. I would like to have a standalone application and need a connection pooling mechanism for my JDBC database calls.
 
Sagar Rohankar
Ranch Hand
Posts: 2907
1
Java Spring Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A standalone application which gets installed on each user PC ??
If that will be the case, then IMO, you don't need any DBCP. Still if you need one, I'll prefer Apache Commons DBCP
 
Joe Harry
Ranch Hand
Posts: 10124
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I found this to be good enough....http://www.source-code.biz/snippets/java/8.htm
 
Joe Harry
Ranch Hand
Posts: 10124
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I tried using the DBCP BasicDataSourceExample....as below:






Where did 7 come from?? I was the only one who ran this program. I created a connection pool size of 10...
 
Joe Harry
Ranch Hand
Posts: 10124
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I mean in the above example, where is the Connection object getting pooled?
 
Joe Harry
Ranch Hand
Posts: 10124
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is the difference between the above sample and the one here in this link...http://commons.apache.org/dbcp/apidocs/org/apache/commons/dbcp/datasources/package-summary.html (Without JNDI.....given at the bottom of the page)
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jothi Shankar Kumar wrote:I mean in the above example, where is the Connection object getting pooled?

If you want pooling, why are you using a BasicDataSource instead of a PoolingDataSource?
 
Joe Harry
Ranch Hand
Posts: 10124
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, what are the differences between the two?
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
After having read their respective javadocs, what do *you* think the differences are?
 
Joe Harry
Ranch Hand
Posts: 10124
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What can I infer from just there two lines of Javadoc...

Basic implementation of javax.sql.DataSource that is configured via JavaBeans properties. This is not the only way to combine the commons-dbcp and commons-pool packages, but provides a "one stop shopping" solution for basic requirements.
 
Joe Harry
Ranch Hand
Posts: 10124
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Do you mean to say, I have to try something like this?
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'd start by looking through the example code that's available on the DBCP web site. The README file that goes along with those examples specifically mentions reading the package javadocs of org.apache.commons.dbcp to get an overview of how it all works.
 
Joe Harry
Ranch Hand
Posts: 10124
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Normally, it is the Connection object that we pool? am I right? But the examples shown in the DBCP actually pools the DataSource.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic