Getting this error when (it looks like) Hibernate is attempting to re-read or read out of order a text or ntext column. I found an article from MS 824106 related to this. This seemed to have come up when I added a sub-class to the listing table. Is this an MS thing or am I doing something incorrect?
Using latest public version of Hibernate.
Using MS SQL Server 2000 and MSJDBC Driver.
Microsoft KB:
http://support.microsoft.com/default.aspx?kbid=824106
Exception:
org.springframework.jdbc.UncategorizedSQLException: (HibernateAccessor): encountered SQLException [[Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 3.]; nested exception is java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 3.
Mapping:
<class name="Listing" table="docs_listing">
<id name="id" column="id" type="integer">
<generator class="assigned"/>
</id>
<discriminator column="listing_type" not-null="true"/>
<property name="name" column="name" type="string" not-null="true"/>
<property name="description" column="descr" type="text"/>
<property name="summary" column="summary" type="text"/>
<property name="listingDate" column="listing_date" type="calendar" not-null="true"/>
<set name="categories" table="docs_categories" lazy="false">
<key column="doc_id"/>
<many-to-many column="category_id" class="DocumentCategory"/>
</set>
<subclass name="HyperlinkListing">
<property name="externalUrl" column="url" type="string" not-null="true"/>
</subclass>
<subclass name="FileListing"/>
<subclass name="WebPageListing"/>
</class>