We write application using ColdFusion and the database is SQL server. There is a table which have a text field and this table is always be updated concurrently by 8-10 users. The db is running transactional replication.
We used the following two approaches to insert or update data:
1. <CFQuery> ... </CFQuery>
2. call stored_procedure of sql server.
Both methods induce the following error:
ODBC Error Code = 40001 (Serialization failure)
[Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID #43) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction.
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (253:4) to (253:50).
Any one can help me to solve?
We used the following two approaches to insert or update data:
1. <CFQuery> ... </CFQuery>
2. call stored_procedure of sql server.
Both methods induce the following error:
ODBC Error Code = 40001 (Serialization failure)
[Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID #43) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction.
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (253:4) to (253:50).
Any one can help me to solve?