wood burning stoves 2.0*
The moose likes JDBC and the fly likes Connection and Object Pools in Java Application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection and Object Pools in Java Application" Watch "Connection and Object Pools in Java Application" New topic
Author

Connection and Object Pools in Java Application

James Winfrey
Ranch Hand

Joined: Jan 04, 2009
Posts: 60
Hi Guys

We have a core Java Application that uses JDBC to connect to Oracle database.

We have to pool objects and connections in that.

Shall we use JDBC Connection pooling or implement our own pool? I mean from performance

perspective?

How can we implement object pooling in java?

Any help is appreciable.

TIA


Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19680
    
  19

Moving to JDBC


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
Martijn Verburg
author
Bartender

Joined: Jun 24, 2003
Posts: 3274
    
    5

I'd recommend allowing the application/web server manage the DB connection pool for you. If you really need to manage your own object pool then you can look at Apache's commons pool lib.


Cheers, Martijn - Blog,
Twitter, PCGen, Ikasan, My The Well-Grounded Java Developer book!,
My start-up.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Connection and Object Pools in Java Application