Hi All,
Our application are using ojdbc6.jar (2,714,189 bytes) (SHA1 Checksum:de96f0060c7353532f4cb4a0b73d20545580fc91) connect to oracle DB v11.2.0.3 using jre1.8.0_92.
The issue we facing is look like java application disconnects because of timeout due to long running queries but oracle doesn't care it. The session remain opened on Oracle DB side and causing the session reach the maximum limit. In order to resolve this is by restart our application to release the open connection.
Needs your clarification whether our ojdbc6.jar is compatible with oracle 11.2.0.3 or which ojdbc is suite it? What is the recommended option to permanent resolve this?
Rgds,
ATC