BTM JDBC Connections Are Being Closed With the Following Message in the Logs: java.sql.SQLRecoverableException: Closed Connection (Doc ID 1462656.1)

Last updated on AUGUST 19, 2022

Applies to:

Symptoms

The Business Transaction Management (BTM) Console starts to hang and these messages appear in the BTM log files:

The above errors typically appear in the log files for the AP_SPHERE_SERVICE service.  These log files are usually found in a directory that looks like this:

<MW_HOME>\10.3.6.0\user_projects\domains\<YOUR_DOMAIN>\btmstorage\btmcentral\sphere\logdir

Another way to view the log files for the BTM Sphere service it to do the following:

1) Log into the BTM UI
2) Navigate to Administration >> System Services.
3) Highlight AP_Sphere_Service
4. Click on the menu item: Admin >> Open System Service Log for AP_Sphere_Service

You can view the errodr from here.  Also, the box in the upper right corner shows you where the actual log can be found.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.