Re: error when start broker
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
Re: error when start broker
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.
error when start broker
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.