Return-Path: 
 <dev-return-57109-apmail-ant-dev-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-dev-archive@www.apache.org
Received: (qmail 43930 invoked from network); 15 Apr 2004 18:20:04 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 15 Apr 2004 18:20:04 -0000
Received: (qmail 51147 invoked by uid 500); 15 Apr 2004 18:19:53 -0000
Delivered-To: apmail-ant-dev-archive@ant.apache.org
Received: (qmail 51114 invoked by uid 500); 15 Apr 2004 18:19:52 -0000
Mailing-List: contact dev-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:dev-unsubscribe@ant.apache.org>
List-Subscribe: <mailto:dev-subscribe@ant.apache.org>
List-Help: <mailto:dev-help@ant.apache.org>
List-Post: <mailto:dev@ant.apache.org>
List-Id: "Ant Developers List" <dev.ant.apache.org>
Reply-To: "Ant Developers List" <dev@ant.apache.org>
Delivered-To: mailing list dev@ant.apache.org
Received: (qmail 51100 invoked from network); 15 Apr 2004 18:19:52 -0000
Received: from unknown (HELO exchange.sun.com) (192.18.33.10)
  by daedalus.apache.org with SMTP; 15 Apr 2004 18:19:52 -0000
Received: (qmail 1847 invoked by uid 50); 15 Apr 2004 18:20:42 -0000
Date: 15 Apr 2004 18:20:42 -0000
Message-ID: <20040415182042.1846.qmail@nagoya.betaversion.org>
From: bugzilla@apache.org
To: dev@ant.apache.org
Cc: 
Subject: DO NOT REPLY [Bug 28416] New:  -
    cannot recurse SQL command scripts
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=28416>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=28416

cannot recurse SQL command scripts

           Summary: cannot recurse SQL command scripts
           Product: Ant
           Version: 1.5
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: Core
        AssignedTo: dev@ant.apache.org
        ReportedBy: rchrenko@yahoo.com


I have the following ANT task in which I start the script file CreateAll.sql 
which contains references to further SQL scripts (see code below). How can I get 
Ant to "include" and execute SQL from the underlying scripts?

### BuildTables.sql ###
<target name="buildTables" depends="buildDatabase" description="build all 
tables">
    <sql
        driver="org.hsqldb.jdbcDriver"
        url="jdbc:hsqldb:E:\DatabaseTemp\Catalogs"
        userid="sa"
        password=""
        src=".\Database\Scripts\CreateAll.sql"
    >
    <classpath>
        <pathelement location="..\lib\hsqldb.jar"/>
    </classpath>
    </sql>
</target>

### CreateAll.sql ###
@CreateRegions.sql;
@CreateCountries.sql;
@CreateCities.sql;
@InsertRegions.sql;
@InsertCountries.sql;
@InsertCities.sql;
@ConstraintsCountries.sql;
@ConstraintsCities.sql;

### CreateRegions.sql ###
CREATE CACHED TABLE REGIONS (UID INTEGER NOT NULL IDENTITY PRIMARY KEY,
LASTCHANGED BIGINT,SPFINDEX INTEGER NOT NULL,NAME VARCHAR,
UNIQUE(NAME));

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@ant.apache.org
For additional commands, e-mail: dev-help@ant.apache.org