在线等!Couldn't perform the operation getAutoCommit

[pyantking]

java.sql.SQLException: Couldn't perform the operation getAutoCommit: You can't perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).
at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:207)
at org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnection.java:87)
at $java.sql.Connection$$EnhancerByProxool$$5698d586.getAutoCommit()
at org.hibernate.jdbc.ConnectionManager.isAutoCommit(ConnectionManager.java:185)
at org.hibernate.jdbc.JDBCContext.afterNontransactionalQuery(JDBCContext.java:223)
at org.hibernate.impl.SessionImpl.afterOperation(SessionImpl.java:412)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1111)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.springframework.orm.hibernate3.HibernateTemplate$31.doInHibernate(HibernateTemplate.java:853)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366) at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:844) at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:840) at com.hibernate.dao.AdminuserDAO.findByProperty(AdminuserDAO.java:81)
at com.wclhc.struts.action.AdminloginAction.execute(AdminloginAction.java:117)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)at com.filter.FilterEncoding.doFilter(FilterEncoding.java:24)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilte(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:595)

项目用的是ＨＩＢＥＲＮＡＴＥ＋ＰＲＯＸＯＯＬ，请大家帮帮忙，我都不知道这问题出错在什么程序中＾

说说自己的感受:
此问题,应该出自在AdminloginAction 调用AdminuserDAO 的 findByProperty方法中!是一个简单的登陆查询用户信息的DAO,由ECLIPSE自动生成的DAO,我也看过了并没有什么发现
public List findByProperty(String propertyName, Object value) {
log.debug("finding Adminuser instance with property: " + propertyName
+ ", value: " + value);
try {
String queryString = "from Adminuser as model where model."
+ propertyName + "= ?";
return getHibernateTemplate().find(queryString, value);
} catch (RuntimeException re) {
log.error("find by property name failed", re);
throw re;
}
}
还有一点最重要,如果程序运行一次是正确的,第二次运行怎么可能出错!我试图在本机去重显这个问题,可用了不少手段怎么也试不出来!我开始绝望,因此希望大家能帮帮忙!

[pyantking]

HELP me!

[老紫竹]

You can't perform any operations on this connection. It has been automatically closed by Proxool for some reason

你的连接已经被proxool 关闭了，所以不能设置任何操作了！

我想不出太多的理由，是不是你设置的连接池初始容量太小了。调高一点，比如10/20

[pyantking]

<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
<proxool>
<alias>DPwc</alias>
<driver-url>jdbc:mysql://localhost:3306/wcdb?Unicode=true&characterEncoding=gb2312</driver-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver-properties>
<property name="user" value="root"/>
<property name="password" value=""/>
</driver-properties>
<house-keeping-sleep-time>60000</house-keeping-sleep-time>
<prototype-count>10</prototype-count>
<maximum-connection-count>250</maximum-connection-count>
<minimum-connection-count>100</minimum-connection-count>
<statistics>15s,10m,1d</statistics>
</proxool>
</something-else-entirely>

[pyantking]

java2000_net 谢谢您的关注!我真的很想吐血了

[老紫竹]

我想这样
1 你换一个连接池看看，这样可以排除连接池问题，比如c3p0 或者 dbcp 之类的
2 你换一种方式访问连接池，这样来排除你的程序代码问题，比如直接拿到数据库连接。

总之，把问题分成2部分，排查！

[mdog26]

学习中
帮你UP

[pyantking]

自己顶

[gushijava]

有知道的也告诉我一下，我现在的网站也是这个样子，很郁闷！
我邮箱：[e-mail]

[javaxingxing]

这个错误 真恶心 我也碰到了

[lipeng314]

[Quote=引用 9 楼 javaxingxing 的回复:]

这个错误 真恶心 我也碰到了
[/Quote]
我也碰到了，鬱悶。。。

[magicmeteor]

我也是遇到这样的问题，怎么弄？要经常重启才能解决问题，顶~

[pu_zhong]

在proxool.xml中增加下面一句话：

<maximum-active-time>3600000</maximum-active-time>