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.
