SQL Error :: Deadlocked On Locked Resources

SQL JDBC error :: Deadlocked On Locked Resources

Scenario:

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.

Issue:

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

Resolution:

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



By: on
A free web counter provided by GoStats.