TRANSACTION ISOLATION LEVEL in postgres before loop

Highlighted
Six Stars

TRANSACTION ISOLATION LEVEL in postgres before loop

Hello, 

I need to use the Transaction isolation level to guarantee that the data is the same at the end of the loop. I have a loop to read from a database in batch.

The thing is that this is returning an error: SET TRANSACTION ISOLATION LEVEL must be called before any queryException in component tDBInput_2

In the image, I have a piece of job talend, and the transaction code is in tDBRow_2 out of the loop like I think it must be. I do not have a commit, because I'm reading to a file.

 

Loop_Transaction.PNG

My question is: how can I do this to guarantee the coherence of that the data?

Anyone can help me?

 

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog