Skip to Main Content
Forums

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connection Pool Errors replicating to set of users

Morgan FreemanJul 5 2016 — edited Jul 5 2016

Hi All,

Jdeveloper : 11.1.1.7

Weblogic : 10.3.6SnipImage.JPG

We are sharing a database for two ADF applications(App1 and App2) and Forms and Reports(FR1). If there are any huge searches/reports running on the App2 or FR1 the database becomes very slow and is affecting the App1.

We are occasionally killing the DB sessions used by App1 which are running very slow because of the activity in either App2 or FR1. When we do so, the attached error message pops up on some set of users and they need to log out and log back in to do any thing on App1.

Now I am trying to understand why the framework does it.

Is it because these set of users share the instance in DB connection pool?

What happens when the DB session is killed and why is the error replicating to other users with different DB session id's?

Any pointers/suggestions would be of great help.

Thanks

Morgan.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 2 2016
Added on Jul 5 2016
#application-development-in-java, #jdeveloper-and-adf
3 comments
615 views