Return-Path: X-Original-To: apmail-activemq-users-archive@www.apache.org Delivered-To: apmail-activemq-users-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C3C995C71 for ; Tue, 10 May 2011 11:49:52 +0000 (UTC) Received: (qmail 86689 invoked by uid 500); 10 May 2011 11:49:52 -0000 Delivered-To: apmail-activemq-users-archive@activemq.apache.org Received: (qmail 86665 invoked by uid 500); 10 May 2011 11:49:52 -0000 Mailing-List: contact users-help@activemq.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@activemq.apache.org Delivered-To: mailing list users@activemq.apache.org Received: (qmail 86657 invoked by uid 99); 10 May 2011 11:49:52 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 May 2011 11:49:52 +0000 X-ASF-Spam-Status: No, hits=2.0 required=5.0 tests=FREEMAIL_FROM,RFC_ABUSE_POST,SPF_NEUTRAL,T_TO_NO_BRKTS_FREEMAIL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: 216.139.236.26 is neither permitted nor denied by domain of mahenderreddy.leo@gmail.com) Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 May 2011 11:49:45 +0000 Received: from joe.nabble.com ([192.168.236.139]) by sam.nabble.com with esmtp (Exim 4.69) (envelope-from ) id 1QJlRN-0004t5-2f for users@activemq.apache.org; Tue, 10 May 2011 04:49:25 -0700 Date: Tue, 10 May 2011 04:49:25 -0700 (PDT) From: mahens To: users@activemq.apache.org Message-ID: <1305028165064-3511614.post@n4.nabble.com> In-Reply-To: <1305027377751-3511592.post@n4.nabble.com> References: <1305023340897-3511491.post@n4.nabble.com> <1305027377751-3511592.post@n4.nabble.com> Subject: Re: I need JDBC Table definations. MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org 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.