0 Replies Latest reply on Apr 4, 2010 5:32 AM by Sudhakar K

    sql trigger with custom exception

    Sudhakar K Newbie

      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.