JDBC Session Stays In The Database After The Java Program Was Canceled Using CTRL + C (Doc ID 1394687.1)

Last updated on MAY 15, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR

An application that is using JDBC Thin driver changes in behavior when it is migrated from 10g to 11g version.

• Before the upgrade when pressing CTRL + C the application finished closing the connection to the database and also the session in the database is closed quickly.
• After the JDBC upgraded when the CTRL + C is pressed the connection to the database is closed, but the session in the database is still open for up to 15 minutes.

EXPECTED BEHAVIOR

It is expected that using the 11g JDBC driver the CTRL + C closes the connection to the database, but also in the database the session is also closed.

STEPS

Running the testcase using the 10g driver and pressing the CTRL + C the connection and the session is closed in the database, but when using the 11g driver the session in the database keeps open.

Changes

Cause

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