超时已过期 [英] TimeOut Expired

问题描述

我已经使用C#在.net中创建了dll
system.data.oracleclient(Oracle后端)

此dll包含许多连接字符串.

后端是oracle，通过它我可以远程获取数据

过了一段时间，我得到了例外情况，说
超时到期.在从池中获取连接之前已经过了超时时间.这可能是因为所有池化连接都在使用中，并且已达到最大池大小."

我检查了连接是否泄漏，使用了finally块关闭并处置了连接，但问题仍然存在.

我在连接字符串中添加了所有必要的属性.

请帮助，因为我找不到根本原因.!!!!

I have created dll in .net using C#
system.data.oracleclient (backend Oracle)

this dll contains connection a number of connection strings .

the back end is oracle through which i fetch the data remotely

After some time i get exceptions saying
"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."

I have checked for leaked connections , used the finally block to close and dispose a connecion but the issue is still persisting.

I have added al the necessary attributes in the connection string .

Please Help , as i am not able to find the root cause.!!!!

推荐答案

您是否正在使用ODP.Net?如果是，那么请确保分别放置每个对象，甚至是参数.

检查您是否要关闭然后处置连接.同一计算机上运行的某些其他应用程序也可能没有关闭连接.如果有帮助，请尝试增加超时时间.

Are you using ODP.Net? If yes, then make sure you dispose every single object, even the parameters separately.

Check if you are closing and then disposing connection. It is also possible that some other application running on the same computer has not closed the connections. Try increasing time out if it helps.

这篇关于超时已过期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！