JDBC Connection Pool Setup In WebLogic To Handle Database Server Restarts (Doc ID 887199.1)

Last updated on JULY 06, 2016

Applies to:

Oracle WebLogic Server - Version 8.1 to 12.1.2.0.0
Oracle Communications Order and Service Management - Version 2.5.2 to 7.3.1.0.0 [Release 2.5 to 7.3.1]
Oracle Communications ASAP - Version 5.2.2 to 7.0.0 [Release 5.2 to 7.0.0]
Information in this document applies to any platform.
Review relevance Jan 15, 2015
Review relevance July 06, 2016

Goal

Quite often, WebLogic JDBC connection pools are not setup correctly and when the assocaited DB Server is re-started, this causes Applications hosted in WebLogic to become unavailable and huge log files created with endless errors, due to invalid JDBC connections. The following is such an example:

<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)

Solution

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 hundreds of Community platforms