Strange exception

[Nicolas Dufour <ni...@neometsys.fr>]

Hello

During a request I have a strange exception appearing at this kind of 
line in java :
time1   = result.getString("ORIG_TIME");
with time1 a String obviously

Here is the exception :
java.sql.SQLException: [IBM][CLI Driver] CLI0125E  Function sequence 
error. SQLSTATE=S1010

What does it mean exactly ?

Thank you

Nicolas

Re: Strange exception

[Army <qo...@sbcglobal.net>]

Nicolas Dufour wrote:
> Hello
> 
> During a request I have a strange exception appearing at this kind of 
> line in java :
> time1   = result.getString("ORIG_TIME");
> with time1 a String obviously
> 
> Here is the exception :
> java.sql.SQLException: [IBM][CLI Driver] CLI0125E  Function sequence 
> error. SQLSTATE=S1010
> 
> What does it mean exactly ?

Hmmm...This is an error that is thrown by the IBM DB2 ODBC client--I think it's 
the equivalent to a "result set closed" error.  I've never seen it show up as a 
Java exception, though...??

I noticed that in an earlier post you wrote:

 > My java program has parts in C and access to derby from C but with the
 > help of java methods using JNI.

I don't know the details of how all of that works, but maybe that's why the 
exception shows up as a CLI exception within a Java exception...?  In any event, 
as I said, this error usually means the result has been closed for some reason. 
  Is it possible that you have exhausted the result set by the time you make the 
"result.getString()" call?  Or perhaps the result set was created as 
CLOSE_CURSORS_AT_COMMIT and a commit occured before the call to getString()?

Of course, that's just speculation.  If you can include more details, including 
(the relevant parts of) a derby.log file and what your program was doing before 
the error, that might help.  Also, is this something that used to work but now 
fails, or has it always failed?

Army