1 Reply Latest reply on Apr 1, 2015 5:51 PM by ozkin

    SQL binding raised exceptions

    ozkin
    ozkin Mar 31, 2015 7:20 PM

      I have a composite reference with SQL binding. Is there a way to specify the exception(s) that could be raised by my method (in Java reference interface) in case of SQL/DB issues?

       

      As of now Java method has no exceptions declared. And if there is some run-time problem, like connectivity issue with the database server or wrong SQL statement, then this method just throws RuntimeException "java.lang.reflect.UndeclaredThrowableException"..

       

      Is there any way to better control exception handling for SQL binding or my only solution is to add try/catch for that particular RuntimeException and then analyze its cause?

      • 183 Views
      • Tags:
        • 1. Re: SQL binding raised exceptions
          ozkin
          ozkin Apr 1, 2015 5:51 PM (in response to ozkin)

          An observation. If you add "throws Exception" declaration to your method in Java reference interface, then instead of getting boring java.lang.reflect.UndeclaredThrowableException you can catch more meaningful exception (by catching Exception or RuntimeException) like below:

           

          org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/test

            • Actions