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
load('http://www.extol.com/extolnews.rss'); $feed = array(); foreach ($rss->getElementsByTagName('item') as $node) { $item = array ( 'title' => $node->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed, $item); } $limit = 4; echo ' A free web counter provided by GoStats.