高分求一解决方案,服务器总是down机,一直报资源未释放,jdbc连接池满池
先把错误贴上:
SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in com/Workitem_Extension_SqlMap.xml. --- The error occurred while executing query.
--- Check the SELECT COUNT(*) FROM DCC_WORKITEM_EXTENSION DWE, WF_CASEINSTANCE WC WHERE DWE.CASEINSTANCEID = WC.ID AND DWE.CURRENTDEALUSERID = ? AND WC.STATUS != 'Terminate' .
--- Check the SQL Statement (preparation failed).
--- Cause: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/Workitem_Extension_SqlMap.xml.
--- The error occurred while executing query.
--- Check the SELECT COUNT(*) FROM DCC_WORKITEM_EXTENSION DWE, WF_CASEINSTANCE WC WHERE DWE.CASEINSTANCEID = WC.ID AND DWE.CURRENTDEALUSERID = ? AND WC.STATUS != 'Terminate' .
--- Check the SQL Statement (preparation failed).
--- Cause: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
一直报资源未释放,jdbc连接池满池,造成用户无法再连接上服务器,求一解决方案。
------解决方案--------------------设为0不限制试试