Return-Path: Delivered-To: apmail-geronimo-activemq-dev-archive@www.apache.org Received: (qmail 35660 invoked from network); 20 Dec 2006 01:27:04 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 20 Dec 2006 01:27:04 -0000 Received: (qmail 3497 invoked by uid 500); 20 Dec 2006 01:27:11 -0000 Delivered-To: apmail-geronimo-activemq-dev-archive@geronimo.apache.org Received: (qmail 3381 invoked by uid 500); 20 Dec 2006 01:27:11 -0000 Mailing-List: contact activemq-dev-help@geronimo.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: activemq-dev@geronimo.apache.org Delivered-To: mailing list activemq-dev@geronimo.apache.org Received: (qmail 3372 invoked by uid 99); 20 Dec 2006 01:27:11 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 19 Dec 2006 17:27:11 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of lists@nabble.com designates 72.21.53.35 as permitted sender) Received: from [72.21.53.35] (HELO talk.nabble.com) (72.21.53.35) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 19 Dec 2006 17:27:00 -0800 Received: from [72.21.53.38] (helo=jubjub.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1GwqEB-0003bq-Ts for activemq-dev@geronimo.apache.org; Tue, 19 Dec 2006 17:26:39 -0800 Message-ID: <7983092.post@talk.nabble.com> Date: Tue, 19 Dec 2006 17:26:39 -0800 (PST) From: "rain.xk" To: activemq-dev@geronimo.apache.org Subject: Re: error when start broker In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: rain.xk@gmail.com References: <7942260.post@talk.nabble.com> X-Virus-Checked: Checked by ClamAV on apache.org I have not used a pessimistic lock on database record in sybase ASE 12.5. :( Is this the sybase's defect? Hiram Chirino wrote: > > How do you do a pessimistic lock on database record in sybase ASE 12.5?? > > On 12/19/06, rain.xk wrote: >> >> Hi, >> My database is sybaseASE12.5,and I use the activemq4.1.0. >> The following is the series of messages when I start broker: >> >> - ActiveMQ 4.1.0-incubator JMS Message Broker (xuke) is starting >> - For help or more information please see: >> http://incubator.apache.org/activemq/ >> - Database driver recognized: [jconnect__tm__for_jdbc__tm_] >> - Attempting to acquire the exclusive lock to become the Master broker >> - Failed to acquire lock: com.sybase.jdbc3.jdbc.SybSQLException: FOR >> UPDATE >> can not be used in a SELECT which is not part of the declaration of a >> cursor >> or which is not a stored procedure. >> com.sybase.jdbc3.jdbc.SybSQLException: FOR UPDATE can not be used in a >> SELECT which is not part of the declaration of a cursor or which is not a >> stored procedure. >> at com.sybase.jdbc3.tds.Tds.a(Unknown Source) >> at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) >> at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) >> at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) >> at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) >> at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source) >> at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source) >> at com.sybase.jdbc3.jdbc.SybPreparedStatement.execute(Unknown >> Source) >> at >> org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:117) >> at >> org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:117) >> at >> org.apache.activemq.store.jdbc.DefaultDatabaseLocker.start(DefaultDatabaseLocker.java:59) >> >> How can I handle this? >> -- >> View this message in context: >> http://www.nabble.com/error-when-start-broker-tf2844348.html#a7942260 >> Sent from the ActiveMQ - Dev mailing list archive at Nabble.com. >> >> > > > -- > Regards, > Hiram > > Blog: http://hiramchirino.com > > -- View this message in context: http://www.nabble.com/error-when-start-broker-tf2844348.html#a7983092 Sent from the ActiveMQ - Dev mailing list archive at Nabble.com.