in my new project we are using a trigger for certain business requirement. The trigger returns custom exception which we need to capture and do some business logic. The trigger is called on insert. But whenever I handle GenericJDBCException and the cause of the exception that is BatchUpdateException and get the sql error code a roleback happens as my transaction is handled by the container. How do I get the sql error thrown by the insert trigger and yet not let the faces page exhibit the error?
Also this is a seam component called from the jpdl and calls a diifferent database than the rest of the functionality using xa connection.
thanks