posted 18 years ago
I'm using Hibernate 2.1.8 and am having the following problem:
I am getting different results for the same HQL query even though nothing has changed in the database. For example, object A has ten instances of object B. Often, my query gives me back the ten B objects, but just as often it returns an empty list. Nothing is being changed in the database (no updates, inserts or deletes) and the problem occurs across different invocations of my application. So, for instance, at Time 1 I may run the app and get back the ten B objects (the correct result), at Times 2 and 3 I may get back an empty list (incorrect) and at Time 4 I may get back the correct result. The correct and incorrect behavior occurs seemingly at random, across different invocations of the app.
Can anyone give me a clue as to what might be going on here?
Thanks,
Matt