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 C9E845BDB for ; Thu, 12 May 2011 09:11:17 +0000 (UTC) Received: (qmail 88318 invoked by uid 500); 12 May 2011 09:11:17 -0000 Delivered-To: apmail-activemq-users-archive@activemq.apache.org Received: (qmail 88245 invoked by uid 500); 12 May 2011 09:11:16 -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 88237 invoked by uid 99); 12 May 2011 09:11:16 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 May 2011 09:11:16 +0000 X-ASF-Spam-Status: No, hits=0.6 required=5.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,RFC_ABUSE_POST,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of gary.tully@gmail.com designates 209.85.216.171 as permitted sender) Received: from [209.85.216.171] (HELO mail-qy0-f171.google.com) (209.85.216.171) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 May 2011 09:11:09 +0000 Received: by qyj19 with SMTP id 19so3410225qyj.2 for ; Thu, 12 May 2011 02:10:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=4121B7BTNzsbfGJU/FjA/cSIM9k7JwLAeUjn5+mkcCI=; b=aGMYJ/8Rw7qGEIJw0iHBjgL5cWhZI/KVi1dxKte2DjPUr00eJRPC2kOrzz0Hpv7DFt GMzdp7F2gHfxkiyfAqz3ROhGNiRP1gKxqk+x5cC/tw12K5krQlXd+d1FBpAgiI0ZiQzf j1fIoDjjShh3fwihEXVza1QN83Dj2ZogmvNMQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=BhxWh8cCYSF084dNYH30aZ0AFYPtOi00WRtBHTb5RNL3i1qwyPvmyuwUY0nRhvBqcO evaLVOWflDQNjdmhPM9hg34M4YAdkSZgOCX3V1n3F1VxxNlh4U5f1GguI21NMfum4XPE vFpuqLD0XNcI9Z5QCE+VNWwmOsHLHRf4t1K6g= MIME-Version: 1.0 Received: by 10.229.7.2 with SMTP id b2mr8085101qcb.179.1305191448346; Thu, 12 May 2011 02:10:48 -0700 (PDT) Received: by 10.229.84.207 with HTTP; Thu, 12 May 2011 02:10:48 -0700 (PDT) In-Reply-To: <1305175204743-3516486.post@n4.nabble.com> References: <1305023340897-3511491.post@n4.nabble.com> <1305027377751-3511592.post@n4.nabble.com> <1305028165064-3511614.post@n4.nabble.com> <1305113571669-3514432.post@n4.nabble.com> <1305175204743-3516486.post@n4.nabble.com> Date: Thu, 12 May 2011 10:10:48 +0100 Message-ID: Subject: Re: I need JDBC Table definations. From: Gary Tully To: users@activemq.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org so the sql syntax for the update statement used by the locker is not supported. So we need a specialisation of the database lock statement also. Have a look at http://activemq.apache.org/jdbc-support.html where you can see an example of overriding one of the sql statements. But more generally we need to add support for the teradata sql dialect. To see the existing specialisations, peek at the source, you should be able to make one that works for Terradata. http://svn.apache.org/viewvc/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/adapter/ On 12 May 2011 05:40, mahens wrote: > http://activemq.2283324.n4.nabble.com/file/n3516486/activemq.log activemq.log > > please find i upload log file after enabling debug logging for > org.apache.activemq.store.jdbc.DefaultDatabaseLocker > > -- > View this message in context: http://activemq.2283324.n4.nabble.com/I-need-JDBC-Table-definations-tp3511491p3516486.html > Sent from the ActiveMQ - User mailing list archive at Nabble.com. > -- http://blog.garytully.com http://fusesource.com