Re: DB2SQLException

["David Duerr" <dduerr@xxxxxxxxxxxxxxxxx>]

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
+---