JDeveloper ADF Application Disconnects Every 60 Minutes with Error JBO-29000 (Doc ID 394352.1)

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***

Symptoms

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:

JBO-29000: Unexpected exception caught: oracle.jbo.JboException,
msg=JBO-29000: Unexpected exception caught: java.lang.NullPointerException,
msg=null
JBO-29000: Unexpected exception caught: java.lang.NullPointerException, msg=null
null

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.

Cause

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