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 Oracle JDBC Pool example 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 "Oracle JDBC Pool example" Watch "Oracle JDBC Pool example" New topic

Oracle JDBC Pool example

Steve Jiang
Ranch Hand

Joined: May 17, 2004
Posts: 124
Could anybody tell me the procedure to create JDBC pool with Oracle? It will be much helpful if there is an example or link to show the procedure.

Thanks a lot

Sonny Gill
Ranch Hand

Joined: Feb 02, 2002
Posts: 1211


The ways for creating connection pools for most of the different databases are the same or similar.

If you are using Oracle as back end for a web application, your best bet is to use the connection pools provided by the application server you are using. All major servers including Tomcat provide some kind of database connection pooling mechanism.

Otherwise, you could use a library that provides connection pooling, there is one available under Apache Jakarta project called DBCP, and there are many others.

Good Luck
Steve Jiang
Ranch Hand

Joined: May 17, 2004
Posts: 124
Thanks for your advice.

I don't have web environment for this application. It is a standalone process to access Oracle. I found one link for Oracle and would wonder if there is the existing example which can be followed.
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1141

Have you tried the JDBC page at Oracle's OTN Web site?

Good Luck,
I agree. Here's the link:
subject: Oracle JDBC Pool example
It's not a secret anymore!