Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes Cursor *N not open Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Cursor *N not open" Watch "Cursor *N not open" New topic
Author

Cursor *N not open

Srikanth Kumar
Ranch Hand

Joined: Jun 04, 2008
Posts: 36
I have a problem while executing query on DB2 on mainframe form java program.

When i am doing this i get an exception saying "Cursor *N not open."

Below is the code used


Srikanth Kumar
SCJP 5, SCWCD 5, SCDJWS 5
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

are you 100% certain that data is being returned.

and could you provide the exact error number from the database, and the line of java that is causing the error.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Cursor *N not open
 
Similar Threads
How to force cursor to update
Error in jdbc while executing procedure
Cannot get Oracle CURSOR from Oracle procedure
embedded SQL in legacy C code --- fetch issue
What am i doing wrong here? ( Stored Procedure REF CURSOR Problem)