activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hiram Chirino" <hi...@hiramchirino.com>
Subject Re: error when start broker
Date Wed, 20 Dec 2006 18:56:03 GMT
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

Mime
View raw message