my dog learned polymorphism*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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
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)
Error in jdbc while executing procedure
How to force cursor to update