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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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.
