aspose file tools*
The moose likes JDBC and the fly likes Oracle JDBC Pool example Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle JDBC Pool example" Watch "Oracle JDBC Pool example" New topic
Author

Oracle JDBC Pool example

Steve Jiang
Ranch Hand

Joined: May 17, 2004
Posts: 107
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

David
Sonny Gill
Ranch Hand

Joined: Feb 02, 2002
Posts: 1211

David,

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: 107
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 http://download-west.oracle.com/docs/cd/B10501_01/java.920/a96654/connpoca.htm#1056354 and would wonder if there is the existing example which can be followed.
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1135

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

Good Luck,
Avi.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle JDBC Pool example