java.sql.SQLException

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.

  • Errors with SpagoBI
    via by Unknown author,
  • For example, this error can be thrown during a 1.4.4 to 2.0 upgrade: 2005-11-17 04:03:00,068 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' 2005-11-17 04:03:00,068 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' 2005-11-17 04:03:00,069 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' 2005-11-17 04:03:00,069 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' 2005-11-17 04:03:00,072 ERROR [sf.hibernate.util.JDBCExceptionReporter] could not load: [com.atlassian.confluence.spaces.SpaceDescription#1] java.sql.SQLException: Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279) at com.mysql.jdbc.Connection.execSQL(Connection.java:2281) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1634) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:75) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133) at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:911) If the scheduled job responsible for polling mail accounts is started before Confluence has had a chance to upgrade the CONTENT table.
    via by Dave Loeng [Atlassian],
  • RDBMS compatibility
    via runawfe by yilativs
    ,
  • For example, this error can be thrown during a 1.4.4 to 2.0 upgrade: 2005-11-17 04:03:00,068 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' 2005-11-17 04:03:00,068 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' 2005-11-17 04:03:00,069 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' 2005-11-17 04:03:00,069 ERROR [sf.hibernate.util.JDBCExceptionReporter] Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' 2005-11-17 04:03:00,072 ERROR [sf.hibernate.util.JDBCExceptionReporter] could not load: [com.atlassian.confluence.spaces.SpaceDescription#1] java.sql.SQLException: Unknown column 'spacedescr0_.VERSIONCOMMENT' in 'field list' at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279) at com.mysql.jdbc.Connection.execSQL(Connection.java:2281) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1634) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:75) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133) at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:911) If the scheduled job responsible for polling mail accounts is started before Confluence has had a chance to upgrade the CONTENT table.
    via by Dave Loeng [Atlassian],
  • GitHub comment 598#140930847
    via GitHub by g0t4
    ,
  • Why dont my update resultset work
    via Stack Overflow by user1880497
    ,
    • java.sql.SQLException: Unknown column 'T\_designation.DEPARTMENT\_ID' in 'where clause' at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279) at com.mysql.jdbc.Connection.execSQL(Connection.java:2281) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1634) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.openxava.tab.impl.JDBCTabProvider.nextBlock(JDBCTabProvider.java:235) at org.openxava.tab.impl.JDBCTabProvider.nextChunk(JDBCTabProvider.java:258) at org.openxava.tab.impl.EntityTabDataProvider.nextChunk(EntityTabDataProvider.java:35) at org.openxava.tab.impl.EntityTab.nextChunk(EntityTab.java:296) at org.openxava.tab.impl.TableModelBean.getRow(TableModelBean.java:120) at org.openxava.tab.impl.TableModelBean.getValueAt(TableModelBean.java:171) at org.openxava.tab.impl.XTableModelDecoratorBase.getValueAt(XTableModelDecoratorBase.java:63) at org.openxava.tab.impl.HiddenXTableModel.getValueAt(HiddenXTableModel.java:70) at org.openxava.calculators.DescriptionsCalculator.read(DescriptionsCalculator.java:105) at org.openxava.calculators.DescriptionsCalculator.calculate(DescriptionsCalculator.java:58) at org.openxava.calculators.DescriptionsCalculator.getDescriptions(DescriptionsCalculator.java:150)

    Users with the same issue

    Unknown visitor1 times, last one,
    ivanszkypeter
    470 times, last one,
    slash
    1 times, last one,
    musketyr
    1 times, last one,
    mauritius
    1 times, last one,
    20 more bugmates