This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Functional Reactive Programming and have Stephen Blackheath and Anthony Jones on-line!
See this thread for details.
Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle JDBC Pool example

 
Steve Jiang
Ranch Hand
Posts: 127
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1211
IntelliJ IDE Mac
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 127
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
David,
Have you tried the JDBC page at Oracle's OTN Web site?

Good Luck,
Avi.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic