Posted: Tue Aug 19, 2008 9:53 am Post subject: JDBC adapter 'Create' - deadlocked on lock resources
Master
Joined: 08 Jul 2003 Posts: 205
All,
I am trying to insert rows in a particular table in SQL Server using WBIA JDBC adapter and when the adapter is processing messages from the request queue, after inserting few rows it fails with the following error:
connector 2.6.9, FW 2.6.11
com.crossworlds.cwconnectorapi.exceptions.VerbProcessingFailedException: [Type: Error] [MsgID: 37004] [Mesg: Execution of Prepared Update Statement Failed : com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 63) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]
I noticed that there is a SQL trigger in the table which will pull the inserted rows and doesSomething() with the retrieved records.
Joined: 12 Sep 2006 Posts: 2493 Location: Boston, US
does your SQL trigger in the table runs parallel with the JDBC insertion _________________ Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum