I am using a proxy to database scenario in which i am accessing four tables simultaneously.And i am using update_insert as an action attribute for all.Also i have created four statements for four tables.Now i am getting messages in XI as smaller chunks not a single message.So at the database side i am facing a deadlock issue.Error is :
Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'IF_Invoice_NO02' (structure 'StatementName'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Transaction (Process ID 77) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Could you please provide any help to avoid this issue and any guidance to resolve this.