SQL Error :: Deadlocked On Locked Resources

SQL JDBC error :: Deadlocked On Locked Resources


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

EXTOL Business Integrator (EBI) SQL Database Error; Deadlocked On Locked Resources


Per the SQL Exception Transaction Message, the user will need to Rerun the transaction

By: on
A free web counter provided by GoStats.