enable debug logging for org.apache.activemq.store.jdbc.DefaultDatabaseLocker to get a handle on the root cause exception to see what is going on with the lock implementation. That may also need a specialisation.
On 11 May 2011 12:32, mahens <mahenderreddy....@gmail.com> wrote: > created the statements manually on my database: > CREATE TABLE ACTIVEMQ_MSGS > (ID BIGINT NOT NULL, > CONTAINER VARCHAR(250), > MSGID_PROD VARCHAR(250), > MSGID_SEQ BIGINT, > EXPIRATION BIGINT, > MSG BYTE, > PRIMARY KEY ( ID ) ); > > CREATE INDEX ACTIVEMQ_MSGS_MIDX ON ACTIVEMQ_MSGS (MSGID_PROD,MSGID_SEQ); > > CREATE INDEX ACTIVEMQ_MSGS_CIDX ON ACTIVEMQ_MSGS (CONTAINER); > > CREATE INDEX ACTIVEMQ_MSGS_EIDX ON ACTIVEMQ_MSGS (EXPIRATION); > > > still getting same error like: > > Using Persistence Adapter: > JDBCPersistenceAdapter(org.apache.commons.dbcp.BasicDataSource@307b4703) > INFO | Database adapter driver override not found for : > [com_teradata_jdbc_teradriver]. Will use default implementation. > INFO | Database lock driver override not found for : > [com_teradata_jdbc_teradriver]. Will use default implementation. > INFO | Attempting to acquire the exclusive lock to become the Master broker > INFO | Failed to acquire lock. Sleeping for 1000 milli(s) before trying > again... > INFO | Failed to acquire lock. Sleeping for 1000 milli(s) before trying > again... > INFO | Failed to acquire lock. Sleeping for 1000 milli(s) before trying > again... > INFO | Failed to acquire lock. Sleeping for 1000 milli(s) before trying > again... > > > > -- > View this message in context: > http://activemq.2283324.n4.nabble.com/I-need-JDBC-Table-definations-tp3511491p3514432.html > Sent from the ActiveMQ - User mailing list archive at Nabble.com. > -- http://blog.garytully.com http://fusesource.com
