Re: DB2SQLException

You are exactly right about the error.  Probably either the
statement.close() method was called or the connection.close() method was
called.

Can you send me (probably directly instead of to the group) some
information on the error handler framework you are building?  In
particular, I am interested in an assumptions you might be making about
specific error messages/SQL codes/vendor codes happening at specific times.
I am curious mostly because I have often wondered what potential effect I
can have on users when I modify what specific error messages say or when
they get returned.

Anyone else out there that has thoughts on this subject should feel free to
send them to me as well.  Thanks.

Regards,

Richard D. Dettinger
AS/400 Java Data Access Team

"TRUE! nervous, very, very dreadfully nervous I had been and am; but why
WILL you say that I am mad?
The disease had sharpened my senses, not destroyed, not dulled them. "

- Edgar Allan Poe
"The Tell-Tale Heart"




"David Duerr" <dduerr@DUERRBUSINESS.COM> on 08/02/2000 04:43:04 PM

Please respond to JAVA400-L@midrange.com

To:   JAVA400-L@midrange.com
cc:
Subject:  Re: DB2SQLException




Hello teresa,

Ironically, I am in the middle of writting an exception handler framework
and had the DB2 UDB Message Reference opened to the SQLSTATE messages when
I
got your e-mail.    If you have IBM DB2 Universal Database installed it
should have an online information function.  In the application programming
section you will find the Message Reference.  However, I must warn you that
you won't find any more insight there than from DB2SQLException message.

It does appear that you are trying to execute a statement that is closed.
If you did not explicitly close the statement there are still other ways a
statement will close, such as a lost connection.

Thanks,
Dave
----- Original Message -----
From: teresa garcia <teresa_a_garcia@hotmail.com>
To: <JAVA400-L@midrange.com>
Sent: Wednesday, August 02, 2000 4:23 PM
Subject: DB2SQLException


> Hello everybody, I wonder if any one out there could point me where to
look
> to research the following sql exception error that I am getting from a
java
> program:
>
> com.ibm.db2.jdbc.app.DB2SQLException: [IBM][JDBC Driver] CLI0601E Invalid
> statement handle or statement is closed. SQLSTATE=S1000. date: 07312000
> time: 061333
>
> I don't find any on-line manual to read about the return code  and the
> SQLSTATE in this message. Any help will be appreciate.
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> +---
> | This is the JAVA/400 Mailing List!
> | To submit a new message, send your mail to JAVA400-L@midrange.com.
> | To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
JAVA400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: joe@zappie.net
> +---
>


+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---