Hi!
I have the following code in a method :


The problem is that when I call and recall this method within a session, the console displays a query from hibernate, but I alway get the same results, even if my table content has changed!

Would that be a cache problem? How can I solve this trouble?

Hibernate version: 3.1.3

Name and version of the database you are using: MySQL 4

The generated SQL (show_sql=true):

How is the table data changed? Is it done in the same session, if not the session cache would get out of sync with the database.

The query you see retrieves only the ID's from the database. Then the entities are looked up in the session cache by their ID.

You can call:

To synchronize entity with the database within the session.
Alternatively you can evict() and reload the entity or clear() the session.

Other possibilities:
- Tthe second level cache being out of sync
- Transaction isolation or isolation due to different db connections

Are you actually commiting the transaction and closing the session? Changes in other transactions are not supposed to be visible in your current transaction. One of the design patterns in Hibernate is to use long running transactions that can encompass several http screens (a conversation). Maybe you are misusing this pattern here?

I hope this helps :)

Marius

I was modifing the DB in a completely different context (using PHPMyAdmin).

I am a little bit lost with the use of these "sessions". When should a session be open or closed?

I have fixed the problem opening a new session each time I need to do a query. But does comiting implies a closure of the session?
I am using Hibernate in a J2EE context (with JSF) and am getting lost!

Here is the snippet of code that you have to use. If working with Spring or other frameworks some of this may be executed in interceptors for you. For sure if YOUR code gets a session then YOUR code needs to close it. Otherwise you keep open lots of resources in the system.

// Non-managed environment idiom
Session sess = factory.openSession();
Transaction tx = null;
try {
tx = sess.beginTransaction();

// do some work
...

tx.commit();
}
catch (RuntimeException e) {
if (tx != null) tx.rollback();
throw e; // or display error message
}
finally {
sess.close();
}

The above is from here, please read :)
http://www.hibernate.org/hib_docs/v3/re ... basics-uow