In The scenario below, we are attempting to perform a SQL Select in EXTOL Business Integrator (EBI) 2.x. In our Business Process Script we are attempting to move database data to another database -- Source: iSeries DB2. Target: Oracle 11g
The error below is issued when we perform the SQL Select from the iSeries DB2 JDBC connection.
While performing a JDBC SQL Select via Database Adapter we encountered a locked object.
EXTOL error message:
SQL Error 1205: Deadlocked On Locked Resources with another process and has been chosen as the the deadlock victim. Rerun the transaction
Per the SQL Exception Transaction Message, the user will need to Rerun the transaction
By: Sean Hoppe on