Intermittent "java.sql.SQLRecoverableException: Closed Connection" for JDBC in OAF or Concurrent Processing
Last updated on AUGUST 21, 2016
Applies to:Oracle Applications Framework - Version 12.1.1 to 12.1.3 [Release 12.1]
Microsoft Windows x64 (64-bit) - Version: 2008 R2
***Checked for relevance on 04-Mar-2013***
Running Application tier for E-Business Suite R12.1 on Windows 2003 or Windows 2008.
Intermittently OA Framework pages or GSM Service Components (e.g. Workflow Notification Mailer) fail with error reporting a closed JDBC connection is attempted to be used.
Examples of stacks (taken from OA Framework page):
The version of the JDBC drivers used is 22.214.171.124.0 or 126.96.36.199.0. Verify as follows:
- Setting profile FND: Diagnostics = Yes for USER
- Select the 'About this Page' at the left bottom of the page
- Verify the version in tab 'Technology Components'
New implementation or upgrade to Release 12.1 on Windows OS
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms