Thread started: Jun 5 2008, 12:14 PM EDT
Watch
We have several .NET web services all calling a common DB access module using ODP.NET. Each web service has its own set of connections. I anticipated the connections to be pooled across all the web services since they are using the same connection string. Does anyone know why the connections wouldn't be pooled by all the web services collectively?
out of
found this valuable.
Do you find this valuable?
Show Last Reply
|
|
Last Reply:
RE: ODP.NET Connection Pooling
By:
Nov 1 2008, 7:53 PM EDT
Hi,
I've come across the same thing. Although the documentation clearly states that the connection string is used as the signature for a connection pool and that matching signatures use the same pool. Also each connection seems to map to 2 threads. just to clarify i've tested this using one website configured on 2 webserver sharing one set of files hence the connection string in the web config will be the same.
any ideas?
on 10.2g x64 on windows 2003 using ODP.net 10.2.0.2
out of
found this valuable.
Do you find this valuable?
|
