File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle Connection Pooling

 
George Stoianov
Ranch Hand
Posts: 94
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic