We recently upgraded our Pentaho Kettle CE version from 4.1.0 to 4.2.0 stable and we are facing one issue which we never faced in Pentaho 4.1.0 stable.
Please see the below use case.
1) We have two Jobs let's say Job_A and Job_B.
2) Job_A transfer certain data and insert few rows.
3) Job_B then refers the table in which data was inserted in Job_A and it either insert/update the data based on that.
4) The issue we are facing is somehow the connection is not committing the data in the database and second job also tries to insert the data with same identified resulting in unique constraint error.
5) Is there any reason why inserted data is not getting committed immediately, is there any way by which we can force commit the data? We are using Execute SQL Script component.

Please let me know if you have a quick fix/work around for this issue? With 4.1.0 it is working perfectly fine.

Saurabh V.