I want to use ant to run sql scripts for a build. I grab all these sql scripts files from a specific folder, so I know how to grab them and run them using the sql ant task. But I want to perform this task little different.
1. I want to grab the user id, password and url from a file (data source file).
2. If the script is throwing some error, I want to log that error/display the error in the console and move on.
3. I want to perform the above steps only if I am on my local machine/or in a predefined environment.
4. Finally, I want to jar-up the new class and add to the class path.
I haven’t done much in terms of overriding the ant task or extending it to perform additional tasks. So please give me some ideas of how to do this. I really appreciate any help on this.