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] Commented: (AMQ-1109) Start Broker SQL Exception
Date Fri, 13 Nov 2009 12:32:52 GMT

    [ https://issues.apache.org/activemq/browse/AMQ-1109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=55397#action_55397
] 

Gary Tully commented on AMQ-1109:
---------------------------------

HiSkill,
so is your problem that the messages table create fails? if so, what is the error you get?
If not, is your problem with the locker implementation. If so, do you know what will work?
the locker implementation can be overridden on an adapter basis by adding an implementation
reference to the finder resource location. see: http://svn.apache.org/viewvc/activemq/tags/activemq-5.3.0/activemq-core/src/main/resources/META-INF/services/org/apache/activemq/store/jdbc/lock/microsoft_sql_server_2005_jdbc_driver?view=markup
for the microsoft_sql_server_2005_jdbc_driver override from the default. 
You can implement your own and have it picked up by adding the corresponding resource to the
classpath.

> Start Broker SQL Exception
> --------------------------
>
>                 Key: AMQ-1109
>                 URL: https://issues.apache.org/activemq/browse/AMQ-1109
>             Project: ActiveMQ
>          Issue Type: Bug
>          Components: Broker
>    Affects Versions: 4.1.0
>         Environment: Windows 2000, SQL 2005
>            Reporter: Artem
>            Priority: Critical
>             Fix For: 5.4.0
>
>         Attachments: activemq.log
>
>   Original Estimate: 0 minutes
>  Remaining Estimate: 0 minutes
>
> 1. Create DB for ActiveMQ
> 2. Start broker using jtds SQL 2005 driver. 
> 3. Exception: 
> 2006-12-27 11:08:48,796 [main           ] INFO  JDBCPersistenceAdapter         - Database
driver recognized: [jtds_type_4_jdbc_driver_for_ms_sql_server_and_sybase]
> 2006-12-27 11:08:48,983 [main           ] INFO  DefaultDatabaseLocker          - Attempting
to acquire the exclusive lock to become the Master broker
> 2006-12-27 11:08:48,983 [main           ] ERROR DefaultDatabaseLocker          - Failed
to acquire lock: java.sql.SQLException: Line 1: FOR UPDATE clause allowed only for DECLARE
CURSOR.
> 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.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:47)
> 	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(Unknown Source)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> 	at java.lang.reflect.Method.invoke(Unknown Source)
> 	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