activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gary Tully (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (AMQ-1086) Can't use SQL Server 2005 for persistence
Date Wed, 24 Jun 2009 12:10:37 GMT

     [ https://issues.apache.org/activemq/browse/AMQ-1086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Gary Tully resolved AMQ-1086.
-----------------------------

    Resolution: Fixed
      Assignee: Gary Tully

Fix from  https://issues.apache.org/activemq/browse/AMQ-1191 applied 

> Can't use SQL Server 2005 for persistence
> -----------------------------------------
>
>                 Key: AMQ-1086
>                 URL: https://issues.apache.org/activemq/browse/AMQ-1086
>             Project: ActiveMQ
>          Issue Type: Bug
>          Components: Message Store
>    Affects Versions: 4.1.0
>            Reporter: Tony Voss
>            Assignee: Gary Tully
>             Fix For: 5.3.0
>
>         Attachments: activemq2000.log, activemq2005.log, MSSql2005.zip
>
>
> When using SQL Server 2005 for persistence the following exception is thrown:
> java.sql.SQLException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.
>         at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
>         at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
>         at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
>         at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
>         at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
>         at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
>         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475)
>         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.start(BrokerService.java:394)
>         at org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet(XBeanBrokerService.java:47)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1062)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1029)
>         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:420)
>         at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
>         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)
>         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
>         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)
>         at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:290)
>         at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:348)
>         at org.apache.xbean.spring.context.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:161)
>         at org.apache.xbean.spring.context.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:51)
>         at org.apache.activemq.xbean.XBeanBrokerFactory.createBroker(XBeanBrokerFactory.java:41)
>         at org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:57)
>         at org.apache.activemq.console.command.StartCommand.startBroker(StartCommand.java:82)
>         at org.apache.activemq.console.command.StartCommand.runTask(StartCommand.java:63)
>         at org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:50)
>         at org.apache.activemq.console.command.ShellCommand.runTask(ShellCommand.java:65)
>         at org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:50)
>         at org.apache.activemq.console.command.ShellCommand.main(ShellCommand.java:46)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at org.apache.activemq.console.Main.runTaskClass(Main.java:159)
>         at org.apache.activemq.console.Main.main(Main.java:91)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message