What is workaround for Select for update query in Hibernate?

Issue

• Following is the issue description which can cause the problem

  • There is special kind of entity exists which has ID (primary key) field which is dependent on other fields of the table.

  • The ID field has some internal dependency on the other fields, which are being used to generate the next value for ID field.

  • For such id field, next value cannot be generated through sequence or through some auto-increment logic.

  • Simple SELECT FOR UPDATE query with JDBC APIs can be used to implement this logic but it may not work with clustered environment due to Database lock if multiple threads are trying to access same code.