I am currently working on ASP.Net web app with Oracle 9i database,the problem i am facing is databsae connection's doesn't seem to be releasing to the pool
even after calling connection.Dispose ; the connections are not returned to the pool and
appear as if they are busy doing some processing.
I am using microsoft's ADO.Net provider for Oracle.
Connection string is as follows:
"user id=TESTUSER;data source='DBS';password=TESTPWD;Pooling=True;Connection Lifetime=50;Min Pool Size = 20;Max Pool Size=50"
I am using OracleHelper , Application Block from Microsoft for all Data Access.
The error i am getting is as follows :
"Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached."
The problem seems to dissapear when i have a very low value for Connection Lifetime
inside the connection string say 20 seconds... , which will defeat the purpose of connection pooling
The behavior i am expecting is the connections should return to the pool after
calling Dispose on them ..,so the next request coming in can grab a connection straight away from the pool..., Isn't it the way this should be working ...?