ResultSet can not re-read row data of Blob Type. | SQL Server Performance Forums

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 Source)at Source)at Source)at Source)at Source)
Please help me out, if you have any idea!!! Thanks in advance
John Berry
Check this 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=’:)‘ />]<br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=></a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=></a>) <br />
You need to exclude that column from query
Madhivanan Failing to plan is Planning to fail