File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Choosing the right connection pooler" Watch "Choosing the right connection pooler" New topic
Author

Choosing the right connection pooler

Uttam Kini
Greenhorn

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: 1132

Uttam,
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:

http://www.oracle.com/technology

Good Luck,
Avi.
 
wood burning stoves
 
subject: Choosing the right connection pooler