I have developed an application with hibernate2 and mysql-4.1 database.
I am not using any second level caching.
Now once my web application is started and after that if any new row is inserted in the database directly the hibernate application is unable to get the new row from the database.

If i am killing the existing connections of the connection pool from the mysql database server then my hibernate application gets the new row from the database, seems that the connection is caching the objects.

I am using c3p0 connection pooling.

I am not able to get the problem or the solution for the problem.

Hello. U have to change the transaction isolation level of your mysql db.
The default in mysql is repetable read. Set it to 2 (read commited) and clear your 1st level cache/session.