StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POOracle Connection to .Net - Connection Pool
text
Body
copied!<p>This is more specifically with SQL Server Reporting Services, however I also see this as typical .Net application issue as well.</p> <p>Here is the problem. We are using SSRS to report data from Oracle database. From day 1 our users are complaining that they get errors like ORA-2396: Exceeded maximum idle time, ORA-01012-Not logged on etc.</p> <p>We have included DBAs, app developers, network engineer, but so far we could not find any better clue to that.</p> <p>Recently while perform some research, I have observed that many people have documented one "known" issue with .Net connectivity to oracle. As they mention, if we are using connection pooling, there is a possibility that even un-useful connection might be available in the pool. On next request, this connection might get used and at that point the error will be thrown. As confirmed by our DBA, our oracle instance is set to kill the connection if it's idle for X minutes.</p> <p>Here are the links which has the aforesaid mention <a href="http://msdn.microsoft.com/en-us/library/8xx3tyca(v=VS.90).aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/8xx3tyca(v=VS.90).aspx</a></p> <p><a href="http://www.codeproject.com/KB/dotnet/ADONET_ConnectionPooling.aspx" rel="nofollow">http://www.codeproject.com/KB/dotnet/ADONET_ConnectionPooling.aspx</a> </p> <p>There are couple of more as well. However I do not get a very confirmed statement anywhere stating that yes, this is an issue with current (latest versions of .Net and oracle etc).</p> <p>On solution part, they mention that we shall be using "Validate Connection=true" attribute as part of connection string. But if I try to use that, it says "Key word not supported - validate connection". ( I have also tried Validcon)</p> <p>Questions I have are these 1. Is it confirmed that this "dirty" read from connection pool problem exists? 2. If so, what are the solutions? 3. If not, what could be causing the issues at our end.</p> <p>If you need more information, feel free to comment.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload