[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-484) ResultSet can not re-read row data for column 2

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Benoit Menendez
    Created: Tue, 25 Nov 2003 3:38 PM
       Body:
Response from Microsoft

The driver supports random column access except in the case of long data, 
like image columns. The following article describes the error that you 
typically see when you try to retrieve binary data out of order:

PRB: "ResultSet Can Not Re-Read Row Data"' Error When Reading Data from a 
JDBC ResultSet Object
ID: 824106
http://support.microsoft.com/?id=824106

If this is what you are running into, it is by design for the driver. For 
performance reasons, we do not cache binary data to allow re-reads.

Regarding the true Blob support, SQL Server itself does not support Array 
types or SQL3 blob/clob types as described in the JDBC reference, so we 
have no plans to support these types at this point. Any possible support 
for this would come in a future version of SQL (and I don't know if this is 
even planned or not), so there are no plans to include this in the driver 
in the near future.

Thanks!
Sarah Parra
Microsoft Developer Support

---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-484
    Summary: ResultSet can not re-read row data for column 2
       Type: Bug

     Status: Unassigned
   Priority: Major

    Project: Hibernate2

   Assignee: 
   Reporter: Benoit Menendez

    Created: Thu, 20 Nov 2003 12:24 PM
    Updated: Tue, 25 Nov 2003 3:38 PM

Description:



---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira