Hi David,
Thanks for the reply, but it still doesn't seem to run.
I followed the following steps:
1) updated the on_error_stop value to 1
2) Ran a command that should fail and exit
3) Checked my java log and it shows it ran without errors and continued with the program.
Right now I have been able to write the error into a log file and then read it to check if there was any error, but that doesn't seem to be a very optimized way of handling psql error.
Request you if you could provide me some more tips on how to handle it.
Thanks,
Aman