I am using the following ant script for creating my databases:
Because i am using onerror="abort" It is aborting the ant build if any file produces the sql exception and stop executing that specific sql file.
For example if data3.sql having some err it will abort the ant but data1.sql and data2.sql files have already executed and their results do not roll back.
Is it possible to abort the whole operation rather that aborting the execution of a single sql file.?
What i want is that if any one of the sql files produces sql exception, all files which have already been executed before that file also roll back their output.
build.xml:5: only single argument resource collections are supported.
One more thing is that in my rela project my script files are not in a single folder they are in separate folders.
Please suggest me any way out of this problem.
Thanks and Regards,
Joined: Oct 03, 2007
Now i am trying to do it like the following :
It is stop executing a specific file's script if it contains any err because autocommit="false" but it does not roll back the results of other script files which have been executed already.
If any body has any idea?
thanks and regards,
The error "only single argument resource collections are supported. " tells me that the sql task will not let you span a transaction across multiple SQL source files. So try this: use the concat task to create a temporary file containing all of the SQL sources, give that temp file to the sql task, delete the temp file afterwards.