Is it possible to update the table using "where-in clause" .For example

"UPDATE TABLENAME SET COLUMN1 = SOME_VALUE WHERE
COLUMN2 IN (1,4,5,7)

Hibernate doesn't do anything like that. It's an ORM implementation: it saves objects to the DB. It doesn't update specific columns of specific rows. You can query using Restrictions.in() or similar, modify the in-memory objects, and save them, but if you have an efficient query then use it. Call session.connection() and use JDBC/SQL to do it.