Skip to Content
Former Member
Oct 06, 2009 at 01:12 PM

Capture errors from within a Transaction.



I'm trying to 'bubble' an error to a calling application. I have an SQL Query action block that fails and I'd like to report the error message to the calling application.

The Action block 'success' property is set false but I see no 'Error Message' property that I can use to report the error description to a calling application. (In this case the jdbc SQL Exception).

That error code is exposed in the Transaction Execution trace (see below). How can I have access to that value from within a transaction?

[WARN ]: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The EXECUTE permission was denied on the object 'LBL_PRODUCTION_DECLARATION_INSERT', database 'MII_LocalStorage', schema 'dbo'.

Thanks in advance.