Weblogic の JDBC接続プールで DB再起動をハンドリングする設定について
(Doc ID 1676836.1)
Last updated on AUGUST 17, 2020
適用範囲:
Oracle WebLogic Server - バージョン 8.1 から 10.3.3この文書の内容はすべてのプラットフォームに適用されます。
目的
DBが再起動する場合にとって、通常WebLogic JDBC 接続プールは適切に設定されていません。
WeblogicにデプロイされたアプリケーションはJDBC接続が無効になったため使用できなくなり、エラーをログに出力します。
例えば以下のような出力がされます。
<SQL Exception 17,008 : Closed Connection
java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:731)
at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:707)
at weblogic.jdbc.wrapper.Connection.createStatement(Connection.java:456)
at com.mslv.oms.dataaccesslayer.QueryProxy.createStatement(Unknown Source)
at com.mslv.oms.dataaccesslayer.a.execute(Unknown Source)
at com.mslv.oms.eventengine.EventDispatcherEJB.processTimeout(Unknown Source)
at com.mslv.oms.eventengine.EventDispatcher_86q3j1_EOImpl.processTimeout(EventDispatcher_86q3j1_EOImpl.java:503
at com.mslv.oms.poller.a.handleNotification(Unknown Source)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor$ListenerWrapper.handleNotification(DefaultMBeanServerI
terceptor.java:1652)
at javax.management.NotificationBroadcasterSupport.handleNotification(NotificationBroadcasterSupport.java:221)
at javax.management.NotificationBroadcasterSupport.sendNotification(NotificationBroadcasterSupport.java:184)
at javax.management.timer.Timer.sendNotification(Timer.java:1295)
at javax.management.timer.Timer.notifyAlarmClock(Timer.java:1264)
at javax.management.timer.TimerAlarmClock.run(Timer.java:1347)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:731)
at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:707)
at weblogic.jdbc.wrapper.Connection.createStatement(Connection.java:456)
at com.mslv.oms.dataaccesslayer.QueryProxy.createStatement(Unknown Source)
at com.mslv.oms.dataaccesslayer.a.execute(Unknown Source)
at com.mslv.oms.eventengine.EventDispatcherEJB.processTimeout(Unknown Source)
at com.mslv.oms.eventengine.EventDispatcher_86q3j1_EOImpl.processTimeout(EventDispatcher_86q3j1_EOImpl.java:503
at com.mslv.oms.poller.a.handleNotification(Unknown Source)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor$ListenerWrapper.handleNotification(DefaultMBeanServerI
terceptor.java:1652)
at javax.management.NotificationBroadcasterSupport.handleNotification(NotificationBroadcasterSupport.java:221)
at javax.management.NotificationBroadcasterSupport.sendNotification(NotificationBroadcasterSupport.java:184)
at javax.management.timer.Timer.sendNotification(Timer.java:1295)
at javax.management.timer.Timer.notifyAlarmClock(Timer.java:1264)
at javax.management.timer.TimerAlarmClock.run(Timer.java:1347)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
解決策
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
本書の内容
| 目的 |
| 解決策 |
| 参照情報 |