Return-Path: Delivered-To: apmail-ant-dev-archive@www.apache.org Received: (qmail 14744 invoked from network); 3 Jan 2006 05:20:21 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 3 Jan 2006 05:20:21 -0000 Received: (qmail 95705 invoked by uid 500); 3 Jan 2006 05:20:20 -0000 Delivered-To: apmail-ant-dev-archive@ant.apache.org Received: (qmail 95344 invoked by uid 500); 3 Jan 2006 05:20:19 -0000 Mailing-List: contact dev-help@ant.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Ant Developers List" Reply-To: "Ant Developers List" Delivered-To: mailing list dev@ant.apache.org Received: (qmail 95332 invoked by uid 99); 3 Jan 2006 05:20:18 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Jan 2006 21:20:18 -0800 X-ASF-Spam-Status: No, hits=1.7 required=10.0 tests=DNS_FROM_RFC_ABUSE,HTML_MESSAGE,RCVD_IN_SORBS_WEB X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [206.190.49.20] (HELO web52910.mail.yahoo.com) (206.190.49.20) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 02 Jan 2006 21:20:18 -0800 Received: (qmail 2049 invoked by uid 60001); 3 Jan 2006 05:19:57 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=sA2DOIM2T1LFk6GHfU5EyO23XPrcYxuTwpS55DbXUDZKjza5NUcZIR/n1BvJ90NLOye5CdVCIxI3XfoHU96VzyB6yS6F75IXr1Z+pcDUFYiF1s3Zji4sbM2pKqZk8ChGa77dgvi/6ZxpvbeUfkru9RbAoStxg7ONa3ba6vEz9Vo= ; Message-ID: <20060103051957.2047.qmail@web52910.mail.yahoo.com> Received: from [203.101.103.131] by web52910.mail.yahoo.com via HTTP; Mon, 02 Jan 2006 21:19:57 PST Date: Mon, 2 Jan 2006 21:19:57 -0800 (PST) From: VGupta Subject: Problem: Ant's SQL task does not support copy via indirection To: user@ant.apache.org, dev@ant.apache.org In-Reply-To: <001701c6101a$94576f30$a90205c0@Vinod> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1017686715-1136265597=:1769" Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N --0-1017686715-1136265597=:1769 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit If the sql file contains data to be loaded in the following format COPY bcd (PolicySymbol, StateCode, SqlTable, CallType, SubType, FieldIdentifier, TagName) FROM stdin; PAC $$ AGR_ST_COV RATE/AUDIT MOD_FACTOR4 PRICING TIER PAC $$ AGR_ST_COV RATE/AUDIT MOD_FACTOR5 CAPPING FACTOR ................................. The above call to sql task would hang as there is ome problem with the sql task. (I think ant tasks expects sql statements and does not support copy via redirection to stdin.) Can anybody please suggest me some way of loading this sql file on a database server which is running on a remote machine. Regards, Vipul Gupta --------------------------------- Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. --0-1017686715-1136265597=:1769--