Thanks Gary Tully, as you said it creates tables during startup so i removed tables from database.Now i tryed to start the broker but getting error like:
INFO | Using Persistence Adapter: JDBCPersistenceAdapter(org.apache.commons.dbcp.BasicDataSource@34c7e8a7) INFO | Database adapter driver override not found for : [com_teradata_jdbc_teradriver]. Will use default implementation. WARN | Could not create JDBC tables; they could already exist. Failure was: CREATE INDEX ACTIVEMQ_MSGS_MIDX ON ACTIVEMQ_MSGS (MSGID_PROD,MSGID_SEQ) Message: [Teradata Database] [TeraJDBC 13.10.00.18] [Error 3706] [SQLState 42000] Syntax error: Must specify index field(s) for CREATE INDEX. SQLState: 42000 Vendor code: 3706 WARN | Failure details: [Teradata Database] [TeraJDBC 13.10.00.18] [Error 3706] [SQLState 42000] Syntax error: Must specify index field(s) for CREATE INDEX. com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 13.10.00.18] [Error 3706] [SQLState 42000] Syntax error: Must specify index field(s) for CREATE INDEX. -- View this message in context: http://activemq.2283324.n4.nabble.com/I-need-JDBC-Table-definations-tp3511491p3511614.html Sent from the ActiveMQ - User mailing list archive at Nabble.com.
