Re: Trapping ORA errors in ANT

2007-04-08 Thread Andrew Goktepe
I have done this by using the sqlplus task from Incanto ( http://incanto.sourceforge.net/usage-sqlplus.html) with failonerror=true and the statement WHENEVER SQLERROR EXIT FAILURE ROLLBACK at the top of the SQL scripts being run. This will cause any ORA error to halt sqlplus, thus failing the Ant

RE: Trapping ORA errors in ANT

2007-04-03 Thread Karr, David
I also crossed this road, and I ended up using Jakarta Jelly to do this. It gives me specific Oracle errors, and it allows me to write more of a script, with reusable values and methods. > -Original Message- > From: Pankaj Arora01 [mailto:[EMAIL PROTECTED] > Sent: Monday, April 02, 2007