Re: Odd app question questions

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 24 May 2011 08:42:35 +0100
Message-ID: <BANLkTiny-SBdiJgFmbHUAL_+uzwu7b0Gqg_at_mail.gmail.com>

My best guess (in the absence of instrumentation) would be that not all display of the data corresponds to a database call, but some refer directly to java objects and/or session state. The refresh likely makes the app refresh object instances and or session states.

On 23 May 2011 14:04, "Goulet, Richard" <Richard.Goulet_at_parexel.com> wrote:

If anyone has seen the following I’d appreciate what fixed the issue:

                First the environment:



                Oracle 11.1.0.7.4 on RedHat Linux x86-64

                Front end is also on RedHat Linux, x86-64 using Tomcat for a

Java application written in Hibernate.

                Problem is that an individual displays a pick list of items

to work on, goes off to work on one and then returns. Intermittently the list is blank, but if they refresh their browser the list populates. Note that the query always returns the appropriate results in sql*plus when the issue occurs.

                Further note: The app in written here for client usage and

is also having database locking problems due to locking inside the Java pool. We see in the catalina log that one session will process an update, a second will process an identical update a second or so later and then the first will get the java lock saying that someone else already has that object locked. Long story and a messy one too. As usual it’s a db issue you know.

Richard Goulet

Senior Oracle DBA/Na Team Leader

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 24 2011 - 02:42:35 CDT