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: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
