Does Appian support @Version JPA Annotation?

Does Appian support @Version JPA Annotation . If yes, which locking strategies it follows Optimistic or Pessimistic.
I am trying to lock my table but it’s not working.
Attached XSD
...

Ver.xsd

OriginalPostID-115265

OriginalPostID-115265

  Discussion posts and replies are publicly visible

Parents
  • 1. Import the attached application
    2. The import will fail to publish the data store called "Version Annotation Example". Simply publish it manually so Appian can create the tables
    3. Start a new instance of the model "Version Annotation Example" and select "Insert" in the first form; complete the process. This will insert values in a table called "an_46111"
    4. Start a new instance of the model "Version Annotation Example" and select "Updates" in the first form and click Submit. Leave the second form active
    5. Start ANOTHER instance of the model "Version Annotation Example" and select "Updates" in the first form and click Submit. Edit one cell in the grid and submit. This will update the data in the DB
    6. At this point the data displayed in the lingering from from step #4 has dirty data because it is now the one from before step 5 updated the information. Try to submit that pending task from your tasks list and you will get the following alert: "org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction " showing how the @Version annotation is working as expected.
Reply
  • 1. Import the attached application
    2. The import will fail to publish the data store called "Version Annotation Example". Simply publish it manually so Appian can create the tables
    3. Start a new instance of the model "Version Annotation Example" and select "Insert" in the first form; complete the process. This will insert values in a table called "an_46111"
    4. Start a new instance of the model "Version Annotation Example" and select "Updates" in the first form and click Submit. Leave the second form active
    5. Start ANOTHER instance of the model "Version Annotation Example" and select "Updates" in the first form and click Submit. Edit one cell in the grid and submit. This will update the data in the DB
    6. At this point the data displayed in the lingering from from step #4 has dirty data because it is now the one from before step 5 updated the information. Try to submit that pending task from your tasks list and you will get the following alert: "org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction " showing how the @Version annotation is working as expected.
Children
No Data