SQL Server Performance Forum – Threads Archive

ResultSet can not re-read row data of Blob Type.

I am using SqlServer 2000 and Jdbc connectivity in my application on windows.So, when i execute a query on Sqlserver database as : Select * from DBO.RS_TABLELOB where Rep_sync_id > 15 and Rep_server_name != ‘replicator’ order by Rep_sync_id; This problem is only with the BLOB data types in table RS_TABLELOB. Then i got an error as: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.’.’.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.getObject(Unknown Source)at com.microsoft.jdbc.base.BaseResultSet.getObject(Unknown Source)
Please help me out, if you have any idea!!! Thanks in advance
John Berry

Check this
http://support.microsoft.com/default.aspx/kb/824106? says This behavior is by design. [B)]

You might also want to get away from SELECT * and explicitely name the columns you request. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

You need to exclude that column from query
Madhivanan Failing to plan is Planning to fail

]]>