JDeveloper ADF Application Disconnects Every 60 Minutes with Error JBO-29000
Last updated on SEPTEMBER 12, 2016
Applies to:Oracle JDeveloper - Version 10.1.2.0.0 to 10.1.3.5.0 [Release Oracle10g]
Information in this document applies to any platform.
***Checked for relevance on 09-May-2013***
***Checked for relevance on 02-April-2015***
You have a J2EE application that utilizes the ADF Business Components framework and have an application design that relies on client state being preserved within a specific database connection, such as the use of data in temporary tables which have a context that is specific to the particular database session maintained by one connection. This application design may be likely if you are migrating an application previously implemented for Oracle Forms are a following that "client-server" model quite closely.
Your application works well for up to 60 minutes but after this results in an JBO-29000 error such as:
the exact error and JBO number can be application specific.
You analyze the problem further and after using the application you can locate the connection established for a specific test user in the database V$SESSION view. After 60 minutes the identified database session is no longer visible in V$SESSION.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms