This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Choosing the right connection pooler Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Choosing the right connection pooler" Watch "Choosing the right connection pooler" New topic

Choosing the right connection pooler

Uttam Kini

Joined: Aug 07, 2008
Posts: 17
Hi.. I am writing a standalone batch application ... It is multithreaded and the expected DB transactions per second is around 2000.. It primarily is written with Oracle 10g .... but ideally should be database independent... Since I have no server runtime ... I can't use container managed connection pools.... The open source option which I saw is apache commons DBCP... I just want to explore the scalability of DBCP ... or is there a better connection pooler for Oracle (with vendor specific optimizations).... Performance has higher priority than database portabilty for me.
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1121

Latest versions of Oracle JDBC driver have built-in connection pooling.
Please refer to the JDBC Developer's Guide and Reference which is part of the Oracle documentation and avialable from:

Good Luck,
I agree. Here's the link:
subject: Choosing the right connection pooler
Similar Threads
Two network cards on linux
how to give database connection string in configuration file
Connection Pooling Doubt
Singleton class for Closing Database Connections .
Driver Loading