activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kbd <KDu...@escholar.com>
Subject ActiveMQ 4.1.1 MS SQL Server 2005
Date Fri, 04 May 2007 18:03:50 GMT

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.


Mime
View raw message