-
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
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)
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