it looks like we need a specialization of the create statements for terajdbc.
On 10 May 2011 12:49, mahens <mahenderreddy....@gmail.com> wrote: > 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. > -- http://blog.garytully.com http://fusesource.com
