com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'labelid'.

Atlassian JIRA | Matt Ryall | 1 decade ago
  1. 0

    Case-sensitivity bug in the findUnusedLabels() database call. The exception looks like this: org.springframework.jdbc.UncategorizedSQLException: (Hibernate operation): encountered SQLException [Invalid column name 'labelid'. ]; nested exception is com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'labelid'. com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'labelid'. at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846) at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168) at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69) at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220) at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203) at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1596) at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1581) at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:96) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:75) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) at net.sf.hibernate.loader.Loader.doList(Loader.java:1063) at net.sf.hibernate.loader.Loader.list(Loader.java:1054) at net.sf.hibernate.loader.SQLLoader.list(SQLLoader.java:92) at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3867) at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52) at com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao$9.doInHibernate(HibernateLabelDao.java:518) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200) at com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao.findUnusedLabels(HibernateLabelDao.java:512) at com.atlassian.confluence.labels.DefaultLabelManager.removeAllLabels(DefaultLabelManager.java:213)

    Atlassian JIRA | 1 decade ago | Matt Ryall
    com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'labelid'.
  2. 0

    Case-sensitivity bug in the findUnusedLabels() database call. The exception looks like this: org.springframework.jdbc.UncategorizedSQLException: (Hibernate operation): encountered SQLException [Invalid column name 'labelid'. ]; nested exception is com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'labelid'. com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'labelid'. at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846) at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168) at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69) at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220) at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203) at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1596) at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1581) at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:96) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:75) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) at net.sf.hibernate.loader.Loader.doList(Loader.java:1063) at net.sf.hibernate.loader.Loader.list(Loader.java:1054) at net.sf.hibernate.loader.SQLLoader.list(SQLLoader.java:92) at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3867) at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52) at com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao$9.doInHibernate(HibernateLabelDao.java:518) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200) at com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao.findUnusedLabels(HibernateLabelDao.java:512) at com.atlassian.confluence.labels.DefaultLabelManager.removeAllLabels(DefaultLabelManager.java:213)

    Atlassian JIRA | 1 decade ago | Matt Ryall
    com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name 'labelid'.
  3. 0

    Getting Datatype mismatch in Hibernate Criteria

    Stack Overflow | 3 years ago | amin
    com.sybase.jdbc2.jdbc.SybSQLException: Implicit conversion from datatype 'VARCHAR' to 'BIT' is not allowed. Use the CONVERT function to run this query.</p> </blockquote> <pre><code>at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2796)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    under-the-covers stored procedures conflict with caching prepared statements...

    Google Groups | 1 decade ago | Joe Weinstein
    com.sybase.jdbc2.jdbc.SybSQLException: Stored procedure '*0000890000 0000_0033c9' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.
  6. 0

    setAutoCommit() can invalidate a PreparedStatement!

    Google Groups | 1 decade ago | Joe Weinstein
    com.sybase.jdbc2.jdbc.SybSQLException: Stored procedure '*0000950000 0000_0033c9' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.

    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. com.sybase.jdbc2.jdbc.SybSQLException

      Invalid column name 'labelid'.

      at com.sybase.jdbc2.tds.Tds.processEed()
    2. com.sybase.jdbc2
      SybPreparedStatement.executeQuery
      1. com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2846)
      2. com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2168)
      3. com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
      4. com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
      5. com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
      6. com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1596)
      7. com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1581)
      8. com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:96)
      8 frames
    3. c3p0:JDBC DataSources/Resource Pools
      NewProxyPreparedStatement.executeQuery
      1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:75)
      1 frame
    4. net.sf.hibernate
      SQLQueryImpl.list
      1. net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89)
      2. net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880)
      3. net.sf.hibernate.loader.Loader.doQuery(Loader.java:273)
      4. net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
      5. net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
      6. net.sf.hibernate.loader.Loader.list(Loader.java:1054)
      7. net.sf.hibernate.loader.SQLLoader.list(SQLLoader.java:92)
      8. net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3867)
      9. net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52)
      9 frames
    5. com.atlassian.confluence
      HibernateLabelDao$9.doInHibernate
      1. com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao$9.doInHibernate(HibernateLabelDao.java:518)
      1 frame
    6. Hibernate
      HibernateTemplate.execute
      1. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
      1 frame
    7. com.atlassian.confluence
      DefaultLabelManager.removeAllLabels
      1. com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao.findUnusedLabels(HibernateLabelDao.java:512)
      2. com.atlassian.confluence.labels.DefaultLabelManager.removeAllLabels(DefaultLabelManager.java:213)
      2 frames