File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle Connection Pooling" Watch "Oracle Connection Pooling" New topic
Author

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.

Thanks,
George

[ December 11, 2007: Message edited by: George Stoianov ]
[ December 11, 2007: Message edited by: George Stoianov ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle Connection Pooling