activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "rain.xk" <rain...@gmail.com>
Subject Re: error when start broker
Date Thu, 21 Dec 2006 02:11:27 GMT

Oh,I will wait...
Please replay when you can  figure out how to do it with sybase.


Hiram Chirino wrote:
> 
> every DB is slightly different we just need to figure out how to do it
> with sybase.
> 
> On 12/19/06, rain.xk <rain.xk@gmail.com> wrote:
>>
>> 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 <rain.xk@gmail.com> 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.
>>
>>
> 
> 
> -- 
> Regards,
> Hiram
> 
> Blog: http://hiramchirino.com
> 
> 

-- 
View this message in context: http://www.nabble.com/error-when-start-broker-tf2844348.html#a8001705
Sent from the ActiveMQ - Dev mailing list archive at Nabble.com.


Mime
View raw message