Return-Path: 
 <user-return-65883-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@www.apache.org
Received: (qmail 76609 invoked from network); 16 Sep 2008 15:35:29 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 16 Sep 2008 15:35:29 -0000
Received: (qmail 69528 invoked by uid 500); 16 Sep 2008 15:35:21 -0000
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 69499 invoked by uid 500); 16 Sep 2008 15:35:21 -0000
Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:user-unsubscribe@ant.apache.org>
List-Help: <mailto:user-help@ant.apache.org>
List-Post: <mailto:user@ant.apache.org>
List-Id: "Ant Users List" <user.ant.apache.org>
Reply-To: "Ant Users List" <user@ant.apache.org>
Delivered-To: mailing list user@ant.apache.org
Received: (qmail 69488 invoked by uid 99); 16 Sep 2008 15:35:21 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Sep 2008 08:35:21 -0700
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [87.224.50.119] (HELO soho.greekattic.com) (87.224.50.119)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Sep 2008 15:34:23 +0000
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C91811.C44A8A77"
Subject: ant sql task with keepformat
Date: Tue, 16 Sep 2008 16:34:53 +0100
Message-ID: <B8B32E4CCA315F4082D7491491063CC584B0FA@mimas.greekattic.local>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: ant sql task with keepformat
Thread-Index: AckYEcQO4cICe9cBQNy985eQGHgAeQ==
From: "Gareth Davies" <gruff@sitemaker.cc>
To: <user@ant.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org

------_=_NextPart_001_01C91811.C44A8A77
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I'm trying to use ant's sql task to execute scripts on a Sybase ASE
12.5.1 database.  I thought everything was working but realized that
without the 'keepformat' attribute set my SQL files are being munged
(lined endings and comments being stripped) which means stored procs are
being munged on creation.

=20

The trouble is, when I set keepformat this seems to be incompatible with
the delimeter and delimitertype attributes: delimiters are ignored and
the whole file is sent through.  I get the following error:

com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near 'go'.

=20

I've searched the archives and past mails seem to indicate setting the
escapeprocessing might help but it doesn't.  I've tried changing the
delimiter.

=20

Example sql task below.  Any workunit.sql in the file list below
containing a 'go' causes the above error.  Any help much appreciated.
Thanks

=20

Gareth

       <sql

           driver=3D"${db.driver}"

           url=3D"${db.url}"

           userid=3D"${db.user}"

           password=3D"${db.password}"=20

            classpath=3D"${db.classpath}"

            append=3D"true"

            caching=3D"on"

            delimiter=3D"go"

            delimitertype=3D"row"

            print=3D"true"

              autocommit=3D"true"

              keepformat=3D"true"

              escapeprocessing=3D"true"

              >

             =20

                     select @@servername

                     go

              <path>              =20

                  <filelist dir=3D".">

                     <file name=3D"workunit1.sql" />

                     <file name=3D"workunit1.sql "/>

                  </filelist>

              </path>

       </sql>


------_=_NextPart_001_01C91811.C44A8A77--