This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Oracle Connection Pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle Connection Pooling" Watch "Oracle Connection Pooling" New topic

Oracle Connection Pooling

George Stoianov
Ranch Hand

Joined: Jan 15, 2006
Posts: 94
Hello guys,

I am trying to setup Oracle Connection Pooling for a webapp I am working on. I am using the following code:

I am going through R.M. Menon's book and I am a little confused between the pool and cache concepts I guess. What I mean is in the above code I am using a single pooled connection and getting logical connections from it, 10 in this case, what I am wondering is how many logical connections (Connection objects) can ride on a single PooledConnection??? I mean why have multiple physical if one can handle many logical once, what is the point of caching the physical connections? Why do we need OCI then? When am I supposed to open a new physical from the cache???

I know lots of questions but I thought I can try my luck and see what you guys have to say. I am using Java 1.5 and Oracle 10g backend with the oracle 10g jdbc driver, I need/wish to use that.


[ December 11, 2007: Message edited by: George Stoianov ]
[ December 11, 2007: Message edited by: George Stoianov ]
I agree. Here's the link:
subject: Oracle Connection Pooling
It's not a secret anymore!