How to setup isolation level?

OpenInformix / IfxPy

Informix native Python driver for scalable enterprise and IoT solutions.

Other

46 stars 22 forks source link

Closed melinhunter closed 4 years ago

melinhunter commented 4 years ago

info = IfxPy.server_info (conn) info.DFT_ISOLATION is CS. info.ISOLATION_OPTION is ('UR', 'CS', 'RR')

how to do change default isolation level to read uncommitted?

jsagrera commented 4 years ago

I don't think we have any option to change the isolation within the driver itself, so the only way will be to do it directly with an SQL statement:

IfxPy.exec_immediate(conn, "SET ISOLATION DIRTY READ")