activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fuzzo <mcucc...@gmail.com>
Subject JDBC Master/Slave with HSQLDB lock problem!
Date Fri, 05 Sep 2008 14:59:37 GMT

Hi all!

When i try to start ActiveMQ with an HSQLDB data source i give this error:

INFO   | jvm 1    | 2008/09/05 16:55:46 | INFO  BrokerService                 
- Using Persistence Adapter:
JDBCPersistenceAdaptor(org.apache.commons.dbcp.BasicDataSource@d90453)
INFO   | jvm 1    | 2008/09/05 16:55:46 | INFO  JDBCPersistenceAdapter        
- Database driver recognized: [hsql_database_engine_driver]
INFO   | jvm 1    | 2008/09/05 16:55:46 | INFO  DefaultDatabaseLocker         
- Attempting to acquire the exclusive lock to become the Master broker
INFO   | jvm 1    | 2008/09/05 16:55:46 | ERROR DefaultDatabaseLocker         
- Failed to acquire lock: java.sql.SQLException: Termine inaspettato: FOR in
statement [SELECT * FROM ACTIVEMQ_LOCK FOR UPDATE]
INFO   | jvm 1    | 2008/09/05 16:55:46 | java.sql.SQLException: Termine
inaspettato: FOR in statement [SELECT * FROM ACTIVEMQ_LOCK FOR UPDATE]

In other words, the keyword FOR is unknown.
All is ok with useDatabaseLock="false" set in persistenceAdapter.

If the db is not locked, i can't do a Master/Slave HA cluster, isn't true?

Thanks for all!
-- 
View this message in context: http://www.nabble.com/JDBC-Master-Slave-with-HSQLDB-lock-problem%21-tp19333147p19333147.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.


Mime
View raw message