Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Choosing the right connection pooler

 
Uttam Kini
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic