If SQL stored procedure raises any error then it does not throw any exception in java code

JDBC drivers should throw error is with severity greater than 10. But it does not, if you are using CallableStatement.execute()

If you need to catch error then use executeUpdate() method. But executeUpdate() does not return result sets. You can use executeUpdate() if you are not returning anything.

Anybody knows solution for this issue?

1,994 total views, 2 views today

CallableStatement execute() does not throw exception if error in stored procedure in Java JDBC
Tagged on:                 

Leave a Reply

Your email address will not be published. Required fields are marked *