Mailing-List: contact dev-help@activemq.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@activemq.apache.org
Message-ID: <211609753.1258115572813.JavaMail.jira@brutus>
Date: Fri, 13 Nov 2009 04:32:52 -0800 (PST)
From: "Gary Tully (JIRA)" <jira@apache.org>
To: dev@activemq.apache.org
Subject: [jira] Commented: (AMQ-1109) Start Broker SQL Exception
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit


    [ 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.