67,513
社区成员
发帖
与我相关
我的任务
分享
[pool-1-thread-1] [PreparedStatementPool.java:166] ERROR - exitImplicitCacheToClose error
java.sql.SQLRecoverableException: Closed Statement
at oracle.jdbc.driver.OracleClosedStatement.exitImplicitCacheToClose(OracleClosedStatement.java:4686) ~[ojdbc6-11.2.0.1.0.jar:11.2.0.1.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.exitImplicitCacheToClose(OraclePreparedStatementWrapper.java:1621) ~[ojdbc6-11.2.0.1.0.jar:11.2.0.1.0]
at com.alibaba.druid.util.OracleUtils.exitImplicitCacheToClose(OracleUtils.java:72) ~[druid-1.0.15.jar:1.0.15]
at com.alibaba.druid.pool.PreparedStatementPool.closeRemovedStatement(PreparedStatementPool.java:164) [druid-1.0.15.jar:1.0.15]
at com.alibaba.druid.pool.PreparedStatementPool$LRUCache.removeEldestEntry(PreparedStatementPool.java:192) [druid-1.0.15.jar:1.0.15]
at java.util.LinkedHashMap.addEntry(LinkedHashMap.java:431) [na:1.7.0_79]
at java.util.HashMap.put(HashMap.java:505) [na:1.7.0_79]
at com.alibaba.druid.pool.PreparedStatementPool.put(PreparedStatementPool.java:91) [druid-1.0.15.jar:1.0.15]
at com.alibaba.druid.pool.DruidPooledConnection.closePoolableStatement(DruidPooledConnection.java:163) [druid-1.0.15.jar:1.0.15]
at com.alibaba.druid.pool.DruidPooledPreparedStatement.close(DruidPooledPreparedStatement.java:201) [druid-1.0.15.jar:1.0.15]
private void updateKJMJE(Connection con,String contract_no,BigDecimal kjmje) throws SQLException{
String sql = " update tbl_pb_casemain set DEDUCTIBLE_AMOUNT=? where pk_bill=?";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setBigDecimal(1, kjmje);
pstmt.setString(2, contract_no);
pstmt.execute();
if(pstmt!=null&&!pstmt.isClosed()){
pstmt.close();
}
}