• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to Use Connection Pooling

 
Alec Lee
Ranch Hand
Posts: 569
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am new to JDBC. I know how to use DataSource to get connection and use prepareStatement to execute SQL against Oracle 9i. But everytime it takes a long time to establish the connection to Oracle. I heard of connection pooling can solve the long connection delay problem. But how do I get start using it? Am I required to buy/install special connection pooling facilities in order to use it?

Thx for any advice
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35269
383
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Alec,
You don't need to buy anything. If you are using an application server like Tomcat or JBoss, it comes with the server. If not, take a look at the Jakarta Commons project for a connection pool implementation.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic