Hi
i'm currently using following regex to match different types of exception.
(?i:[^.]+.)*(?P [a-zA-Z]+Exception)
sample log
06 Sep 2013 18:59:59,924 [WebContainer : 4] ERROR - Remote Exception while updating CSA Details
java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
java.rmi.RemoteException: ; nested exception is:
org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallb
``ack; uncategorized SQLException for SQL [{call
PX_CO_AC_AGREEMENT_MASTER_PG.spt_update(?, ?, ?, ?, ?, ?)}]; SQL state [72000]; error code
[20002]; ORA-20002: Record has been modified since last retrieved - Resubmit transaction for
parameter(s) p_acag_agreement_id_in values of which are => 1463755
ORA-06512: at "ACCOUNT_OWNER.PX_CO_AC_AGREEMENT_MASTER_PG", line 91
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1
; nested exception is java.sql.SQLException: ORA-20002: Record has been modified since last
retrieved - Resubmit transaction for parameter(s) p_acag_agreement_id_in values of which are
=> 1463755
ORA-06512: at "ACCOUNT_OWNER.PX_CO_AC_AGREEMENT_MASTER_PG", line 91
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1
the regex is matching SQLException(Bold) but i need match UncategorizedSQLException(Bold) once from the above log entry.
i tried like even like this (?i:[^.]+.)*(?P[a-zA-Z]+Exception|UncategorizedSQLException)but it was not successfull.
Any help on this.
... View more