Win a copy of Bad Programming Practices 101 (e-book) this week in the Beginning Java forum!

Chong Xian

Greenhorn
+ Follow
since Feb 04, 2018
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Chong Xian

The following is my method to update a row of records:

PaymentHistory is an entity and paymentHistoryId is the primary key.

Thus, I believe my method will only update just ONE record of PaymentHistory table.

This process working fine so far. But yesterday I am hitting LockAcquisitionException. The error log will be as follow:

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.

For org.hibernate.exception.LockAcquisitionException, I didnt see any request or thread that pulling this row of record or update this row of record. I believe LockAcquisitionException will only happen when the record is being update by another hibernate session, and I am still proceed to update it. But in my case, its not.

Any ideas why I getting this error?

Here is the log from DBA:

I do some study on this, but still not 100% understand on it. I am suspect the issue is cause by the network between application and database, or the database server is not stable. Any ideas?

Or any info I can get from this db log?
6 months ago