应用程序配置了hikari库来管理数据库连接。最近将ojdbcjar从ojdbc7升级到ojdbc8,并将spring jdbc版本从4.3.10.release升级到5.2.9.release,然后我们看到了这个问题。
以下是hikari cp设置
MaximumPoolSize = 100 MinimumIdle=5
IdleTimeout=600000 ConnectionTimeout=30000
MaxLifetime=600000 validationTimeout=25000
这些是配置的jar
hikari cp =3.3.0 SpringBoot= 1.5.13.RELEASE
SpringVersion = 5.2.9.RELEASE SpringJdbcVersion = 5.2.9.RELEASE
ojdbc8 = 19.3.0.0 SpringJdbcVersion = 5.2.9.RELEASE
堆栈跟踪: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Connection is closed" com.zaxxer.hikari.pool.PoolBase - DataSourceHikariPool - Closing connection oracle.jdbc.driver.T4CConnection@3a9e81d8: (connection is broken)" com.zaxxer.hikari.pool.ProxyConnection - DataSourceHikariPool - Connection oracle.jdbc.driver.T4CConnection@3a9e81d8 marked as broken because of SQLSTATE(08003), ErrorCode(17008)
暂无答案!
目前还没有任何答案,快来回答吧!