Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-1433

org.springframework.jdbc.UncategorizedSQLException with MS JDBC Type 4 Driver

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Medium
    • None
    • 1.1
    • None
    • orion 2.0.2
      Confluence 1.1
      linux v7.x redhat
      java 1.4.2
      MS Sql Server 2000
      MS Sql JDBC driver service pack 1

    Description

      Here's the sequence to get this re-create this problem.
      1) install orion server
      2) get release 1 jdbc drivers from microsoft
      3) install confluence under orion
      4) define data-sources in orion
      5) create empty db in ms sql server
      6) startup orion, setup confluence to point to new empty db
      7) login to confluence after setup, create 1 space
      8) exit confluence, shutdown orion and restart
      9) try to access confluence and get this error:

      org.springframework.jdbc.UncategorizedSQLException: (HibernateAccessor): encountered SQLException [[Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 2.]; nested exception is java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 2.

      From microsoft, the problem is the following:
      For nvarchar,image,text types the driver throws exception when the order you retrieved is differ from the order you access the result

      There are three tables in confluence with type 'Text' - CONTENT, EMAILTEMPLATES, and PAGETEMPLATES. I'm guessing the problem is with one of these tables. Here is more of the server log error:

      2004-06-18 17:47:55,805 WARN [sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: HY010
      2004-06-18 17:47:55,806 ERROR [sf.hibernate.util.JDBCExceptionReporter] [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 2.
      2004-06-18 17:47:55,807 WARN [sf.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: HY010
      2004-06-18 17:47:55,808 ERROR [sf.hibernate.util.JDBCExceptionReporter] [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 2.
      2004-06-18 17:47:55,812 ERROR [sf.hibernate.util.JDBCExceptionReporter] could not load: com.atlassian.confluence.spaces.SpaceDescription#1
      java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 2.
      at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
      at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
      at com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source)
      at com.microsoft.jdbc.base.BaseResultSet.getLong(Unknown Source)
      at com.microsoft.jdbc.base.BaseResultSet.getLong(Unknown Source)
      at net.sf.hibernate.type.LongType.get(LongType.java:18)

      Attachments

        Activity

          People

            Unassigned Unassigned
            a09a4d781816 William Crighton [CCC]
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: