asked on
Connection pooling across applications
Working with connection pooling, and I just wanted to get confirmation that my assumptions are correct.
Connection pooling does not work across client applications, even if they use identical connection strings, is this correct?
Connection pooling does not work across client applications, even if they use identical connection strings, is this correct?
Oracle DatabaseC#
Last Comment
Sean Stuber
ASKER
I should rephrase that question a bit.
If I have two applications that are running on the same client, but they use an identical connection strings.
In my tests I have not found a way to have the two applications use the same connection pool.
I look forward to 11g, which we are upgrading to very soon.
If I have two applications that are running on the same client, but they use an identical connection strings.
In my tests I have not found a way to have the two applications use the same connection pool.
I look forward to 11g, which we are upgrading to very soon.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
nothing in 10g or 11g will automatically pool your connections from multiple clients.
However, in 11g there is a new feature called "database resident connection pool" where your applications can use a single pool mainttained by the database and share the same sessions, even across different clients running on different machines. This functionality, if desired, is exposed through OCI and OCCI calls.
See the 11g "Oracle Call Interface Programmer's Guide" for more details