|
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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.