Re: The Cursor State Not Valid is driving me crazy!

Try adding "FOR UPDATE" to your statement.  Prior to a v5r1 PTF, the server
created updatable result sets only if the statement said FOR UPDATE.  After
a debate with the server team when JDBC 2.0 came out, the Toolbox driver
decided not to add "FOR UPDATE" to the application-supplied statement when
the RS type was ResultSet.CONCUR_UPDATABLE.  The theory was the driver
shouldn't mess with the statement, and iSeries programmers are used to
putting FOR UPDATE on their statements.

After additional debate, we finally convinced the server team they needed
to provide us an interface to create updatable cursors even though FOR
UPDATE was not on the statement.  They finally added that interface in a
recent v5r1 PTF.  The client side of that change is in JTOpen 3.1 (coming
out next week).

So, you can add FOR UPDATE, or get JTOpen 3.1 + a server PTF.

David Wall
Toolbox for Java
iSeries ODBC Driver for Linux




                      "Mike Silvers"
                      <msilvers@hbs-inc        To:       
<java400-l@midrange.com>
                      .com>                    cc:
                      Sent by:                 Subject:  The Cursor State Not 
Valid is driving me crazy!
                      java400-l-admin@m
                      idrange.com


                      05/10/2002 01:19
                      PM
                      Please respond to
                      java400-l





All,

Before one of you says it, I know...the drive is not a long one :)

I am having a problem when trying to update a file.  I create a prepared
statement with ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE.
I then read the file and get a result back.  I checked the cursor position
and saw that the cursor is sitting on row #1.  I make my changes to the
values in the wrapper class.  After the changes are made, I am going to
update all the resultset fields.  First, I check the row the cursor is on.
It is still on row #1.  I then try to update the resultset with the new
values.  Every time I try this, I get an error.  The error is:

Cursor state not valid.
SQLError code: -99999
SQLError state: 24000
Stack Trace:
java.sql.SQLException: Cursor state not valid.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:296)
at
com.ibm.as400.access.AS400JDBCResultSet.beforeUpdate(AS400JDBCResultSet.java

:2954)
at
com.ibm.as400.access.AS400JDBCResultSet.updateValue(AS400JDBCResultSet.java:

4487)
at
com.ibm.as400.access.AS400JDBCResultSet.updateBigDecimal(AS400JDBCResultSet.

java:3310)
at dataaccess.JDBCFileAccess.update(JDBCFileAccess.java:223)
at dataaccess.JDBCFileAccess.main(JDBCFileAccess.java:548)

I tried everything I could possible think of..... leaving the cursor where
it sits, moving the cursor back, forward, to current row.... Nothing works!
I get the same error every time...the stack dump is the same each time too.

Any ideas???

Thanks!

Mike

================================
Mike Silvers
AS/400 Senior Programmer/Analyst
AS/400 IBM Certified RPG IV Developer
AS/400 IBM Certified Solutions Expert
Hainey Business Systems
8 E. Canal St
Dover, PA 17315
Branch Office:  (410) 397-8739
Phone:  (800) 932-3380 ext. 237
Fax:  (717) 292-9474
Web: http://www.hbs-inc.com
________________________________
Providing E-Commerce, EDI, AS/400
Development, Java Development,
and related services nationwide.
================================


_______________________________________________
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.