CODEWITHSUNDEEP
javaplayframework-2.0relational-databaseebeanoptimistic-concurrency
GiCo
GiCo

Reputation: 586

Overwrite value of the Database, independent of the

Context: Ebean, play-Framework, Model, Optemistic Locking

Is it possible to set an annotation to a value of a model, which tells ebean that it shouldn't throw a "optemistic locking exception" for this value, because it is independent of the previous data?

Example usage: I have a lastAction value, which is updated frequently. It doesn't matter if this value is absolut correct, because it is just used to determin the automated logout time or deletion time (registered and guest user).

Upvotes: 0

Views: 103

Answers (1)

WeMakeSoftware
WeMakeSoftware

Reputation: 9162

I believe that you can achieve this by using 2 separate tables one for optimistic-lockable attributes, another one for do-not-care attributes.

Later you can combine them in one DB view.

For example:

  create table optimistic_lockable {
    id bigint primary key
    ....
  }

  create table non_lockable {
     id primary key
     ,lockable_id foreign key refences optimistic_lockable (id)
  }  

  create view model_view as 
  select * from optimistic_lockable ol, non_lockable nl 
  where ol.id = nl.lockable_id

You map your model to model_view. And IFF the DB engine allows to insert into view, you'll probably be fine ;)

Upvotes: 1

Related Questions