数据库是oracle,使用了poolPreparedStatements,maxPoolPreparedStatementPerConnectionSize=5, 在使用一段时间以后,使用的缓存的statement不可用,报 SQL state [99999]; error code [17009]; Closed Statement; nested exception is java.sql.SQLException: Closed Statement 的出错信息,似乎druid没有检查出关闭的statement,写库持续失败,直到重启应用
druid配置如下: dbsrc.initialSize=3 dbsrc.minIdle=3 dbsrc.maxActive=8 dbsrc.maxWait=2000 dbsrc.timeBetweenEvictionRunsMillis=60000 dbsrc.minEvictableIdleTimeMillis=120000 dbsrc.validationQuery=SELECT 1 from dual dbsrc.testWhileIdle=true dbsrc.testOnBorrow=false dbsrc.testOnReturn=false dbsrc.poolPreparedStatements=true dbsrc.maxPoolPreparedStatementPerConnectionSize=5
Metadata
Metadata
Assignees
Labels
Type
Projects
Milestone
Relationships
Development
Issue actions