File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes [Help]SQL0501-Cursor CRSR0004 not open Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "[Help]SQL0501-Cursor CRSR0004 not open" Watch "[Help]SQL0501-Cursor CRSR0004 not open" New topic

[Help]SQL0501-Cursor CRSR0004 not open

Eung maeng
Ranch Hand

Joined: Feb 10, 2002
Posts: 68
Hi guys,
I need you guy's help to solve this error "QL0501 - Cursor CRSR0004 not open"
Does anyone have a same error before?
Please send a mail as soon as possible. It would be greatly appreciated.
look forward to hearing from you soon.
paul maeng
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

Please, post your answers here so that someone else can find the answer when searching the forum.
With that said, you'll need to be more specific in your question for a more accurate answer. Information that would help:
1. database vendor (Oracle, MySQL, MSSQL...)
2. driver ( Oracle thin, merant, ODBC bridge...)
3. post a code snippet of the problem area ( use the "Instant UBB Code" tags below to help format your code ) identifying the line throwing the error.

Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1141

This is a wild guess -- based on, as Jamie says, the [incredible lack of] information you have provided.
You have "close()"d your "ResultSet", and then you are trying to do something with it (like "next()" or "getObject()"). Once you have invoked the "close()" method, you cannot do anything more with it.
Apart from the details that Jamie has suggested you supply, I think the entire error message and accompanying stack trace would also help.
Good Luck,
I agree. Here's the link:
subject: [Help]SQL0501-Cursor CRSR0004 not open
It's not a secret anymore!