File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 1141

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
It's not a secret anymore!