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.

XWiki.org JIRA | Leonard Scardino | 6 years ago
  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@12407f7: update xwikiproperties set XWP_CLASSTYPE=** NOT SPECIFIED ** where XWP_ID=** NOT SPECIFIED ** and XWP_NAME=** NOT SPECIFIED **" is closed.
  2. 0

    Hello, we encountered an error when using MySQL with the database-structure macro. We used only the dataSource parameter: {database-structure:dataSource=waveDS} Confluence-Version: 4.3.5 Stacktrace: {noformat} 2014-01-29 09:35:51,110 ERROR [TP-Processor6] [confluence.plugins.plantuml.AbstractDatabaseStructureMacroImpl] sqlException SQLException waveDS -- url: /confluence/display/~username/PlantUML+Database+Structure+Test | page: 15466510 | userName: username| referer: http://eudesgjra1wp/confluence/pages/createpage.action?spaceKey=~username&fromPageId=2293975 | action: viewpage java.sql.SQLException: Table not specified. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.DatabaseMetaData.getImportedKeys(DatabaseMetaData.java:3305) at org.apache.tomcat.dbcp.dbcp.DelegatingDatabaseMetaData.getImportedKeys(DelegatingDatabaseMetaData.java:314) at de.griffel.confluence.plugins.plantuml.AbstractDatabaseStructureMacroImpl.getForeignKeys(AbstractDatabaseStructureMacroImpl.java:393) at de.griffel.confluence.plugins.plantuml.AbstractDatabaseStructureMacroImpl.createDotForDatabaseStructure(AbstractDatabaseStructureMacroImpl.java:101) at de.griffel.confluence.plugins.plantuml.DatabaseStructureMacroV4$1.executePlantUmlMacro(DatabaseStructureMacroV4.java:81) at de.griffel.confluence.plugins.plantuml.AbstractDatabaseStructureMacroImpl.execute(AbstractDatabaseStructureMacroImpl.java:73) at de.griffel.confluence.plugins.plantuml.DatabaseStructureMacroV4.execute(DatabaseStructureMacroV4.java:77) at sun.reflect.GeneratedMethodAccessor920.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at com.atlassian.confluence.macro.xhtml.XhtmlMacroManager$ResourceAwareMacroInvocationHandler.invoke(XhtmlMacroManager.java:220) at $Proxy1372.execute(Unknown Source) at com.atlassian.confluence.content.render.xhtml.view.macro.ViewMacroMarshaller.marshal(ViewMacroMarshaller.java:88) at com.atlassian.confluence.content.render.xhtml.view.macro.ViewMacroMarshaller.marshal(ViewMacroMarshaller.java:24) at com.atlassian.confluence.content.render.xhtml.UnmarshalMarshalFragmentTransformer.transform(UnmarshalMarshalFragmentTransformer.java:27) at com.atlassian.confluence.content.render.xhtml.transformers.DefaultFragmentTransformer.transform(DefaultFragmentTransformer.java:106) at com.atlassian.confluence.content.render.xhtml.storage.StorageXhtmlTransformer.transform(StorageXhtmlTransformer.java:43) at com.atlassian.confluence.content.render.xhtml.TransformerChain.transform(TransformerChain.java:41) at com.atlassian.confluence.content.render.xhtml.PluggableTransformerChain.transform(PluggableTransformerChain.java:53) at com.atlassian.confluence.content.render.xhtml.DefaultRenderer.render(DefaultRenderer.java:80) at com.atlassian.confluence.content.render.xhtml.DefaultRenderer.render(DefaultRenderer.java:68) at com.atlassian.confluence.content.render.xhtml.DefaultRenderer.render(DefaultRenderer.java:58) at com.atlassian.confluence.content.render.xhtml.DeviceTypeAwareRenderer.render(DeviceTypeAwareRenderer.java:42) at com.atlassian.confluence.pages.actions.ViewPageAction.execute(ViewPageAction.java:245) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:64) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.xwork.interceptors.XsrfTokenInterceptor.intercept(XsrfTokenInterceptor.java:100) at com.atlassian.confluence.xwork.ConfluenceXsrfTokenInterceptor.intercept(ConfluenceXsrfTokenInterceptor.java:25) {noformat}

    JIRA | 3 years ago | David Franke
    java.sql.SQLException: Table not specified.
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Lost Administrator credentials

    YouTrack | 5 years ago
    java.sql.SQLException: Table not found in statement [UPDATE users SET PASSWORD = ? WHERE USERNAME = ? AND REALM IS NULL]
  5. 0

    JCAPS JDBC  DB2 Driver Error "SQLDIAGGRP was specified and not null"

    Oracle Community | 9 years ago | 807574
    java.sql.SQLException: [SeeBeyond][DB2 JDBC Driver]SQLDIAGGRP was specified and not null.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    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.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2367)
      7. org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2312)
      8. org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2612)
      8 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
      XWiki.saveDocument
      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)
      6 frames