Hi friends,
i have some problems about deleting records from database by hibernate. Here is the problem: when i delete records by hibernate everything is all right; the record is deleted from database but after deleting the record if i want to get all records, the record deleted before comes with other records( but this record isnt in the database)

I think i have caching problems but can not solve it. Is there anyone having the solution?

Have you committed the transaction that did the delete? If you flushed the session then you'll see the delete, but until you commit the transaction, only that one connection sees the delete. You have to commit it.

Afaik Hibernate doesn't have any issues regarding finding deleted items in its cache.

this is a web project and i have a filter, and i do those things in doFilter{} method...

chain.doFilter(request, response);
Session.openSession().flush();
Session.openSession().connection().commit();
Session.commitTransaction();

Why are you committing the connection? That'll work while you're using just JDBC transactions, but if you switch to distributed transactions, it'll cause problems. You should get the correct transaction object and commit that.

I have no idea what Session.commitTransaction() does, as it's not part of hibernate or JDBC.

However, this isn't going to solve your problem. You should read up on the correct way to use transactions and hibernate. Chapters 2, 3 and 19 of the refdocs might help.

Why are you committing the connection? That'll work while you're using just JDBC transactions, but if you switch to distributed transactions, it'll cause problems. You should get the correct transaction object and commit that.

I have no idea what Session.commitTransaction() does, as it's not part of hibernate or JDBC.

However, this isn't going to solve your problem. You should read up on the correct way to use transactions and hibernate. Chapters 2, 3 and 19 of the refdocs might help.