ISAM error: record is locked. - How do I skip locked records ?

[Anonymous]

I am running a job. reading data from database and writing it to dataware database using Talend. I get an error saying record is locked. How Do I skip records that are locked in database and continue with next records?

[Anonymous]

Hi
Does the error occur on input component or output component? Please show us the whole error message.
Best regards
Shong

[Anonymous]

it happens on Input componant. when it is reading data from a table.

[Anonymous]

which database sys?
according to the transactional isolation level, database must guarantee transactional consistency so they can't just "skip", at least they can return an "old" consistent version of the rows being locked.
check the transaction isolation of your read statements.

[Anonymous]

I usally put set isolation dirty read at beginging of select statement. But Talend doesn't allow that. Can you tell me how to transaction isoalation of select statement?

[Anonymous]

Thanks emaxt6.
Informix.

[Anonymous]

I usally put set isolation dirty read at beginging of select statement. But Talend doesn't allow that. Can you tell me how to transaction isoalation of select statement?

Using a tInformixConnection to create a db connection, and then write your set isolation dirty query on tInformixRow component, the job looks like:
tInformixConnection
|
onsubjobok
|
tInformixRow
|
onsubjobok
|
tInformixInput---main-->tLogRow
|
onsubjobok
|
tInformixCommit
Both tInformixRow and tInformixInput use the an existing connection created by tInformixConnection .
Best regards
Shong

[Anonymous]

Thank You Shong. So should I have set isolation dirty read on tInformixRow and then have select statement query on tInformixInput componant?

[_AnonymousUser]

I run my job and in the output file no of records is not equal to the input file records neither does it show up in rejects.
Kindly suggest.