I am getting this error repeated on JBoss with MS SQL 2005 server and I think due to this some of my short lived processes are not working as expected.
2012-03-30 15:09:03,510 ERROR [org.jboss.ejb.plugins.LogInterceptor] RuntimeException in method: public abstract com.adobe.pof.omapi.POFObjectSet com.adobe.pof.omapi.POFObjectManagerLocal.retrieveObjectSet(com.adobe.pof.omapi.POFQuery,int,int,com.adobe.idp.Context) throws com.adobe.pof.POFException:
com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 79) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Can anyone please help me to understand this error.