tOracleOutput - resource busy and acquire with NOWAIT specified error
Could you please someone advice me to handle the below error?
Exception in component tOracleOutput_2
java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAIT specified
My job is very simple like the following sequence and only 20 records I have read and insert into output after truncate.
tOracleInput - tMap - tOracleOutput
But I often get the error message says that "java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAIT specified" against my "tOracleOutput" component.
you have an open session that is locking the table. If you dont have any uncommitted transactions outside of talend, you may be able to fix this by using the tOracleConnection and a tOracleCommit components to make the job run under a single session.
- tOracleOutput "table" mentioned in output is common table for other operations also, So how can I control this error in my talend job. Is there any wait option I can specify if the resource is busy.
