• Post Reply Bookmark Topic Watch Topic
  • New Topic

How to Use Connection Pooling  RSS feed

 
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
Sheriff
Posts: 37395
531
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!