Return-Path: Mailing-List: contact soap-user-help@xml.apache.org; run by ezmlm Delivered-To: mailing list soap-user@xml.apache.org Received: (qmail 95763 invoked from network); 2 Aug 2002 15:28:52 -0000 Received: from ms3.progressive.com (HELO s7150095.progdmz.com) (12.149.100.86) by daedalus.apache.org with SMTP; 2 Aug 2002 15:28:52 -0000 Received: from s65aa344.prci.com (unverified) by s7150095.progdmz.com (Content Technologies SMTPRS 4.2.10) with ESMTP id ; Fri, 2 Aug 2002 11:28:51 -0400 Subject: DB2/servlet error....Can anyone help !!! To: soap-user@xml.apache.org, tomcat-user@jakarta.apache.org, tomcat-dev@jakarta.apache.org X-Mailer: Lotus Notes Release 5.0.6a January 17, 2001 Message-ID: From: Nishant_Awasthi@progressive.com Date: Fri, 2 Aug 2002 11:20:22 -0400 X-MIMETrack: Serialize by Router on Camp-SMTP-01/Progressive(Release 5.0.6a |January 17, 2001) at 08/02/2002 11:28:51 AM MIME-Version: 1.0 Content-type: text/plain; charset="us-ascii" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N hello gurus... I am trying to run servlet on DB2... I have tested that My servlet is successfully established the connection with the Db2 with the connection string I am using, but, It is throwing following exception/error [IBM][JDBC Driver] CLI0601E Invalid statement handle or statement is closed. SQLSTATE=S1000 when I try to use stmt = con.createStatement(); rs = stmt.executeQuery("select * from db2admin.employee"); in my servlet code. I try to find out the cause for this problem, I found the reason on http://www-3.ibm.com/software/data/db2/udb/ad/v7/abg/db2ax44.htm As per the link All the error message logs to file: jdbcerr.log which is placed in C:\WINNT\system32 I opened it to find the following: (Thu Aug 01 15:52:28 2002) pid= 2952 main(): Server is starting up on user specified port, einfo= 6790 (client IP = ) (Thu Aug 01 15:52:50 2002) pid= 2192 jdbcFSQLConnect(): The levels of db2java.zip ((null)) and db2jd (n010415) do not match, einfo= -111 (client IP = 10.3.13.34) Now, I can make out that there is mis-match between db2java.zip and db2jd levels... But I don't know how to correct it... Do anyone of you had similar problem in the past? Can Any guru throw some light..on this.. I appreciate your help, ------------------------------------------------------------------------------------ Nishant Awasthi Corporate Systems Development Progressive Insurance