ant-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 28416] New: - cannot recurse SQL command scripts
Date Thu, 15 Apr 2004 18:20:42 GMT
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


Mime
View raw message