You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@activemq.apache.org by kbd <KD...@escholar.com> on 2007/05/04 20:03:50 UTC
ActiveMQ 4.1.1 MS SQL Server 2005
Hello:
I am looking for help to get Active MQ and SQl Server 2005 running.
When I run Active MQ 4.1.1 configurued to use persistence SQL Server 2005
I get the following error.
ERROR DefaultDatabaseLocker - Failed to acquire lock:
com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: FOR U
PDATE clause allowed only for DECLARE CURSOR.
com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: FOR UPDATE clause
allowed only for DECLARE CURSOR.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown
Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(Unknown
Source)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:117)
at
org.apache.activemq.store.jdbc.DefaultDatabaseLocker.start(DefaultDatabaseLocker.java:59)
at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.start(JDBCPersistenceAdapter.java:175)
at
org.apache.activemq.store.journal.JournalPersistenceAdapter.start(JournalPersistenceAdapter.java:223)
at
org.apache.activemq.broker.BrokerService.createRegionBroker(BrokerService.java:1251)
at
org.apache.activemq.broker.BrokerService.createBroker(BrokerService.java:1209)
at
org.apache.activemq.broker.BrokerService.getBroker(BrokerService.java:508)
at
org.apache.activemq.broker.BrokerService.getAdminConnectionContext(BrokerService.java:1439)
at
org.apache.activemq.broker.BrokerService.startDestinations(BrokerService.java:1425)
at
org.apache.activemq.broker.BrokerService.start(BrokerService.java:383)
at
org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet(XBeanBrokerService.java:47)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCap
ableBeanFactory.java:1062)
I see that there are some postings on the site regarding this error and SQL
2000 from July 2006.
But I do not know if the same holds true for MS SQL 2005.
Would someone, please, be kind enough to point me to the MS SQL 2005
solution.
Many thanks
KD
--
View this message in context: http://www.nabble.com/ActiveMQ-4.1.1---MS-SQL-Server-2005-tf3693396s2354.html#a10327332
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
Re: ActiveMQ 4.1.1 MS SQL Server 2005
Posted by Jamie McCrindle <ja...@gmail.com>.
Hi,
As far as I'm aware you have two options: either switch off locking in
your jdbc adapter
(http://www.mail-archive.com/activemq-users@geronimo.apache.org/msg03257.html)
or try the code attached to this defect:
https://issues.apache.org/activemq/browse/AMQ-1086.
If you choose to switch off locking, Pure JDBC Master / Slave won't
work. I haven't tested the code attached to AMQ-1086 (but hopefully
will be at some point in the near future).
regards,
jamie.
On 5/4/07, kbd <KD...@escholar.com> wrote:
>
> Hello:
>
> I am looking for help to get Active MQ and SQl Server 2005 running.
> When I run Active MQ 4.1.1 configurued to use persistence SQL Server 2005
> I get the following error.
>
> ERROR DefaultDatabaseLocker - Failed to acquire lock:
> com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: FOR U
> PDATE clause allowed only for DECLARE CURSOR.
> com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: FOR UPDATE clause
> allowed only for DECLARE CURSOR.
> at
> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
> Source)
> at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown
> Source)
> at
> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown
> Source)
> at
> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown
> Source)
> at
> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown
> Source)
> at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown
> Source)
> at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
> Source)
> at
> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(Unknown
> Source)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:117)
> at
> org.apache.activemq.store.jdbc.DefaultDatabaseLocker.start(DefaultDatabaseLocker.java:59)
> at
> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.start(JDBCPersistenceAdapter.java:175)
> at
> org.apache.activemq.store.journal.JournalPersistenceAdapter.start(JournalPersistenceAdapter.java:223)
> at
> org.apache.activemq.broker.BrokerService.createRegionBroker(BrokerService.java:1251)
> at
> org.apache.activemq.broker.BrokerService.createBroker(BrokerService.java:1209)
> at
> org.apache.activemq.broker.BrokerService.getBroker(BrokerService.java:508)
> at
> org.apache.activemq.broker.BrokerService.getAdminConnectionContext(BrokerService.java:1439)
> at
> org.apache.activemq.broker.BrokerService.startDestinations(BrokerService.java:1425)
> at
> org.apache.activemq.broker.BrokerService.start(BrokerService.java:383)
> at
> org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet(XBeanBrokerService.java:47)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCap
> ableBeanFactory.java:1062)
>
> I see that there are some postings on the site regarding this error and SQL
> 2000 from July 2006.
> But I do not know if the same holds true for MS SQL 2005.
> Would someone, please, be kind enough to point me to the MS SQL 2005
> solution.
>
> Many thanks
>
> KD
>
>
> --
> View this message in context: http://www.nabble.com/ActiveMQ-4.1.1---MS-SQL-Server-2005-tf3693396s2354.html#a10327332
> Sent from the ActiveMQ - User mailing list archive at Nabble.com.
>
>