Default isolation level in Spring Framework

database spring isolation-level
Sekhar picture Sekhar · Mar 7, 2012 · Viewed 21k times · Source

I have a method in service layer which does the update functionality to database. 

@Transactional(propagation = Propagation.REQUIRES_NEW)
public void update(final Object obj){
    // some code here
}

Now I want to know what is the isolation level for this method set by Spring framework?

I am a newbie to Spring, just wanted to make myself comfortable with transactions.

Please share some best practice and ways to set isolation level to avoid deadlocks and thus preventing same user trying to update his record from different browsers.

Answer

beny23 picture beny23 · Mar 7, 2012

According to the docs (Isolation.DEFAULT), it uses

Use the default isolation level of the underlying datastore.

As you are using the @Transactional annotation, I would set the isolation level there, e.g.:

@Transactional(propagation=Propagation.REQUIRES_NEW, isolation=Isolation.SERIALIZABLE)

Related questions

mybatis IllegalArgumentException: Mapped Statements collection does not contain value

i have many problem with spring e mybatis. This is my spring configuration: i have the same configuration and ComuneMapper.java and ComuneMapper.xml stay in the same folders. but i have however this error Somebody to help meeeee <?…

Read More
Spring Batch Framework - Auto create Batch Table

I just created a batch job using Spring Batch framework, but I don't have Database privileges to run CREATE SQL. When I try to run the batch job I hit the error while the framework tried to create TABLE_BATCH_…

Read More
Does Spring's JdbcTemplate close the connection after query timeout?

I have set query timeout (getJdbcTemplate().setQueryTimeout(5)) in method with insert statement. What will happen after query timeout, does jdbc template close my connection?

Read More