Thread: select current_setting('transaction_isolation')

Howdy,

I recently did a log_min_duration_statement=0 run on my app, and found ~3million copies of
"select current_setting('transaction_isolation')"

I'm a Java + Hibernate stack. Does anyone know if this is a Hibernate artifact? or a jdbc artifact?
or something else (implicit to some query pattern or trigger)?

Thanks

Dave

JDBC does not query the database for the transaction isolation level for the current session/connection on its own unless you application [or even it could be hibernate] queries the same by calling : connection.getTransactionIsolation() method.

I doubt even if Hibernate would do that since it does not need to query each time what the transaction isolation level of the current connection is and would most probably cache that info in each Session instance.

So, it would be better you verify if your application specific code is relying on some particular transaction isolation level and is ensuring that the every query run on the database is actually running under that particular transaction isolation level.

Regards,
Samba

============================================================