You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@activemq.apache.org by Sh...@sungard.com on 2012/01/27 10:19:11 UTC

Sql Server for master slave

Hi,

I want to use "SQL Server 2008" for Master/Slave configuration.
However it is not allowing to have database locks with exception as below :

ERROR | Failed to acquire lock: com.microsoft.sqlserver.jdbc.SQLServerException:
A processing error "Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR."
has occurred.
com.microsoft.sqlserver.jdbc.SQLServerException: A processing error "Line 1: FOR
UPDATE clause allowed only for DECLARE CURSOR." has occurred.

Can anyone please help?

Thanks,
Sheetal.