1.) Initially the Image table in my DB has no records.
2.) I am executing the below method. The size is correctly displayed as zero.
3.) Now I am manually inserting 3 records through Mysql Query browser.
4.) Again I am executing the below method. ** watch** the size is still zero
5.) the manual changes I made are not getting reflected.

public String execute() {
Session session = HibernateUtil.getSession();
try {
String SQL_QUERY = "from Image"; // Image is a DTO and is mapped to a table in DB
Query query = session.createQuery(SQL_QUERY);
query.setCacheable(false);
List<Image> img = query.list();
System.out.println("size: "+img.size()); // size is STILL zero after manually inserting records in to the table
} catch (Exception e) {
e.printStackTrace();
return null;
} finally {
session.disconnect();
}


return "success";
}

Hi there,

Do you have the second-level and/or query caches enabled? If so then its possible that the cached results are being returned.

Kate