OK, first off I'm a DBA not a Hibernate developer, but I do support a Hibernate enabled app that is having intermittent errors. So, first off, the environment that I'm informed is in use:

Supported browsers are Internet Explorer 6 or Firefox 4 or better
App server is RedHat Linux with Tomcat 5.
App has jsp's that reside on top of hibernate which in turn connects via JDBC to Oracle 11.1.0.7.4
Oracle is on a separate RedHat server.
Hibernate is not configured for transactions.

The app developers have built a frame in the app that allows a user to page through their assigned activities. art of that is to display to the end user the number of records that exists for them. Something like "8 total records, displaying 1-6". Following that is the list of tasks that the end user can select from.

Intermittently the page returns "No records found" but then displays a full page of records. There are no errors left in the logs on either the app server or the database. Has anyone seen behavior like this? Do you have an idea on why it is happening?