Click to See Complete Forum and Search --> : Exception in Java Triggers/Stored Procedures


jonatan
03-20-2003, 02:15 PM
Is there someway that I can catch the exception thrown in a Java Trigger from a Java code calling JDBC? I will explain:

I have a table with a trigger in Java (calling a Stored Procedure). This trigger, in some circunstancies, throws an exception (like MyException). When I try to modify the data in the table using JDBC, I get an SQLException saying that an unexpected exception occurred in the trigger. But I want to get the original exception, that has some informations that I may use, like specific properties or methods. Is there someway that I can get this exception?

Thanks,