I have one doubt in hibernate When i update any record in the database will it always fire select query first and then fire update query or if not in what cases will it fire select and then update.
Are you using Hibernate's optimistic locking mechanism? It needs to check the version has not changed before updated. There is no way round this, its part of the optimistic locking pattern.