Getting 'ResultSet can not re-read row data' SQLException Error Due to jTDS 1.0.2

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

When using SQLServer 2000 JDBC Driver, you may receive an error similar to:

net.sf.hibernate.LazyInitializationException: Exception initializing proxy: [com.atlassian.confluence.spaces.SpaceDescription#5]
at net.sf.hibernate.proxy.LazyInitializer.initializeWrapExceptions(LazyInitializer.java:64)
at net.sf.hibernate.proxy.LazyInitializer.getImplementation(LazyInitializer.java:164)
...
Caused by: 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 org.jboss.resource.adapter.jdbc.WrappedResultSet.getLong(WrappedResultSet.java:338)
at net.sf.hibernate.type.LongType.get(LongType.java:18)
...

Cause

Microsoft SQLServer 2000 JDBC driver is incompatible with Confluence Hibernate library.

See Hibernate Documentation.

Resolution

Upgrade to jTDS driver 1.0.3 or later from the jTDS download page. You may also consider alternative SQL Server drivers listed on the Hibernate page.


Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.