activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gary Tully <gary.tu...@gmail.com>
Subject Re: I need JDBC Table definations.
Date Tue, 10 May 2011 21:42:31 GMT
it looks like we need a specialization of the create statements for terajdbc.

On 10 May 2011 12:49, mahens <mahenderreddy.leo@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

Mime
View raw message