Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Oracle Connection Pooling

Posted on 2005-05-14
Medium Priority
Last Modified: 2012-08-13

I'm not sure question should be in java section, but since it's used in java development, here goes:

I would like to know the exact difference between using OracleDataSource and OraclePooledConnection versus OracleConnectionCacheManager

From what I've heard, the first implementation only uses 1 physical connection but many logical connections. The OracleConnectionCacheManager uses many physical connections.

Is this true? What would be best solution for connection pooling on an Oracle 10g database?

Question by:whiteeagl
  • 2
  • 2
LVL 13

Expert Comment

ID: 14002124
Hi rosshind,

Well, frankly I don't know what is the difference between those, but I recommend to configure the Connection pool based on ur application server connection pooling, in other words use the datasource services provided by the application server u use, this is always the optimal way

LVL 13

Expert Comment

ID: 14002132

> Hi rosshind,
sorry I mean Hi whiteeagl :)

Author Comment

ID: 14002779
We are not using a specific application server (like OAS/IAS). We are developping it ourselves in java. This is why I need to know the difference and be able to manage it.

LVL 16

Accepted Solution

Peter Kwan earned 375 total points
ID: 14005264
Here is the site that explain the Oracle Pooling and Oracle Caching, and their difference.


Although this site is for 9.2, but the concept is also applicable for 10g, except OracleConnectionCacheManager class is for 10g only.

Author Comment

ID: 14006869
Thanks for the info.

Do you know if one use is better than another on the server side of a 3-tier architecture?

We have about 20 clients connecting 24/24 to the server.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
Suggested Courses
Course of the Month15 days, 17 hours left to enroll

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question