Hi All,

I'm using Hibernate in a JAX-WS/Spring Web Application running inside of Weblogic.

I'm using Hibernate to pull about several thousand rows from the database using ScrollableResults and I'm seeing some oddities with Hibernate.

What seems to be happening is...I can make one request and Hibernate returns the proper resultset.

If I make the same exact request again, Hibernate takes the last row from the last request and returns the same row duplicated n times.

I disabled every single kind of cache (minus the L1 cache) that Hibernate offers. My code that loops through the ScrollableResults indeed calls the session.clear() and scrollableresults.close() methods.

This used to work for me when I was doing Application managed JPA. I've since switched to container managed JPA and container managed transactions (JTA).

Has anyone ever seen this bizarre behavior?

THANKS for your help!!

I found the issue...this had to do with some funky behavior from my JDBC driver and JDBC cache settings from Weblogic.

As soon as I turned off caching from weblogic, everything works fine!