OK, so you only want to hide hibernate from the stack trace. Then modify your
pattern for the PatternLayout to include %xEx{full,filters[org.hibernate]}
Ralph
> On Jun 29, 2015, at 9:19 AM, Emi Lu <em...@encs.concordia.ca> wrote:
>
> Mailing list bounced my email.
>
> -------- Forwarded Message --------
> Subject: Re: Hide *.jar
> Date: Mon, 29 Jun 2015 12:16:34 -0400
> From: Emi Lu <em...@encs.concordia.ca> <mailto:em...@encs.concordia.ca>
> Reply-To: em...@encs.concordia.ca <mailto:em...@encs.concordia.ca>
> To: log4j-user@logging.apache.org <mailto:log4j-user@logging.apache.org>
>
> On 06/29/2015 12:04 PM, Ralph Goers wrote:
>> Can you post the full output of the log event?
>>
> Here it is.
>
> Red lines are the ones I want to hide.
>
> 2015-Jun-29 12:10:39.214 [http-8080-5] ERROR DBUtilUser - set gui_model
> Error: could not extract ResultSet SELECT ****** ORDER BY 1, 2, 3
> 2015-Jun-29 12:10:39.215 [http-8080-5] ERROR DBUtilUser -
> org.hibernate.exception.SQLGrammarException: could not extract ResultSet
> 2015-Jun-29 12:10:39.217 [http-8080-5] ERROR
> org.apache.struts2.dispatcher.DefaultDispatcherErrorHandler - Exception
> occurred during processing request: could not extract ResultSet
>
>
> org.hibernate.exception.SQLGrammarException: could not extract ResultSet
> at
> org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at
> org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at
> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at
> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at
> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at org.hibernate.loader.Loader.doQuery(Loader.java:910)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at org.hibernate.loader.Loader.doList(Loader.java:2554)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at org.hibernate.loader.Loader.doList(Loader.java:2540)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at org.hibernate.loader.Loader.list(Loader.java:2365)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:353)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at
> org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1873)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at
> org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:311)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:141)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> at DBUtilUser.set_gui_model_based_on_people_id(Unknown Source)
> ~[DBUtilUser.class:?]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[?:1.7.0_80]
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> ~[?:1.7.0_80]
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[?:1.7.0_80]
> at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_80]
> at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:872)
> ~[ognl-3.0.11.jar:?]
> at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1295)
> ~[ognl-3.0.11.jar:?]
> at ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68)
> ~[ognl-3.0.11.jar:?]
> at
> com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:117)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:108)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:1371) ~[ognl-3.0.11.jar:?]
> at ognl.ASTMethod.getValueBody(ASTMethod.java:90) ~[ognl-3.0.11.jar:?]
> at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
> ~[ognl-3.0.11.jar:?]
> at ognl.SimpleNode.getValue(SimpleNode.java:258) ~[ognl-3.0.11.jar:?]
> at ognl.Ognl.getValue(Ognl.java:494) ~[ognl-3.0.11.jar:?]
> at ognl.Ognl.getValue(Ognl.java:458) ~[ognl-3.0.11.jar:?]
> at com.opensymphony.xwork2.ognl.OgnlUtil$2.execute(OgnlUtil.java:309)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.ognl.OgnlUtil.compileAndExecute(OgnlUtil.java:340)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at com.opensymphony.xwork2.ognl.OgnlUtil.getValue(OgnlUtil.java:307)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:423)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:287)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:250)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> org.apache.struts2.interceptor.DeprecationInterceptor.intercept(DeprecationInterceptor.java:41)
> ~[struts2-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
> ~[struts2-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:76)
> ~[struts2-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:229)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:229)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73)
> ~[struts2-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> org.apache.struts2.interceptor.DateTextFieldInterceptor.intercept(DateTextFieldInterceptor.java:125)
> ~[struts2-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91)
> ~[struts2-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:253)
> ~[struts2-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:139)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
> ~[struts2-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:244)
> ~[xwork-core-2.3.24.jar:2.3.24]
> at
> org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
> ~[struts2-core-2.3.24.jar:2.3.24]
> at
> org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:564)
> [struts2-core-2.3.24.jar:2.3.24]
> at
> org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:81)
> [struts2-core-2.3.24.jar:2.3.24]
> at
> org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)
> [struts2-core-2.3.24.jar:2.3.24]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> [catalina.jar:6.0.41]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> [catalina.jar:6.0.41]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> [catalina.jar:6.0.41]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> [catalina.jar:6.0.41]
> at
> org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
> [displaytag-1.2.jar:?]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> [catalina.jar:6.0.41]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> [catalina.jar:6.0.41]
> at
> org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
> [displaytag-1.2.jar:?]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> [catalina.jar:6.0.41]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> [catalina.jar:6.0.41]
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> [catalina.jar:6.0.41]
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> [catalina.jar:6.0.41]
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> [catalina.jar:6.0.41]
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
> [catalina.jar:6.0.41]
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> [catalina.jar:6.0.41]
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
> [catalina.jar:6.0.41]
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
> [tomcat-coyote.jar:6.0.41]
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
> [tomcat-coyote.jar:6.0.41]
> at
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
> [tomcat-coyote.jar:6.0.41]
> at java.lang.Thread.run(Thread.java:745) [?:1.7.0_80]
> Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near
> "map3"
> Position: 35
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
> ~[postgresql-9.4-1201.jdbc4.jar:9.4]
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
> ~[postgresql-9.4-1201.jdbc4.jar:9.4]
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> ~[postgresql-9.4-1201.jdbc4.jar:9.4]
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
> ~[postgresql-9.4-1201.jdbc4.jar:9.4]
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
> ~[postgresql-9.4-1201.jdbc4.jar:9.4]
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:305)
> ~[postgresql-9.4-1201.jdbc4.jar:9.4]
> at
> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
> ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
> ... 107 more
>
