java.sql.SQLException: org.apache.commons.dbcp.PoolablePreparedStatement with address: "com.mysql.jdbc.PreparedStatement@12407f7: update xwikiproperties set XWP_CLASSTYPE=** NOT SPECIFIED ** where XWP_ID=** NOT SPECIFIED ** and XWP_NAME=** NOT SPECIFIED **" is closed.

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Update (May 26, 2011): Ok, this issue is becoming a problem. I can't look through my tomcat logs because they are filled with this exception over and over again. With a clean log file, Tomcat startup, and accessing one page generates a 1MB log file. I've tried modifying my log4j.properties file to log the exception somewhere else, but I'm unable to do so. I have searched and searched for a reason for this and come up with nothing. Please help. Original: I have just recently installed xwiki 2.6, so this is essentially about a fresh install. I'm running Tomcat 5.5 and MySQL Server 5.1. I'm getting exceptions attempting to update xwikiproperties and xwikiobjects being thrown over and over showing up in Tomcat's log, but I'm not seeing any errors being shown to the user while using the wiki. In other words, these exceptions are being thrown, but the wiki appears to be working correctly from the users standpoint. The following are a couple of the exceptions. Example 1: java.sql.SQLException: org.apache.commons.dbcp.PoolablePreparedStatement with address: "com.mysql.jdbc.PreparedStatement@19bc376: update xwikiobjects set XWO_NUMBER=** NOT SPECIFIED **, XWO_NAME=** NOT SPECIFIED **, XWO_CLASSNAME=** NOT SPECIFIED **, XWO_GUID=** NOT SPECIFIED ** where XWO_ID=** NOT SPECIFIED **" is closed. at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:137) at org.apache.commons.dbcp.DelegatingStatement.clearBatch(DelegatingStatement.java:294) at org.apache.commons.dbcp.PoolablePreparedStatement.clearBatch(PoolablePreparedStatement.java:86) at org.apache.commons.dbcp.PoolablePreparedStatement.passivate(PoolablePreparedStatement.java:134) at org.apache.commons.dbcp.PoolingConnection.passivateObject(PoolingConnection.java:350) at org.apache.commons.pool.impl.GenericKeyedObjectPool.addObjectToPool(GenericKeyedObjectPool.java:1570) at org.apache.commons.pool.impl.GenericKeyedObjectPool.returnObject(GenericKeyedObjectPool.java:1526) at org.apache.commons.dbcp.PoolablePreparedStatement.close(PoolablePreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:168) at org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:168) at org.hibernate.jdbc.AbstractBatcher.closePreparedStatement(AbstractBatcher.java:534) at org.hibernate.jdbc.AbstractBatcher.closeStatement(AbstractBatcher.java:269) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87) at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2359) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2312) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2612) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:96) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.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(XWikiHibernateBaseStore.java:853) at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.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:1431) at com.xpn.xwiki.plugin.watchlist.WatchListJob.setPreviousFireTime(WatchListJob.java:170) at com.xpn.xwiki.plugin.watchlist.WatchListJob.executeJob(WatchListJob.java:240) at com.xpn.xwiki.plugin.scheduler.AbstractJob.execute(AbstractJob.java:75) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525) Example 2: java.sql.SQLException: org.apache.commons.dbcp.PoolablePreparedStatement with address: "com.mysql.jdbc.PreparedStatement@12407f7: update xwikiproperties set XWP_CLASSTYPE=** NOT SPECIFIED ** where XWP_ID=** NOT SPECIFIED ** and XWP_NAME=** NOT SPECIFIED **" is closed. at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:137) at org.apache.commons.dbcp.DelegatingStatement.clearBatch(DelegatingStatement.java:294) at org.apache.commons.dbcp.PoolablePreparedStatement.clearBatch(PoolablePreparedStatement.java:86) at org.apache.commons.dbcp.PoolablePreparedStatement.passivate(PoolablePreparedStatement.java:134) at org.apache.commons.dbcp.PoolingConnection.passivateObject(PoolingConnection.java:350) at org.apache.commons.pool.impl.GenericKeyedObjectPool.addObjectToPool(GenericKeyedObjectPool.java:1570) at org.apache.commons.pool.impl.GenericKeyedObjectPool.returnObject(GenericKeyedObjectPool.java:1526) at org.apache.commons.dbcp.PoolablePreparedStatement.close(PoolablePreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:168) at org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:168) at org.hibernate.jdbc.AbstractBatcher.closePreparedStatement(AbstractBatcher.java:534) at org.hibernate.jdbc.AbstractBatcher.closeStatement(AbstractBatcher.java:269) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2367) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2312) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2612) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:96) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.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(XWikiHibernateBaseStore.java:853) at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.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:1431) at com.xpn.xwiki.plugin.watchlist.WatchListJ
    via by Leonard Scardino,
  • Grails maxRows/queryTimeout warning
    via Stack Overflow by ubiquibacon
    ,
  • Translation XML files are empty
    via openbravo by eisler
    ,
  • MySQL :: Problem with connection on delete query
    via by Unknown author,
  • Customer reports seeing the following in the log: 2012-01-03 11:25:53,578 DEBUG [mondrian.server.Execution] mondrian.olap.MondrianException: Mondrian Error:An exception was encountered while trying to cleanup an execution context. A statement failed to cancel gracefully. Locus was : "Error while loading segment". java.sql.SQLException: org.apache.commons.dbcp.DelegatingStatement is closed. at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:136) at org.apache.commons.dbcp.DelegatingStatement.cancel(DelegatingStatement.java:249) at mondrian.server.Execution.cleanStatements(Execution.java:147) at mondrian.server.Execution.end(Execution.java:168) at mondrian.server.StatementImpl.end(StatementImpl.java:98) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:644) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:586) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:585) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Note that "A statement failed to cancel gracefully" occurs when an MDX statement times out, and Mondrian tries to cancel the running SQL statements. In this case, it looks as if the statements have already finished, but Mondrian still tries to cancel them. I think this bug is harmless, but it points to problems in the SQL statement lifecycle management.
    via by Julian Hyde,
    • java.sql.SQLException: org.apache.commons.dbcp.PoolablePreparedStatement with address: "com.mysql.jdbc.PreparedStatement@12407f7: update xwikiproperties set XWP_CLASSTYPE=** NOT SPECIFIED ** where XWP_ID=** NOT SPECIFIED ** and XWP_NAME=** NOT SPECIFIED **" is closed. at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:137) at org.apache.commons.dbcp.DelegatingStatement.clearBatch(DelegatingStatement.java:294) at org.apache.commons.dbcp.PoolablePreparedStatement.clearBatch(PoolablePreparedStatement.java:86) at org.apache.commons.dbcp.PoolablePreparedStatement.passivate(PoolablePreparedStatement.java:134) at org.apache.commons.dbcp.PoolingConnection.passivateObject(PoolingConnection.java:350) at org.apache.commons.pool.impl.GenericKeyedObjectPool.addObjectToPool(GenericKeyedObjectPool.java:1570) at org.apache.commons.pool.impl.GenericKeyedObjectPool.returnObject(GenericKeyedObjectPool.java:1526) at org.apache.commons.dbcp.PoolablePreparedStatement.close(PoolablePreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:168) at org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:168) at org.hibernate.jdbc.AbstractBatcher.closePreparedStatement(AbstractBatcher.java:534) at org.hibernate.jdbc.AbstractBatcher.closeStatement(AbstractBatcher.java:269) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2367) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2312) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2612) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:96) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.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(XWikiHibernateBaseStore.java:853) at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.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:1431)

    Users with the same issue

    Unknown visitor1 times, last one,