I am not understand why I hitting could not execute native bulk manipulation query Since I am only updating 1 row of records. I believe could not execute native bulk manipulation query is only happen when I update a bulk of records.
It’s not related to Hibernate, but to the relational database. It could be that the row was modified by some other transaction and your UPDATE statement could not acquire the lock in a timely fashion.
More, your version of Hibernate is very old:
hibernate-core-3.3.1
You might want to upgrade to newer versions since a lot of stuff has changed since version 3.x.
Also, to understand exactly what happened, you need to add the entire stacktraace so we can see the original Exception that was converted by Hibernate to a LockAcquisitionException.