Need something like WHENEVER SQLERROR EXIT for scripts

Hello!

First off, this is an awesome tool and a much needed utility.

I was wondering how hard it would be to add either a flag or a command so that if any Exception occurs when reading a script to stop executing the remainder of the script.

Thanks!

Dan

Great idea! - that would be very easy to add. Let me see what I can do.

I agree that the tool is very useful, so thanks for writing it. And I'm particularly grateful that you output errors to stderr instead of stdout. The original post here was made a long time ago, so I was wondering: did the idea get shot down? I made a quick change to add this feature as a command-line option (thanks for the source!) and a check for the flag when catching an SQLException that then exits the program, but I'm not confident that my solution is the best solution. Therefore, I would just like to know if this is something that might make it into an official release in the near future. Or am I completely missing something, and it is already available?

No, it got missed when I did the 2.x update

What do you think would make sense for an exit value? I generally try to follow the Unix pattern of exiting with a zero when everything worked ok, and non-zero other wise. Some programs try to use the exit value as almost an interprocess communication mechanism but that gets a bit complicated. Right now there is an exit with a one if some simple errors occur - should the SQLException be different?

Thanks for your feedback - I can role this in pretty quick but would like to make sure that it is useful to you too.

All I am catching is that an error occurred, so an exit code of 1 works great for me. I suppose you could add an optional parameter for people who want to specify a different exit code, but that might be getting needlessly complicated.

In short, I like 1.