Error while indexing a post: java.sql.SQLException: The statement is closed.

[Migrated From Jforum.net]

Hi
Latest Jforum deployed on Jboss 5.05 and on mysql server as the DB. Some meesages do no get indexed properly. Please see the stack trace:

war/WEB-INF/config/jforum-custom.conf
10:58:04,514 INFO [STDOUT] 10:58:04,513 INFO [FileMonitor] Watching /home/shlomo/Install/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp11054jforum-exp.war/WEB-INF/config/jforum-custom.conf
10:58:04,515 INFO [STDOUT] 10:58:04,515 INFO [FileMonitor ] Watching /home/shlomo/Install/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp11054jforum-exp.war/WEB-INF/config/jforum-custom.conf
10:58:04,515 INFO [STDOUT] 10:58:04,515 INFO [FileMonitor] Watching /home/shlomo/Install/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp11054jforum-exp.war/WEB-INF/config/jforum-custom.conf
10:58:05,007 INFO [STDOUT] 10:58:05,007 INFO [InstallAction ] Database configuration ok
10:58:05,008 INFO [STDOUT] 10:58:05,007 INFO [InstallAction] Database configuration ok
10:58:05,008 INFO [STDOUT] 10:58:05,008 INFO [InstallAction ] Going to create tables...
10:58:05,008 INFO [STDOUT] 10:58:05,008 INFO [InstallAction] Going to create tables...
10:58:05,691 INFO [STDOUT] 10:58:05,691 INFO [InstallAction ] Table creation is ok
10:58:05,691 INFO [STDOUT] 10:58:05,691 INFO [InstallAction] Table creation is ok
10:58:05,726 INFO [STDOUT] 10:58:05,726 INFO [InstallAction ] Going to update the administrator's password
10:58:05,727 INFO [STDOUT] 10:58:05,726 INFO [InstallAction] Going to update the administrator's password
10:58:05,877 INFO [STDOUT] 10:58:05,876 INFO [FileMonitor ] Watching /home/shlomo/Install/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp11054jforum-exp.war/WEB-INF/config/jforum-custom.conf
10:58:05,877 INFO [STDOUT] 10:58:05,876 INFO [FileMonitor] Watching /home/shlomo/Install/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp11054jforum-exp.war/WEB-INF/config/jforum-custom.conf
10:58:05,879 INFO [STDOUT] 10:58:05,879 INFO [SessionFacade ] Removing session EB53DC2686E7FB905DEC9767EE27A481
10:58:05,880 INFO [STDOUT] 10:58:05,879 INFO [SessionFacade] Removing session EB53DC2686E7FB905DEC9767EE27A481
10:58:29,284 INFO [STDOUT] 10:58:29,284 INFO [JForumBaseServlet ] Starting JForum. Debug mode is true
10:58:29,285 INFO [STDOUT] 10:58:29,284 INFO [JForumBaseServlet] Starting JForum. Debug mode is true
10:58:29,286 INFO [STDOUT] 10:58:29,286 INFO [ConfigLoader ] Using cache engine: net.jforum.cache.DefaultCacheEngine
10:58:29,286 INFO [STDOUT] 10:58:29,286 INFO [ConfigLoader] Using cache engine: net.jforum.cache.DefaultCacheEngine
10:58:29,286 INFO [STDOUT] 10:58:29,286 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.BBCodeRepository
10:58:29,286 INFO [STDOUT] 10:58:29,286 INFO [ConfigLoader] Creating an instance of net.jforum.repository.BBCodeRepository
10:58:29,287 INFO [STDOUT] 10:58:29,287 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.RankingRepository
10:58:29,287 INFO [STDOUT] 10:58:29,287 INFO [ConfigLoader] Creating an instance of net.jforum.repository.RankingRepository
10:58:29,287 INFO [STDOUT] 10:58:29,287 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.SmiliesRepository
10:58:29,287 INFO [STDOUT] 10:58:29,287 INFO [ConfigLoader] Creating an instance of net.jforum.repository.SmiliesRepository
10:58:29,287 INFO [STDOUT] 10:58:29,287 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.ForumRepository
10:58:29,287 INFO [STDOUT] 10:58:29,287 INFO [ConfigLoader] Creating an instance of net.jforum.repository.ForumRepository
10:58:29,287 INFO [STDOUT] 10:58:29,287 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.TopicRepository
10:58:29,287 INFO [STDOUT] 10:58:29,287 INFO [ConfigLoader] Creating an instance of net.jforum.repository.TopicRepository
10:58:29,288 INFO [STDOUT] 10:58:29,287 INFO [ConfigLoader ] Creating an instance of net.jforum.SessionFacade
10:58:29,288 INFO [STDOUT] 10:58:29,287 INFO [ConfigLoader] Creating an instance of net.jforum.SessionFacade
10:58:29,288 INFO [STDOUT] 10:58:29,288 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.PostRepository
10:58:29,288 INFO [STDOUT] 10:58:29,288 INFO [ConfigLoader] Creating an instance of net.jforum.repository.PostRepository
10:58:29,288 INFO [STDOUT] 10:58:29,288 INFO [ConfigLoader ] Creating an instance of net.jforum.util.search.quartz.QuartzSearchIndexerJob
10:58:29,288 INFO [STDOUT] 10:58:29,288 INFO [ConfigLoader] Creating an instance of net.jforum.util.search.quartz.QuartzSearchIndexerJob
10:58:29,288 INFO [STDOUT] 10:58:29,288 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.Tpl
10:58:29,288 INFO [STDOUT] 10:58:29,288 INFO [ConfigLoader] Creating an instance of net.jforum.repository.Tpl
10:58:29,288 INFO [STDOUT] 10:58:29,288 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.RolesRepository
10:58:29,289 INFO [STDOUT] 10:58:29,288 INFO [ConfigLoader] Creating an instance of net.jforum.repository.RolesRepository
10:58:29,289 INFO [STDOUT] 10:58:29,289 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.SecurityRepository
10:58:29,289 INFO [STDOUT] 10:58:29,289 INFO [ConfigLoader] Creating an instance of net.jforum.repository.SecurityRepository
10:58:29,296 INFO [STDOUT] 10:58:29,296 INFO [ConfigLoader ] Loading JDBC driver net.jforum.dao.mysql.MysqlDataAccessDriver
10:58:29,296 INFO [STDOUT] 10:58:29,296 INFO [ConfigLoader] Loading JDBC driver net.jforum.dao.mysql.MysqlDataAccessDriver
10:58:29,369 INFO [STDOUT] 10:58:29,369 INFO [FileMonitor ] Watching /home/shlomo/Install/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp11054jforum-exp.war/WEB-INF/config/database/generic/generic_queries.sql
10:58:29,370 INFO [STDOUT] 10:58:29,369 INFO [FileMonitor] Watching /home/shlomo/Install/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp11054jforum-exp.war/WEB-INF/config/database/generic/generic_queries.sql
10:58:29,370 INFO [STDOUT] 10:58:29,370 INFO [FileMonitor ] Watching /home/shlomo/Install/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp11054jforum-exp.war/WEB-INF/config/database/mysql/mysql.sql
10:58:29,370 INFO [STDOUT] 10:58:29,370 INFO [FileMonitor] Watching /home/shlomo/Install/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp11054jforum-exp.war/WEB-INF/config/database/mysql/mysql.sql
10:58:29,370 INFO [STDOUT] 10:58:29,370 INFO [FileMonitor ] Watching /home/shlomo/Install/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp11054jforum-exp.war/WEB-INF/config/SystemGlobals.properties
10:58:29,371 INFO [STDOUT] 10:58:29,370 INFO [FileMonitor] Watching /home/shlomo/Install/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp11054jforum-exp.war/WEB-INF/config/SystemGlobals.properties
10:58:29,371 INFO [STDOUT] 10:58:29,371 INFO [FileMonitor ] Watching /home/shlomo/Install/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp11054jforum-exp.war/WEB-INF/config/jforum-custom.conf
10:58:29,371 INFO [STDOUT] 10:58:29,371 INFO [FileMonitor] Watching /home/shlomo/Install/jboss-4.0.5.GA/server/default/./tmp/deploy/tmp11054jforum-exp.war/WEB-INF/config/jforum-custom.conf
11:05:53,217 INFO [STDOUT] 11:05:53,216 INFO [SessionFacade ] Removing session EB53DC2686E7FB905DEC9767EE27A481
11:05:53,217 INFO [STDOUT] 11:05:53,216 INFO [SessionFacade] Removing session EB53DC2686E7FB905DEC9767EE27A481
11:07:51,206 INFO [STDOUT] 11:07:51,206 INFO [Logger] Logging using commons-logging.
11:07:51,285 INFO [STDOUT] 11:07:51,284 INFO [DWRServlet] retrieved system configuration file: java.io.ByteArrayInputStream@1d44ae9
11:07:51,315 INFO [STDOUT] 11:07:51,314 INFO [DefaultConfiguration] Missing class for creator 'pageflow'. Failed to load uk.ltd.getahead.dwr.create.PageFlowCreator. Cause: Beehive/Weblogic Creator not available.
11:07:51,317 INFO [STDOUT] 11:07:51,317 INFO [DefaultConfiguration] Missing classdef for creator 'spring'. Failed to load uk.ltd.getahead.dwr.create.SpringCreator. Cause: org/springframework/beans/factory/BeanFactory
11:07:51,349 INFO [STDOUT] 11:07:51,349 INFO [DefaultConfiguration] Missing classdef for converter 'jdom'. Failed to load uk.ltd.getahead.dwr.convert.JDOMConverter. Cause: org/jdom/Document
11:07:51,511 INFO [STDOUT] 11:07:51,511 INFO [HibernateBeanConverter] Found Hibernate3 class: org.hibernate.Hibernate
11:07:51,522 INFO [STDOUT] 11:07:51,522 INFO [DefaultConverterManager] Can't marshall org.jdom.Document because converter 'jdom' is not available. The converter definition may be missing, or required element may be missing from the CLASSPATH
11:07:51,523 INFO [STDOUT] 11:07:51,523 INFO [DefaultConverterManager] Can't marshall org.jdom.Element because converter 'jdom' is not available. The converter definition may be missing, or required element may be missing from the CLASSPATH
11:07:51,532 INFO [STDOUT] 11:07:51,532 ERROR [LogErrorHandler] Line=2 Document root element "dwr", must match DOCTYPE root "null".
11:07:51,532 INFO [STDOUT] 11:07:51,532 ERROR [LogErrorHandler] Line=2 Document is invalid: no grammar found.
11:07:51,533 INFO [STDOUT] 11:07:51,533 ERROR [DefaultConfiguration] The 'session' and 'static' creators are deprecated. Use the 'new' creator
11:07:51,533 INFO [STDOUT] 11:07:51,533 ERROR [DefaultConfiguration] For more information see the DWR website
11:11:13,356 INFO [STDOUT] 11:11:13,356 INFO [SessionFacade ] Removing session EB53DC2686E7FB905DEC9767EE27A481
11:11:13,357 INFO [STDOUT] 11:11:13,356 INFO [SessionFacade] Removing session EB53DC2686E7FB905DEC9767EE27A481
11:11:23,227 INFO [STDOUT] 11:11:23,227 INFO [SessionFacade ] Removing session EB53DC2686E7FB905DEC9767EE27A481
11:11:23,227 INFO [STDOUT] 11:11:23,227 INFO [SessionFacade] Removing session EB53DC2686E7FB905DEC9767EE27A481
11:11:50,743 INFO [STDOUT] 11:11:50,743 INFO [SessionFacade ] Removing session EB53DC2686E7FB905DEC9767EE27A481
11:11:50,744 INFO [STDOUT] 11:11:50,743 INFO [SessionFacade] Removing session EB53DC2686E7FB905DEC9767EE27A481
11:13:06,947 INFO [STDOUT] 11:13:06,947 INFO [QueuedExecutor ] Setting queue...
11:13:06,947 INFO [STDOUT] 11:13:06,947 INFO [QueuedExecutor] Setting queue...
11:13:06,993 INFO [STDOUT] 11:13:06,993 INFO [QueuedExecutor ] Creating a new thread...
11:13:06,993 INFO [STDOUT] 11:13:06,993 INFO [QueuedExecutor] Creating a new thread...
11:13:07,035 INFO [CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@1e07f4b
java.lang.Throwable: STACKTRACE
at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:290)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:417)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
at net.jforum.DataSourceConnection.getConnection(DataSourceConnection.java:84)
at net.jforum.util.search.simple.MessageIndexerTask.<init>(MessageIndexerTask.java:68)
at net.jforum.util.search.simple.SimpleSearchManager.index(SimpleSearchManager.java:77)
at net.jforum.util.search.SearchFacade.index(SearchFacade.java:89)
at net.jforum.dao.generic.GenericPostDAO.addNew(GenericPostDAO.java:238)
at net.jforum.view.forum.PostAction.insertSave(PostAction.java:1086)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at net.jforum.Command.process(Command.java:116)
at net.jforum.JForum.service(JForum.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
11:13:07,074 INFO [STDOUT] 11:13:07,074 WARN [MessageIndexerTask ] Error while indexing a post: java.sql.SQLException: The statement is closed.
11:13:07,075 INFO [STDOUT] 11:13:07,074 WARN [MessageIndexerTask] Error while indexing a post: java.sql.SQLException: The statement is closed.
11:13:07,075 ERROR [STDERR] java.sql.SQLException: The statement is closed.
11:13:07,075 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedStatement.checkState(WrappedStatement.java:599)
11:13:07,076 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setString(WrappedPreparedStatement.java:313)
11:13:07,076 ERROR [STDERR] at net.jforum.dao.generic.GenericSearchIndexerDAO.insertSearchWords(GenericSearchIndexerDAO.java:160)
11:13:07,076 ERROR [STDERR] at net.jforum.dao.generic.GenericSearchIndexerDAO.insertSearchWords(GenericSearchIndexerDAO.java:187)
11:13:07,076 ERROR [STDERR] at net.jforum.util.search.simple.MessageIndexerTask.execute(MessageIndexerTask.java:79)
11:13:07,076 ERROR [STDERR] at net.jforum.util.concurrent.executor.AbstractWorker.run(AbstractWorker.java:74)
11:13:07,077 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)
11:13:16,793 INFO [STDOUT] 11:13:16,793 INFO [SessionFacade ] Removing session EB53DC2686E7FB905DEC9767EE27A481
11:13:16,793 INFO [STDOUT] 11:13:16,793 INFO [SessionFacade] Removing session EB53DC2686E7FB905DEC9767EE27A481
11:13:26,217 INFO [STDOUT] 11:13:26,216 INFO [SessionFacade ] Removing session EB53DC2686E7FB905DEC9767EE27A481
11:13:26,217 INFO [STDOUT] 11:13:26,216 INFO [SessionFacade] Removing session EB53DC2686E7FB905DEC9767EE27A481
11:13:44,110 INFO [STDOUT] 11:13:44,109 WARN [Spammer ] javax.mail.internet.AddressException: Illegal address in string ''
11:13:44,110 INFO [STDOUT] 11:13:44,109 WARN [Spammer] javax.mail.internet.AddressException: Illegal address in string ''
11:13:44,111 INFO [STDOUT] 11:13:44,111 WARN [TopicsCommon ] Error while sending notification emails: net.jforum.util.mail.EmailException: javax.mail.internet.AddressException: Illegal address in string ''
11:13:44,111 INFO [STDOUT] 11:13:44,111 WARN [TopicsCommon] Error while sending notification emails: net.jforum.util.mail.EmailException: javax.mail.internet.AddressException: Illegal address in string ''
11:13:44,121 INFO [CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@12bed82
11:25:41,689 INFO [STDOUT] 11:25:41,689 INFO [SessionFacade ] Removing session 33C5C345B9FF3FF5B9631908378F3FC7
11:25:41,689 INFO [STDOUT] 11:25:41,689 INFO [SessionFacade] Removing session 33C5C345B9FF3FF5B9631908378F3FC7
11:33:43,571 INFO [STDOUT] 11:33:43,571 INFO [SessionFacade ] Removing session EB53DC2686E7FB905DEC9767EE27A481
11:33:43,571 INFO [STDOUT] 11:33:43,571 INFO [SessionFacade] Removing session EB53DC2686E7FB905DEC9767EE27A481
11:33:53,103 INFO [STDOUT] 11:33:53,103 INFO [SessionFacade ] Removing session EB53DC2686E7FB905DEC9767EE27A481
11:33:53,103 INFO [STDOUT] 11:33:53,103 INFO [SessionFacade] Removing session EB53DC2686E7FB905DEC9767EE27A481
11:39:44,145 INFO [STDOUT] 11:39:44,145 WARN [MessageIndexerTask ] Error while indexing a post: java.lang.StringIndexOutOfBoundsException: String index out of range: -1
11:39:44,146 INFO [STDOUT] 11:39:44,145 WARN [MessageIndexerTask] Error while indexing a post: java.lang.StringIndexOutOfBoundsException: String index out of range: -1
11:39:44,146 ERROR [STDERR] java.lang.StringIndexOutOfBoundsException: String index out of range: -1
11:39:44,146 ERROR [STDERR] at java.lang.AbstractStringBuilder.substring(AbstractStringBuilder.java:886)
11:39:44,146 ERROR [STDERR] at java.lang.StringBuffer.substring(StringBuffer.java:417)
11:39:44,146 ERROR [STDERR] at net.jforum.dao.generic.GenericSearchIndexerDAO.insertSearchWords(GenericSearchIndexerDAO.java:137)
11:39:44,146 ERROR [STDERR] at net.jforum.dao.generic.GenericSearchIndexerDAO.insertSearchWords(GenericSearchIndexerDAO.java:187)
11:39:44,146 ERROR [STDERR] at net.jforum.util.search.simple.MessageIndexerTask.execute(MessageIndexerTask.java:79)
11:39:44,146 ERROR [STDERR] at net.jforum.util.concurrent.executor.AbstractWorker.run(AbstractWorker.java:74)
11:39:44,146 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)
11:39:44,154 INFO [CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@aaa392
11:43:26,090 INFO [STDOUT] 11:43:26,090 INFO [ExecuteQuery] Exec[0]: AjaxUtils.previewPost()
11:43:28,965 INFO [CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@16e3762
11:45:42,255 INFO [STDOUT] 11:45:42,255 INFO [SessionFacade ] Removing session 33C5C345B9FF3FF5B9631908378F3FC7
11:45:42,255 INFO [STDOUT] 11:45:42,255 INFO [SessionFacade] Removing session 33C5C345B9FF3FF5B9631908378F3FC7
11:48:57,829 INFO [CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@129efd0
java.lang.Throwable: STACKTRACE
at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:290)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:417)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
at net.jforum.DataSourceConnection.getConnection(DataSourceConnection.java:84)
at net.jforum.util.search.simple.MessageIndexerTask.<init>(MessageIndexerTask.java:68)
at net.jforum.util.search.simple.SimpleSearchManager.index(SimpleSearchManager.java:77)
at net.jforum.util.search.SearchFacade.index(SearchFacade.java:89)
at net.jforum.dao.generic.GenericPostDAO.addNew(GenericPostDAO.java:238)
at net.jforum.view.forum.PostAction.insertSave(PostAction.java:1086)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at net.jforum.Command.process(Command.java:116)
at net.jforum.JForum.service(JForum.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
11:48:57,834 INFO [STDOUT] 11:48:57,833 WARN [MessageIndexerTask ] Error while indexing a post: java.sql.SQLException: Connection handle has been closed and is unusable
11:48:57,834 INFO [STDOUT] 11:48:57,833 WARN [MessageIndexerTask] Error while indexing a post: java.sql.SQLException: Connection handle has been closed and is unusable
11:48:57,834 ERROR [STDERR] java.sql.SQLException: Connection handle has been closed and is unusable
11:48:57,834 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:537)
11:48:57,834 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:524)
11:48:57,834 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.createStatement(WrappedConnection.java:142)
11:48:57,834 ERROR [STDERR] at net.jforum.dao.generic.GenericSearchIndexerDAO.insertSearchWords(GenericSearchIndexerDAO.java:174)
11:48:57,834 ERROR [STDERR] at net.jforum.dao.generic.GenericSearchIndexerDAO.insertSearchWords(GenericSearchIndexerDAO.java:187)
11:48:57,834 ERROR [STDERR] at net.jforum.util.search.simple.MessageIndexerTask.execute(MessageIndexerTask.java:79)
11:48:57,834 ERROR [STDERR] at net.jforum.util.concurrent.executor.AbstractWorker.run(AbstractWorker.java:74)
11:48:57,834 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)
11:49:42,366 INFO [STDOUT] 11:49:42,366 INFO [SessionFacade ] Removing session 90A4C5ED84CC798958883631D57B3625
11:49:42,366 INFO [STDOUT] 11:49:42,366 INFO [SessionFacade] Removing session 90A4C5ED84CC798958883631D57B3625
11:50:51,413 INFO [CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@dad6d0
java.lang.Throwable: STACKTRACE
at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:290)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:417)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
at net.jforum.DataSourceConnection.getConnection(DataSourceConnection.java:84)
at net.jforum.util.search.simple.MessageIndexerTask.<init>(MessageIndexerTask.java:68)
at net.jforum.util.search.simple.SimpleSearchManager.index(SimpleSearchManager.java:77)
at net.jforum.util.search.SearchFacade.index(SearchFacade.java:89)
at net.jforum.dao.generic.GenericPostDAO.addNew(GenericPostDAO.java:238)
at net.jforum.view.forum.PostAction.insertSave(PostAction.java:1086)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at net.jforum.Command.process(Command.java:116)
at net.jforum.JForum.service(JForum.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
11:50:51,418 INFO [STDOUT] 11:50:51,418 WARN [MessageIndexerTask ] Error while indexing a post: java.sql.SQLException: Connection handle has been closed and is unusable
11:50:51,418 INFO [STDOUT] 11:50:51,418 WARN [MessageIndexerTask] Error while indexing a post: java.sql.SQLException: Connection handle has been closed and is unusable
11:50:51,418 ERROR [STDERR] java.sql.SQLException: Connection handle has been closed and is unusable
11:50:51,418 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:537)
11:50:51,419 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:524)
11:50:51,419 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.createStatement(WrappedConnection.java:142)
11:50:51,419 ERROR [STDERR] at net.jforum.dao.generic.GenericSearchIndexerDAO.insertSearchWords(GenericSearchIndexerDAO.java:142)
11:50:51,419 ERROR [STDERR] at net.jforum.dao.generic.GenericSearchIndexerDAO.insertSearchWords(GenericSearchIndexerDAO.java:187)
11:50:51,419 ERROR [STDERR] at net.jforum.util.search.simple.MessageIndexerTask.execute(MessageIndexerTask.java:79)
11:50:51,419 ERROR [STDERR] at net.jforum.util.concurrent.executor.AbstractWorker.run(AbstractWorker.java:74)
11:50:51,419 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)
11:53:42,506 INFO [STDOUT] 11:53:42,505 INFO [SessionFacade ] Removing session C9F5D056BEAF59C42ECC6371A1053E7B
11:53:42,506 INFO [STDOUT] 11:53:42,505 INFO [SessionFacade] Removing session C9F5D056BEAF59C42ECC6371A1053E7B
11:53:48,114 INFO [CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@19f9088
java.lang.Throwable: STACKTRACE
at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:290)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:417)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
at net.jforum.DataSourceConnection.getConnection(DataSourceConnection.java:84)
at net.jforum.util.search.simple.MessageIndexerTask.<init>(MessageIndexerTask.java:68)
at net.jforum.util.search.simple.SimpleSearchManager.index(SimpleSearchManager.java:77)
at net.jforum.util.search.SearchFacade.index(SearchFacade.java:89)
at net.jforum.dao.generic.GenericPostDAO.update(GenericPostDAO.java:198)
at net.jforum.view.forum.PostAction.editSave(PostAction.java:766)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at net.jforum.Command.process(Command.java:116)
at net.jforum.JForum.service(JForum.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
11:53:48,119 INFO [STDOUT] 11:53:48,119 WARN [MessageIndexerTask ] Error while indexing a post: java.sql.SQLException: The statement is closed.
11:53:48,119 INFO [STDOUT] 11:53:48,119 WARN [MessageIndexerTask] Error while indexing a post: java.sql.SQLException: The statement is closed.
11:53:48,119 ERROR [STDERR] java.sql.SQLException: The statement is closed.
11:53:48,119 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedStatement.checkState(WrappedStatement.java:599)
11:53:48,119 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setString(WrappedPreparedStatement.java:313)
11:53:48,119 ERROR [STDERR] at net.jforum.dao.generic.GenericSearchIndexerDAO.insertSearchWords(GenericSearchIndexerDAO.java:160)
11:53:48,119 ERROR [STDERR] at net.jforum.dao.generic.GenericSearchIndexerDAO.insertSearchWords(GenericSearchIndexerDAO.java:187)
11:53:48,119 ERROR [STDERR] at net.jforum.util.search.simple.MessageIndexerTask.execute(MessageIndexerTask.java:79)
11:53:48,119 ERROR [STDERR] at net.jforum.util.concurrent.executor.AbstractWorker.run(AbstractWorker.java:74)
11:53:48,120 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)
12:02:44,371 INFO [CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@663731
12:18:38,816 INFO [CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@113eb9c

[originally posted on jforum.net by shlomo]

[Migrated From Jforum.net]

In this trace i see 2 types of errors:
1- "Closing a connection for you. Please close them yourself"
2- "Statement closed" or "Connection handle has been closed and is unusable"

The first may be a common coding error, somewhere in your code a jdbc connection is opened, used, but never closed. After a delay (or when the app exists from the connection object scope, i'm not sure) the pooled connection is released and you get "Closing a connection for you. Please close them yourself".
Than the exceptions of type 2 show up.

BUT, sometimes this problem is related to pool issues, this may be related to jforum code (not closing correctly the connections) or not.
I can only suggest to check the jboss datasource configuration if you are using that type of db connection...
[originally posted on jforum.net by Jules]

[Migrated From Jforum.net]

shlomo wrote:I have no JDBC code in my application so all the exeptions thrown are from Jforum itslef. The errors are consistent and it seems to me as a critical bug.

The "Connection handle has been closed and is unusable" jboss error is always connected to premature connection release (sometimes caused by multiple access to the same static connection object).
Similar situations:
http://www.jboss.com/index.html?module=bb&op=viewtopic&t=42481
http://forum.java.sun.com/thread.jspa?threadID=782570
Once i've experienced myself a similar issue caused by a bad facade ejb dao implementation.
This issue can be code related or jboss configuration related.
From my jforum 2.1.6 deployed on jboss 4.0.3SP1 i don't get this error, different version issues or different configuration? (i use an oracle datasource)
I can't exclude that this issue is related to bad connection configuration, can you post your configuration?
If code related (i can't exclude this either) the possible cause of that error is probably something located in the c3po pooling layer,after a brief look to the dao code of jforum the issue seems to be related to JForumExecutionContext.java's getConnection that get a c3po pooled connection and save it as a private attribute (is this same instance returned to more than one execution thread?).
The content of net.jforum.dao.* and net.jforum.dao.generic.* don't seem to be involved in the issue , since those classes don't create/close/manage jdbc connection.
Some ideas from jforum team?
[originally posted on jforum.net by Jules]

[Migrated From Jforum.net]

Hi,
Thanks for your reply. I have no JDBC code in my application so all the exeptions thrown are from Jforum itslef. The errors are consistent and it seems to my as a critical bug.

Shlomo.
[originally posted on jforum.net by shlomo]

[Migrated From Jforum.net]

This error seems to appear with the JDBC pool option and the DS option. It has nothing to do with the code written by the user (me). In bothe cases (pool or DS) the Jforum code neglegts to close teh connection or closes the connection before the statement has been closed.

Shlomo.
[originally posted on jforum.net by shlomo]

[Migrated From Jforum.net]

Hi,
I am facing a similar problem in websphere 6.

2006-12-27 19:25:07,150 WARN [MessageIndexerTask] - Error while indexing a post: com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.

please help, bcos of this any edited post text in not getting indexed and hence search is not working
[originally posted on jforum.net by rags]