× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.








As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.