CODEWITHSUNDEEP
spring-bootspring-data-jpaspring-restcontroller
dm_tr
dm_tr

Reputation: 4763

Spring REST - Concurrent requests on database from differents APIs

I have two Frontends consuming JSON from two different Backends using the JSON Web Token. These backends act on the same database.

In the db for example I have the Driver, Customer and Trip tables. The customer or the driver can cancel a trip only if it has not been canceled beforehand by one of them. Some transactions are recorded during a cancellation.

How to prevent having a double execution in this case when simultaneously, the customer and the driver launch a request for trip cancellation?

Am usin' Spring Boot (RESTful) and Spring JPA.

Any help will be greatly appreciated.

Edit: Assuming these backends are A & B, Customer is requesting cancellation from the backend A, and Driver from B.

Upvotes: 0

Views: 519

Answers (1)

mentallurg
mentallurg

Reputation: 5207

Use optimistic locking. Your code would look as follows:

@Entity
public class Trip {

    @Version
    @NotNull
    private Long version;

    ...

}

It works as follows. Each change modifies the version. Suppose two users (or two services) loaded the same version of the trip. Now they both try to cancel it, i.e. they both try to modify it. Besides changes they both send the version. The JPA checks if the version in the update statement is the same as in the database. So the first request wins and will be executed. During the execution the version will be incremented.

Now the 2nd request arrives and wants also to cancel the trip. The JPA will see that the version attribute in the update statement is older (less) than the version value in database. Thus the 2nd request will not be executed and an OptimisticLockException will be thrown.

You can catch this exception and inform the user that the data were change in the meanwhile and suggest user to reload the data. The user reloads the data and sees that the trip has already been cancelled.

Upvotes: 1

Related Questions