This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 77804 - MS SQL - can not re-read row data
Summary: MS SQL - can not re-read row data
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 5.x
Hardware: All Windows XP
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-06-13 13:25 UTC by clover
Modified: 2007-01-23 10:17 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description clover 2006-06-13 13:25:43 UTC
When trying to view table on SQL Server I'm getting the following exception:

java.sql.SQLException: [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 
org.netbeans.modules.db.sql.execute.ResultSetTableModelSupport$GenericWritableC
olumnDef.getColumnValue(ResultSetTableModelSupport.java:234)
	at 
org.netbeans.modules.db.sql.execute.ResultSetTableModelSupport.retrieveRows
(ResultSetTableModelSupport.java:404)
	at org.netbeans.modules.db.sql.execute.ui.ResultSetTableModel.<init>
(ResultSetTableModel.java:53)
	at org.netbeans.modules.db.sql.execute.ui.SQLResultPanelModel.<init>
(SQLResultPanelModel.java:36)
	at org.netbeans.modules.db.sql.loader.SQLEditorSupport$3.run
(SQLEditorSupport.java:302)
	at org.openide.util.RequestProcessor$Task.run
(RequestProcessor.java:493)
	at org.openide.util.RequestProcessor$Processor.run
(RequestProcessor.java:926)


I commented out the part of retrieveRows() which is responsible for calling 
rs.getObject(i) for the second time. And this is enough to get rid of that 
exception, but than I'm loosing the support for column types.
Comment 1 Andrei Badea 2006-06-30 19:31:11 UTC
Very likely fixed by the fix of issue 73168. Please verify.
Comment 2 Lukasz Grela 2007-01-23 10:17:16 UTC
v.