Criteria crit = sess.createCriteria(TableObj.class,"table_name")
.add( Restrictions.like("id", "%"+keyword+"%") )
.addOrder(bSortOrder ? Order.asc(sortColumnId): Order.desc(sortColumnId))
.setFirstResult(nFirst)
.setMaxResults(nPageSize);

Is this statement cached by default? after first time i executed it and followed by update of a field in the table and re-execute this statement again. It's still displaying my old record. Is c3p0 pooling cache this?

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 refresh the session the inserted record should be in the List.

Which database are u using???
If you are using MySql. Check to see whether you have set this in config file.
transaction-isolation = READ-COMMITED"