高手来～～～～！

[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)

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

[huihui0103]

是经常抛出？还是偶尔？

[pyantking]

不是经常,就是觉得奇怪呀

[mxsoftware]

连接被自动关闭了
代理连接池没用过，是不是把自动提交设置为false了啊，设置为true看看，可能是由于你的操作不当，导致了连接池出错然后自动关闭了
建议采用C3P0连接池

[pyantking]

好像C3P0连接池,资源用得挺多的吧
看看我的设置
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
<prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
<prop key="hibernate.jdbc.use_scrollable_resultset">true</prop>
<prop key="hibernate.generate_statistics">true</prop>
<prop key="hibernate.transaction.auto_close_session">true</prop>
<prop key="hibernate.show_sql">false</prop>
<prop key="hibernate.connection.statement_cache.size">25</prop>
<prop key="hibernate.jdbc.batch_size">30</prop>
</props>
上楼说的是红色这里吗?

[pyantking]

没人回答吗?

[pyantking]

说说自己的感受:
此问题,应该出自在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;
}
}
还有一点最重要,如果程序运行一次是正确的,第二次运行怎么可能出错!我试图在本机去重显这个问题,可用了不少手段怎么也试不出来!我开始绝望,因此希望大家能帮帮忙!