Re: Descriptor Index not Valid.

["Dave Wall" <dawall@xxxxxxxxxx>]

You said "There are two rows in the table. Both of them are retrieved. When
I try to get the third row, I get the Descriptor Index Not Valid error."
Are you sure you don't access the result set after rs.next() returns false?
The thing that worried me in your question is you said you get an error
trying to get the third row of data.  I would expect an error getting the
third row when there are only two rows of data in the database, but I would
expect a cursor-state-not-valid error.  Index-not-valid usually happens
when you try to read a column you didn't retrieve.  For example, you do
rs.getString(5) when you retrieve only four columns of data.

David Wall
Toolbox for Java
iSeries ODBC Driver for Linux




                      "Mangavalli,
                      Ramanujam"               To:       
"'java400-l@midrange.com'" <java400-l@midrange.com>
                      <RamM@Mvmills.com        cc:
                      >                        Subject:  Descriptor Index not 
Valid.
                      Sent by:
                      java400-l-admin@m
                      idrange.com


                      05/24/2002 02:35
                      PM
                      Please respond to
                      java400-l





I am getting a "java.sql.SQLException: Descriptor index not valid." Error.
Anyone have any suggestions how to get rid of this?
I am trying to extend the AbstractTableModel and write a custom table model
and display a JTable that displays data from the iSeries 400. I am getting
this error when the following is executed:

validRow = getResultSet().next()

if (validRow)

// store row in the dummy row vector.
//
...
...
...

there are two rows in the table. Both of them are retrieved. When I try to
get the third row, I get the Descriptor Index Not Valid error.
I am using Eclipse and imported(actually I had to copy the class files into
the workspace) the ET400 classes.

Thanks in advance.

_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.