Use uncommitted reads?


(Andrew Robinson) #1

Is it possible to set the database connection to use uncommitted reads so it doesn’t cause read locks?


(Said Abduraimov) #2

Hi Andrew,

Please, try one of the following query strings in the JDBC Reader step

The first query:

SET TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED
select column_name from table_name

The second query:

select column_name from table_name with (READUNCOMMITTED)

We assume that you may need to setup the uncommitted read availability on the database side, as well.