非活动JDBC连接超时后,长时间执行的操作被强制回滚
(Doc ID 2094475.1)
Last updated on APRIL 23, 2020
适用于:
Oracle WebLogic Server - 版本 10.3.5 到 12.1.3.0.0
本文档所含信息适用于所有平台
症状
InactiveConnectionTimeoutSeconds(非活动连接超时),定义了一个连接被WebLogic回收并释放回JDBC连接池前的非活动时长。
当有一个长时间运行的SQL(比如90秒完成)超过了JDBC数据源中设置的非活动连接时长的值(比如20秒),JDBC线程池维护线程将在非活动连接时长后,强制关闭连接,并报BEA-001153错误(即使在应用程序调用了commit前也会被关闭)
下面是一段应用程序代码片段 :
更改
原因To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
文档内容
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit oracle.com.
© Oracle | Contact and Chat | Support | Communities | Connect with us | | | | Legal Notices | Terms of Use