Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

CURSOR STATE NOT VALID

Posted on 2004-09-28
14
845 Views
Last Modified: 2012-06-27
I am using the following result set and prepared statement.  The update query works, but the a "CURSOR STATE NOT VALID"
exception occurs and the rest of my code is ignore. Thanks in advance to anyone that can help.

String updateDb2Query = "UPDATE tstdtatst.A767040A set ORCPDT = '"+bReqCompDate+"', ORFL = '"+flag+"', ORACTN = '"+action+"', ORFIH = "+frontInsideHeight+",ORRIH = "+rearInsideHeight+",ORFLRT="+floorRate+",ORLNID="+lineSplit+", ORDATE='yyyy-mm-dd',ORGDTE='yyyy-mm-dd', ORTPRC="+bTotal+", ORTCST="+bTotalCost+", ORTMRG="+bTotalMargin+", ORQTY="+bTotalQty+",ORMODL='"+bModel+"',ORCO='"+bPlant+"',ORSLSF='"+salesfname+"', ORSLSL='"+saleslname+"', ORCUST="+customerJdeNum+", ORPRCD='"+productCode+"',ORDAUT='"+discountNumber+"',ORUSER='"+salesmanId+"' where ORGORN = "+oracleId+"";
pUpdateDb2Query = db2.prepareStatement(updateDb2Query, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rsUpdateDb2Query = pUpdateDb2Query.executeQuery();
rsUpdateDb2Query.close();  pUpdateDb2Query.close();
0
Comment
Question by:gdlp2004
  • 6
  • 5
  • 3
14 Comments
 
LVL 37

Expert Comment

by:zzynx
ID: 12170055
Make

      pUpdateDb2Query.executeQuery();


     pUpdateDb2Query.updateQuery();

and see if it's better


0
 
LVL 37

Expert Comment

by:zzynx
ID: 12170067
I mean t

       pUpdateDb2Query.executeUpdate();

of course ;°)
0
 
LVL 30

Expert Comment

by:Mayank S
ID: 12170078
Also, I think that you can do away with the rsUpdateDb2Query altogether. Just make it:

pUpdateDb2Query.updateQuery () ;
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 30

Expert Comment

by:Mayank S
ID: 12170089
>> pUpdateDb2Query.executeUpdate();

Copied from zzynxie's ;-) do the correction as he said.
0
 

Author Comment

by:gdlp2004
ID: 12170206
The compiler does not recognize the executeUpdate method.  Is it because I used ResultSet.CONCUR_READ_ONLY in my prepared statement.
0
 
LVL 37

Expert Comment

by:zzynx
ID: 12170281
>> The compiler does not recognize the executeUpdate method
??? It shoulc
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html#executeUpdate(java.lang.String)
0
 
LVL 30

Expert Comment

by:Mayank S
ID: 12170378
>> Is it because I used ResultSet.CONCUR_READ_ONLY in my prepared statement.

No. What code are you using? Can you post it? I'm sure something else is wrong.
0
 
LVL 37

Accepted Solution

by:
zzynx earned 500 total points
ID: 12170429
Replace the line

      rsUpdateDb2Query = pUpdateDb2Query.executeQuery();

of your original code by

      pUpdateDb2Query.executeUpdate();
0
 

Author Comment

by:gdlp2004
ID: 12170435
The code is in the question statement.
0
 
LVL 37

Expert Comment

by:zzynx
ID: 12170454
>> The code is in the question statement.
The original, yes.
But we can't see where you placed the executeUpdate() statement in the changed code.
0
 

Author Comment

by:gdlp2004
ID: 12170484
OH, sorry!
0
 

Author Comment

by:gdlp2004
ID: 12170549
String updateDb2Query = og query
pUpdateDb2Query = db2.prepareStatement(updateDb2Query, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
//rsUpdateDb2Query = pUpdateDb2Query.executeUpdate();
//updateDb2Query.executeUpdate();
//rsUpdateDb2Query.close();  pUpdateDb2Query.close();
pUpdateDb2Query.executeUpdate();

Here is the new code and it compiles. I am testing it now.
0
 

Author Comment

by:gdlp2004
ID: 12170638
The new code works.  Thank you
0
 
LVL 37

Expert Comment

by:zzynx
ID: 12173235
>> The new code works.  Thank you
Great. You're welcome
Thanks for accepting
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
factorial example 4 47
servlet web applications   metadata-complete="true" or false 3 109
jsp login check 12 42
Convert from a json string array to a Java object 3 51
For customizing the look of your lightweight component and making it look lucid like it was made of glass. Or: how to make your component more Apple-ish ;) This tip assumes your component to be of rectangular shape and completely opaque. (COD…
Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
This video teaches viewers about errors in exception handling.
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question