关于数据库You can't perform any operations on this connection的错误
来源:互联网 发布:mac蓝牙在哪 编辑:程序博客网 时间:2024/05/16 09:18
最近应用老是运行到一段时间就垮掉,查看日志 发现报错如下:
You can't perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs). 在网上查询是可能查询时间过长,导致数据链接被回收不可用,因此要修改数据库配置maximum-active-time参数,关于其默认值见http://proxool.sourceforge.net/properties.html,及http://proxool.sourceforge.net/api-dev/org/logicalcobwebs/proxool/configuration/PropertyConfigurator.html,下面是proxool配置文件如下:
<bean id="dataSource"
class="org.logicalcobwebs.proxool.ProxoolDataSource" destroy-method="reset">
<property name="driver">
<value>${jdbc.driver}</value>
</property>
<property name="driverUrl">
<value>${jdbc.url}</value>
</property>
<property name="user">
<value>${jdbc.username}</value>
</property>
<property name="password">
<value>${jdbc.password}</value>
</property>
<property name="houseKeepingTestSql">
<value>select sysdate from DUAL</value>
</property>
<property name="testBeforeUse">
<value>false</value>
</property>
<property name="maximumConnectionCount">
<value>60</value>
</property>
<property name="minimumConnectionCount">
<value>20</value>
</property>
<property name="delegateProperties">
<value>
user=${jdbc.username},password=${jdbc.password}
</value>
</property>
<property name="simultaneousBuildThrottle">
<value>10</value>
</property>
<property name="maximumActiveTime"><value>900000</value></property>
<!自动侦擦各个连接的状态时间间隔(单位毫秒)侦擦到空闲的连接马上回收,超时毁,默认30秒-->
<property name="houseKeepingSleepTime"><value>20000</value></property>
</bean>
- 关于数据库You can't perform any operations on this connection的错误
- Couldn't perform the operation prepareStatement: You can't perform any operations on this connection
- Couldn't perform the operation setAutoCommit: You can't perform any operations on this connection. I
- Couldn't perform the operation rollback: You can't perform any operations on this connection. It has
- You can't perform any operations on this connection. It has been automatically closed by Proxool fo
- Can't perform Create, Update or Delete operations on 'Table(@TableName)' because it is read-only.
- c3p0 You can't operate on a closed Connection解决办法
- You can't operate on a closed Connection!!!
- qreadbook的错误"I couldn't detect any sytem tray on this system."
- yii中访问出现的错误: You don't have permission to access / on this server
- 关于mysql "You can't specify target table 'test_zb_scene' for update in FROM clause"的错误
- 数据库操作的异常Cannot perform this operation because the connection pool has been close
- FileZilla 425 Can't open data connection. 的错误解决
- Can not perform this action after onSaveInstance错误
- Fragment错误:IllegalStateException: Can not perform this action after onSaveInstanceState
- Android 错误:IllegalStateException: Can not perform this action after onSaveInstanceState
- 解决fragment错误 Can not perform this action after onSaveInstanceState
- 关于Android在ononLoadFinished中调用performItemClick 出错:Can not perform this acition的解决方案
- 强力删除文件
- 在服务器端判断request来自Ajax请求(异步)还是传统请求(同步)
- 日志文件不停增长的原因以及解决的相关方法
- ListView动态加载数据分页(使用Handler+线程和AsyncTask两种方法)
- 缺省参数的值是在编译的时候 确定
- 关于数据库You can't perform any operations on this connection的错误
- java 串口通信
- SQL服务器名称的更改
- iphone EAGL 代表什么
- MRF HMM CRF简笔
- USB口是串口的一种
- android 动画总结
- JS不支持重载
- 软工总结(三)——需求分析