Global Temporary Table (GTT) Locks When Used With Entity Object In ADF Application
(Doc ID 2434719.1)
Last updated on MARCH 10, 2022
Applies to:Oracle JDeveloper - Version 188.8.131.52.0 to 184.108.40.206.0 [Release Oracle11g to 12c]
Information in this document applies to any platform.
An ADF Application is using an Entity Object based over a Global Temporary Table set with the option "ON COMMIT PRESERVE ROWS".
When the application is running, it creates database sessions for this Global Temporary Table and those sessions are Active and working normally.
However, once the user stops the activity and the transaction is closed, the session is set to an invalid state and the table gets locked.
Other sessions trying to access the table will then fail with the error:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!