Hibernate version:
3

Query.list() returns a List containing three objects. After that I add a row to the database (not using Hibernate), and then run the query again, and it still only returns three obejcts, though it should be four.
Is this because of some kind of caching? I read something in the docs about query caching, but that thing was supposed to be turned off by default...

commit after inserting -- ?

I'm not using hibernate to do the insert.

Check if you have set the property
<property name="hibernate.cache.use_query_cache">true</property>

In that case the result of the query will be cached and you will not see the post inserted.

If you don't have that property, or it is set to false, your resultset will not be cached and your problem is somewhere else.

On second thought, for Hibernate, you need to set cacheable to true for each query, otherwise it won't be cached:
session.createQuery("from Object o").setCacheable(true).list();

If you haven't done this I would agree with the previous poster, you probably haven't commited the insert.

I'm 100% sure the rows are inserted correctly. I insert them manually using Navicat (MySql gui).

And if I restart Tomcat hibernate finds the new rows correctly.

I have nothing about query caching in my code or property file.

I'm working om a web application and all hibernate stuff lies in a separate jar file, datalayer.jar.

Hi,

If you are using session do flush the session.
i.e) session.flush()

If you have already flushed the session, refresh the session.
i.e) session.refresh()

Ideally when you flush the session the inserted record showed be in the List.

If this doesn't solve the problem do post the code segment!!!!!!!!!

The problem was not in Hibernate but in MySql. Solved it by putting
"transaction-isolation = READ-COMMITED"
in the config file.

Thanks anyway for your answers, I think they helped me tracking down the problem so I'll give you some credits. =)