[hibernate-issues] [JIRA] (HHH-13867) StaleObjectStateException into a SINGLE transaction for entity with version field of type java.util.Date

Глеб Егунов ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZTdhZmZkNjdi... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-13867?atlOrigin=eyJpIjoiZTdhZm... ) HHH-13867 ( https://hibernate.atlassian.net/browse/HHH-13867?atlOrigin=eyJpIjoiZTdhZm... ) StaleObjectStateException into a SINGLE transaction for entity with version field of type java.util.Date ( https://hibernate.atlassian.net/browse/HHH-13867?atlOrigin=eyJpIjoiZTdhZm... ) Change By: Глеб Егунов ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) He team \ ! We got stuck with the following issue: StaleObjectStateException arises during the update execution into the SINGLE transaction. Feel free to look at and clone the code on * minimal example from + * bitbucket + * + : [ https://bitbucket.org/gegunov/hibernate_issue/src/master/ |https://bitbucket.org/gegunov/hibernate_issue/src/master/] * README WIKI * with examples are also attached there. Steps to reproduce: *prerequisites*: * Table DDL {code :java }CREATE TABLE `payment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `status` varchar(45) DEFAULT NULL, `last_update_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `id_UNIQUE` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1{code} * Entity class with fields: 1) of type *java.util.Date* annotated by *@Version* e.g *lastUpdateDate* 2) of type java.util.String for *state* 3) of type Long (for *Id*) # Create entity having any state. # Then in the other transaction execute the following steps: ##  *find* the created entity with entityManager.find ##  *update* the field state (of type String) ## execute another one *select* from database using entityManager. It doesn't matter what it will return. It could even return *nothing*. In the provided code I deliberately use keys which not exist in DB ##  *update* the entity again with different value. # When the transaction is being committed it will fail with the following error *_org.hibernate.StaleObjectStateException_*: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) It should be said that the mentioned behavior is not reproduced with the version field of type *short*, only with *java.util.Date* ( https://hibernate.atlassian.net/browse/HHH-13867#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13867#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100120- sha1:2415f4c )