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.

XWiki.org JIRA | Leonard Scardino | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    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

    XWiki.org JIRA | 6 years ago | Leonard Scardino
    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.

    Root Cause Analysis

    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()
    2. Commons DBCP
      PoolingConnection.passivateObject
      1. org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:137)
      2. org.apache.commons.dbcp.DelegatingStatement.clearBatch(DelegatingStatement.java:294)
      3. org.apache.commons.dbcp.PoolablePreparedStatement.clearBatch(PoolablePreparedStatement.java:86)
      4. org.apache.commons.dbcp.PoolablePreparedStatement.passivate(PoolablePreparedStatement.java:134)
      5. org.apache.commons.dbcp.PoolingConnection.passivateObject(PoolingConnection.java:350)
      5 frames
    3. Commons Pool
      GenericKeyedObjectPool.returnObject
      1. org.apache.commons.pool.impl.GenericKeyedObjectPool.addObjectToPool(GenericKeyedObjectPool.java:1570)
      2. org.apache.commons.pool.impl.GenericKeyedObjectPool.returnObject(GenericKeyedObjectPool.java:1526)
      2 frames
    4. Commons DBCP
      DelegatingStatement.close
      1. org.apache.commons.dbcp.PoolablePreparedStatement.close(PoolablePreparedStatement.java:96)
      2. org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:168)
      3. org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:168)
      3 frames
    5. Hibernate
      AbstractEntityPersister.update
      1. org.hibernate.jdbc.AbstractBatcher.closePreparedStatement(AbstractBatcher.java:534)
      2. org.hibernate.jdbc.AbstractBatcher.closeStatement(AbstractBatcher.java:269)
      3. org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
      4. org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
      5. org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
      6. org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
      7. org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2359)
      8. org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2312)
      9. org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2612)
      9 frames
    6. Hibernate
      EntityUpdateAction.execute
      1. org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:96)
      1 frame
    7. Hibernate
      ActionQueue.executeActions
      1. org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
      2. org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
      3. org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
      3 frames
    8. Hibernate
      SessionImpl.managedFlush
      1. org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
      2. org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
      3. org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
      4. org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
      4 frames
    9. Hibernate
      JDBCTransaction.commit
      1. org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
      1 frame
    10. com.xpn.xwiki
      AbstractJob.execute
      1. com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:853)
      2. com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:824)
      3. com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:643)
      4. com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:181)
      5. com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:175)
      6. com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1431)
      7. com.xpn.xwiki.plugin.watchlist.WatchListJob.setPreviousFireTime(WatchListJob.java:170)
      8. com.xpn.xwiki.plugin.watchlist.WatchListJob.executeJob(WatchListJob.java:240)
      9. com.xpn.xwiki.plugin.scheduler.AbstractJob.execute(AbstractJob.java:75)
      9 frames
    11. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
      2 frames