How to set isolation level to uncommitted read

[r.walde (r.walde@podconsult.de Walde)]

Hi,
when a user opens a screen for a table and keeps the session open in the browser,
the underlying table is locked for backend processes.
Using the uncommitted read isolation level will solve this issue.

I went through the docs, but could not find the information,
how to set the isolation level in a standard browse screen.

Is there a way to do that on a central place?
Or how to handle that in JMIX apps?

Regards Roland

[chapinsky (Serg Pinsky)]

@r.walde

when a user opens a screen for a table and keeps the session open in the browser,
the underlying table is locked for backend processes.

Why You think so ? Jmix not single user/session framework. So what dont work ?

@r.walde

Using the uncommitted read isolation level will solve this issue.

… and produce some others.

Maybe extendin of the JpaTransactionManager do the trick.

Or try to load data for screen component manually in onBeforeShow thou service method marked with @Transactional(isolation=Isolation.READ_UNCOMMITED)

[krivopustov (Konstantin Krivopustov)]

@r.walde

the underlying table is locked for backend processes

This is certainly not a result of reading data for a standard entity browser screen.