Hi,

I've built a small web-app with Hibernate 3 and Struts 2 which is running on Tomcat 6. the DB is MySQL.

I've the strange problem, that identical queries returns different results.

For example: I've a page with a JSP with a list of my entries of a table.
After a change of the table-content (add or remove some datas) the result of the query returns the current table-content and the old one.
If I make some other changes I also get these results.

So, every time I access the JSP with the list or refresh the site I see another list. Chiefly the right one, but also old result sets.

I debugged my app and it is Hibernate which give me the wrong results for a query.


Hope you have an idea.

thanks in advance

Additional info:

I disabled the 2nd-level-cache of Hibernate and the query cache of MySQL.

When I make a conditional query it take some time to get the new entries (or don't get the deleted entries).

Looks like I solved my problem.

Hibernate was configured to use a direct connection.
Now I'm using a connection pool ressource of tomcat and it works fine.