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.
