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

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

    • Icon: Bug Bug
    • Resolution: Won't Fix
    • Icon: Medium 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

      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)

            [CONFSERVER-1433] org.springframework.jdbc.UncategorizedSQLException with MS JDBC Type 4 Driver

            Hi William,

            This exception is caused by a known issue with Microsoft's JDBC drivers against a component we use called Hibernate. Our recommendation is for you to try out jTDS drivers which can be downloaded free from here:

            http://jtds.sourceforge.net/

            Cheers,
            Dave

            dave (Inactive) added a comment - Hi William, This exception is caused by a known issue with Microsoft's JDBC drivers against a component we use called Hibernate. Our recommendation is for you to try out jTDS drivers which can be downloaded free from here: http://jtds.sourceforge.net/ Cheers, Dave

            However, this seems to not affect my tomcat install with the same jdbc driver jar and configuration, data-source config. So it's more of an orion/microsoft jdbc driver than anything.

            William Crighton [CCC] added a comment - However, this seems to not affect my tomcat install with the same jdbc driver jar and configuration, data-source config. So it's more of an orion/microsoft jdbc driver than anything.

            William Crighton [CCC] added a comment - More on description of problem by microsoft guy. Sounds reasonable: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=onwk8.146877%24Dl4.16462392%40typhoon.tampabay.rr.com&rnum=1&prev=/groups%3Fq%3D%2522ResultSet%2520can%2520not%2520re-read%2520row%2520data%2520for%2520column%25202%2522%26hl%3Den%26lr%3D%26ie%3DUTF-8%26sa%3DN%26tab%3Dwg

              Unassigned Unassigned
              a09a4d781816 William Crighton [CCC]
              Affected customers:
              0 This affects my team
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: