Bump. Really hoping someone can help out here. These exceptions are filling my Tomcat logs badly. Lenny -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Scardino,Leonard R Jr ERDC-ITL-MS Contractor Sent: Wednesday, June 01, 2011 2:50 PM To: XWiki Users Subject: Re: [xwiki-users] How can I capture an exception that is goingtostandard out 1. Exact console logs: There are a bunch of these, but here is an example - "java.sql.SQLException: org.apache.commons.dbcp.PoolablePreparedStatement with address: "com.mysql.jdbc.JDBC4PreparedStatement@179c0a7: insert into xwikircs (XWR_DATE, XWR_COMMENT, XWR_AUTHOR, XWR_DOCID, XWR_VERSION1, XWR_VERSION2) values (** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **)" is closed. at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.jav a:137) at org.apache.commons.dbcp.DelegatingStatement.clearBatch(DelegatingStatement.ja va:294) at org.apache.commons.dbcp.PoolablePreparedStatement.clearBatch(PoolablePrepared Statement.java:86) at org.apache.commons.dbcp.PoolablePreparedStatement.passivate(PoolablePreparedS tatement.java:134) at org.apache.commons.dbcp.PoolingConnection.passivateObject(PoolingConnection.j ava:350) at org.apache.commons.pool.impl.GenericKeyedObjectPool.addObjectToPool(GenericKe yedObjectPool.java:1570) at org.apache.commons.pool.impl.GenericKeyedObjectPool.returnObject(GenericKeyed ObjectPool.java:1526) at org.apache.commons.dbcp.PoolablePreparedStatement.close(PoolablePreparedState ment.java:96) at org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:16 8) at org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:16 8) at org.hibernate.jdbc.AbstractBatcher.closePreparedStatement(AbstractBatcher.jav a:534) at org.hibernate.jdbc.AbstractBatcher.closeStatement(AbstractBatcher.java:269) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(Abstr actFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventLi stener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBase Store.java:853) at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBase Store.java:824) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java :643) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:181) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:175) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1451) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1398) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1393) at com.xpn.xwiki.plugin.scheduler.SchedulerPlugin.updateSchedulerJobClass(Schedu lerPlugin.java:680) at com.xpn.xwiki.plugin.scheduler.SchedulerPlugin.init(SchedulerPlugin.java:119) at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:15 3) at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:90) at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:11 8) at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:1173) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:842) at com.xpn.xwiki.XWiki.<init>(XWiki.java:771) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:486) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:137) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:117) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcess or.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:627) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationF ilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCha in.java:188) at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationF ilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCha in.java:188) at com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilte r.java:152) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationF ilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCha in.java:188) at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationF ilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCha in.java:188) at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFil ter(SavedRequestRestorerFilter.java:218) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationF ilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCha in.java:188) at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFil ter(SetCharacterEncodingFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationF ilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCha in.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.jav a:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.jav a:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java: 897) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java :689) at java.lang.Thread.run(Thread.java:662)" 2. log4j file from WEB-INF/classes : " ### Direct log messages to stdout log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.Target=System.out log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=%d [%t] %-5p %-30.30c{2} %x - %m %n log4j.appender.file=org.apache.log4j.RollingFileAppender log4j.appender.file.File=xwiki.log log4j.appender.file.MaxFileSize=10MB log4j.appender.file.MaxBackupIndex=50 log4j.appender.file.layout=org.apache.log4j.PatternLayout log4j.appender.file.layout.ConversionPattern=%d [%t] %-5p %-30.30c{2} %x - %m %n ### By default everything that is of warning or severity WARN, ERROR or FATAL is logged both to ### the console and to the xwiki.log file. #log4j.rootLogger=error, stdout, file log4j.rootLogger=error, file ### Hibernate logging options log4j.logger.org.hibernate=error log4j.logger.org.hibernate.SQL=error log4j.logger.org.hibernate.type=error log4j.logger.org.hibernate.ps.PreparedStatementCache=error ### DBCP and POOL logging options log4j.logger.org.apache.commons.dbcp=error log4j.logger.org.apache.commons.pool=error ### XWiki logging configuration log4j.logger.org.xwiki=error log4j.logger.com.xpn.xwiki=error log4j.logger.com.xpn.xwiki.render.XWikiRadeoxRenderEngine=error log4j.logger.com.xpn.xwiki.store.migration=error ### Deactive Struts warnings log4j.logger.org.apache.struts.util.RequestUtils=error ### Deactivate JGroups warnings log4j.logger.org.jgroups=error ## Deactive PDF Export CSS Applier warnings log4j.logger.info.informatica.doc.style.css.dom=error log4j.logger.org.apache.fop.layoutmgr.inline.ContentLayoutManager=error " 3. List of jars from WEB-INF/lib with *logging*, *log4j*, *slf4j*: commons-logging-1.1.1.jar commons-logging-api-1.0.4.jar doxia-logging-api-1.1.3.jar log4j-1.2.16.jar slf4j-api-1.5.8.jar slf4j-log4j12-1.5.8.jar 4. Mods from the standard XWiki WAR file: Custom XwikiAuthServiceImpl. This has my custom login code. Lenny -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Vincent Massol Sent: Friday, May 27, 2011 5:57 AM To: XWiki Users Subject: Re: [xwiki-users] How can I capture an exception that is going tostandard out Hi, These logs are not on by default normally. You'll need to show us: - the exact console logs you get - your log4J file in WEB-INF/classes - the list of jars from your WEB-INF/lib directory that matches the patterns: *logging*, *log4j*, *slf4j* - tell us what modifications you've brought from the standard XWiki WAR file Thanks -Vincent On May 26, 2011, at 10:22 PM, Scardino, Leonard R Jr ERDC-ITL-MS Contractor wrote:
Ok, I have an exception "java.sql.SQLException: org.apache.commons.dbcp.PoolablePreparedStatement..." that is making it to Tomcat's standard out log (tomcat5-stdout.2011-05-26.log). I've tried everything I can think of in the log4j.properties file to get this exception to either not show up at all or log to a different file. This exception does not have any formatting like is specified in the log4j.properties file. So I don't think it's being logged, so much as just finally falling through and going to stdout.
I've spent all dang day trying to find a way to keep this exception from filling my logs, or to figure out why the darn thing is happening in the first place. I've put in a ticket for the exception, but it still hasn't even been picked up yet. I've emailed this list, but no one was able to help.
So I just want to log this exception somewhere else so it doesn't complicate my main log file. Can someone explain how to do this? I fancy myself a good programmer, but of all things this is stumping me.
Thanks,
Lenny
users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users