rt:试过几百条数据就没事,2千多条就出现下面的错误,帮帮忙。。
System.InvalidOperationException: 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. at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction) at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact) at System.Data.OracleClient.OracleConnection.Open() at LoadExcel.DataAccessCenter..ctor(String connectionString) in C:\Inetpub\wwwroot\LoadExcel\Class\DataAccessCenter.cs:line 51 at LoadExcel.DataAccessCenter..ctor() in C:\Inetpub\wwwroot\LoadExcel\Class\DataAccessCenter.cs:line 37 at LoadExcel.WebForm._default.btnLoadExcel_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\loadexcel\webform\default.aspx.cs:line 116
System.InvalidOperationException: 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. at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction) at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact) at System.Data.OracleClient.OracleConnection.Open() at LoadExcel.DataAccessCenter..ctor(String connectionString) in C:\Inetpub\wwwroot\LoadExcel\Class\DataAccessCenter.cs:line 51 at LoadExcel.DataAccessCenter..ctor() in C:\Inetpub\wwwroot\LoadExcel\Class\DataAccessCenter.cs:line 37 at LoadExcel.WebForm._default.btnLoadExcel_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\loadexcel\webform\default.aspx.cs:line 116
解决方案 »
- 关于case分支中使用COMMIT出现的问题
- 小白求助一个初级的问题
- 如何知道某用户下,哪些表最活跃?即最近有更新,插入,删除操作
- drop table 删除的表不在回收站里
- 请教ORACLE 9I 怎样调内存呀.急!!!!
- 一个关于oracle表插入问题,望有兴趣的进来看看,谢谢了~~
- 大侠帮帮忙啊。oracle安装问题。
- 怎样建一个最大权限的dba用户??以及怎样dba用户都有哪些权限,希大虾帮忙解答下
- 求sql语句:执行建库和建库内相应配置,是不可视的!
- 在linux地下,安装oracle时,执行 rpm -ivh compat-egcs-c++-6.2-1.1.2.16.i386.rpm时出错!
- 关于求教pl/sql的帐龄分析语句
- 数据备份存储过程应该怎么写
可能你没传完就关闭了。
修改一下connection对象的属性