ResultSet can not re-read row data in SqlServer

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

ResultSet can not re-read row data in SqlServer

Author

Topic

johnberry
Starting Member

1 Post

Posted - 2005-07-11 : 05:54:11

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;

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

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-07-11 : 06:14:37

I think one of your table columns has image datatype
Instead of Select *
Use

Select <Required Cols> from DBO.RS_TABLELOB where Rep_sync_id > 15 
and Rep_server_name != 'replicator' order by Rep_sync_id

http://support.microsoft.com/kb/824106

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources