Re: DB2/servlet error....Help need please
Can anyone help me Please !!! Thanks Nishant Awasthi Nishant_Awasthi@progr essive.com To: [EMAIL PROTECTED], [EMAIL PROTECTED], 08/02/2002 11:20 AM [EMAIL PROTECTED] Please respond tocc: (bcc: Nishant Awasthi) Tomcat Users List Subject: DB2/servlet errorCan anyone help !!! 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 -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DB2/servlet error....Help need please
Can you run the same code outside of a servlet context? If so then it sounds like classpath problems. If not, can you re-install DB2? Sounds like your installation might be bad or you might be missing some components. dwh [EMAIL PROTECTED] wrote: (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... -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DB2/servlet error....Help need please
Hello Denis Thanks for your suggestions... I tried reinstalling DB2 but the same problem is coming... If you look here it asks for someFixPack 2 or later. http://www-3.ibm.com/software/data/db2/udb/ad/v7/abg/db2ax44.htm I am using IBM DB2 Version 7.2 FixPack 3. and IBM WebSphere Application - Single Server Edition Version 4.0 I tried finding out downloadable fixPack version but it failed to find one separately...everywhere it comes with the Software package and not alone... Nishant Awasthi Corporate Systems Development Progressive Insurance Denis Haskin Denis@HaskinFerTo: Tomcat Users List guson.net [EMAIL PROTECTED] cc: (bcc: Nishant Awasthi) 08/02/2002 02:08Subject: Re: DB2/servlet errorHelp need PM please Please respond to Tomcat Users List Can you run the same code outside of a servlet context? If so then it sounds like classpath problems. If not, can you re-install DB2? Sounds like your installation might be bad or you might be missing some components. dwh [EMAIL PROTECTED] wrote: (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... -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: DB2/servlet error....Help need please
Wait, you're not even using tomcat?!?!?!?! :( John Turner [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 2:32 PM To: Tomcat Users List Subject: Re: DB2/servlet errorHelp need please Hello Denis Thanks for your suggestions... I tried reinstalling DB2 but the same problem is coming... If you look here it asks for someFixPack 2 or later. http://www-3.ibm.com/software/data/db2/udb/ad/v7/abg/db2ax44.htm I am using IBM DB2 Version 7.2 FixPack 3. and IBM WebSphere Application - Single Server Edition Version 4.0 I tried finding out downloadable fixPack version but it failed to find one separately...everywhere it comes with the Software package and not alone... Nishant Awasthi Corporate Systems Development Progressive Insurance Denis Haskin Denis@HaskinFerTo: Tomcat Users List guson.net [EMAIL PROTECTED] cc: (bcc: Nishant Awasthi) 08/02/2002 02:08Subject: Re: DB2/servlet errorHelp need PM please Please respond to Tomcat Users List Can you run the same code outside of a servlet context? If so then it sounds like classpath problems. If not, can you re-install DB2? Sounds like your installation might be bad or you might be missing some components. dwh [EMAIL PROTECTED] wrote: (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... -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: DB2/servlet error....Help need please
I am trying to access servlet via Tomcat as well as WebSphere... If it runs with one it will run with other too... Nishant Awasthi Corporate Systems Development Progressive Insurance Turner, JohnTo: 'Tomcat Users List' JTurner@AAS.[EMAIL PROTECTED] com cc: (bcc: Nishant Awasthi) Subject: RE: DB2/servlet errorHelp need 08/02/2002 please 02:35 PM Please respond to Tomcat Users List Wait, you're not even using tomcat?!?!?!?! :( John Turner [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 2:32 PM To: Tomcat Users List Subject: Re: DB2/servlet errorHelp need please Hello Denis Thanks for your suggestions... I tried reinstalling DB2 but the same problem is coming... If you look here it asks for someFixPack 2 or later. http://www-3.ibm.com/software/data/db2/udb/ad/v7/abg/db2ax44.htm I am using IBM DB2 Version 7.2 FixPack 3. and IBM WebSphere Application - Single Server Edition Version 4.0 I tried finding out downloadable fixPack version but it failed to find one separately...everywhere it comes with the Software package and not alone... Nishant Awasthi Corporate Systems Development Progressive Insurance Denis Haskin Denis@HaskinFerTo: Tomcat Users List guson.net [EMAIL PROTECTED] cc: (bcc: Nishant Awasthi) 08/02/2002 02:08Subject: Re: DB2/servlet errorHelp need PM please Please respond to Tomcat Users List Can you run the same code outside of a servlet context? If so then it sounds like classpath problems. If not, can you re-install DB2? Sounds like your installation might be bad or you might be missing some components. dwh [EMAIL PROTECTED] wrote: (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... -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DB2/servlet error....Help need please
Not clear what your response to my first question was: does db2 connectivity work from code that is executed *outside* of a servlet context, that is, from the command line? I would make sure that works first. dwh [EMAIL PROTECTED] wrote: Hello Denis Thanks for your suggestions... I tried reinstalling DB2 but the same problem is coming... If you look here it asks for someFixPack 2 or later. [...] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DB2/servlet error....Help need please
- Original Message - From: [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Friday, August 02, 2002 2:38 PM Subject: RE: DB2/servlet errorHelp need please I am trying to access servlet via Tomcat as well as WebSphere... If it runs with one it will run with other too... yes, it will, because they both implement the spec; but I think John was just pointing out the irony of using the Tomcat support infrastructure to prop up IBM's product... I'd say visit the IBM site and read all their documentation from the top ;) http://www-3.ibm.com/software/data/db2/java/ Tomcat isn't the issue here. And if a complete fresh install of both drivers and server didn't fix the issues and unless there is a DB2-JDBC expert lurking here I know you've been pulling your hair out for the past few days. Is it possible for you can switch to another database? Regards, Michael -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DB2/servlet error....Help need please
Sorry Dennis to skip answering the first part... well yes DB2 connectivity works fine outside the servlet context... If I run a simple JAVA file to perform DB2 database data retrieval, it works fine. Its only with servlet it is not working... Nishant Awasthi Corporate Systems Development Progressive Insurance Denis Haskin Denis@HaskinFerTo: Tomcat Users List guson.net [EMAIL PROTECTED] cc: (bcc: Nishant Awasthi) 08/02/2002 02:58Subject: Re: DB2/servlet errorHelp need PM please Please respond to Tomcat Users List Not clear what your response to my first question was: does db2 connectivity work from code that is executed *outside* of a servlet context, that is, from the command line? I would make sure that works first. dwh [EMAIL PROTECTED] wrote: Hello Denis Thanks for your suggestions... I tried reinstalling DB2 but the same problem is coming... If you look here it asks for someFixPack 2 or later. [...] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DB2/servlet error....Help need please
Thanks Michael and John for your suggestions... I have got success in running many of my applications on Tomcat and DB2 but this problem seems to be taking bit more of time... Sorry about posting questions about IBM products...but in the end I am using Tomcat to run these... Hope You will understand... Thanks Nishant Awasthi Michael Locasto To: Tomcat Users List [EMAIL PROTECTED][EMAIL PROTECTED] umbia.edu cc: (bcc: Nishant Awasthi) Subject: Re: DB2/servlet errorHelp need 08/02/2002 please 03:07 PM Please respond to Tomcat Users List - Original Message - From: [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Friday, August 02, 2002 2:38 PM Subject: RE: DB2/servlet errorHelp need please I am trying to access servlet via Tomcat as well as WebSphere... If it runs with one it will run with other too... yes, it will, because they both implement the spec; but I think John was just pointing out the irony of using the Tomcat support infrastructure to prop up IBM's product... I'd say visit the IBM site and read all their documentation from the top ;) http://www-3.ibm.com/software/data/db2/java/ Tomcat isn't the issue here. And if a complete fresh install of both drivers and server didn't fix the issues and unless there is a DB2-JDBC expert lurking here I know you've been pulling your hair out for the past few days. Is it possible for you can switch to another database? Regards, Michael -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: DB2/servlet error....Help need please
As much as I would rather not help you debug an IBM product, if the code does not work in either tomcat or your Websphere application, then it isn't a tomcat issue at all, and most likely it isn't even a servlet issue, but a JDBC driver issue. If you are saying that everything works in a servlet context on Websphere, but NOT on tomcat, that would be different, but it sounds like it isn't working at all. Is that correct? John Turner [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 3:13 PM To: Tomcat Users List Subject: Re: DB2/servlet errorHelp need please Sorry Dennis to skip answering the first part... well yes DB2 connectivity works fine outside the servlet context... If I run a simple JAVA file to perform DB2 database data retrieval, it works fine. Its only with servlet it is not working... Nishant Awasthi Corporate Systems Development Progressive Insurance Denis Haskin Denis@HaskinFerTo: Tomcat Users List guson.net [EMAIL PROTECTED] cc: (bcc: Nishant Awasthi) 08/02/2002 02:58Subject: Re: DB2/servlet errorHelp need PM please Please respond to Tomcat Users List Not clear what your response to my first question was: does db2 connectivity work from code that is executed *outside* of a servlet context, that is, from the command line? I would make sure that works first. dwh [EMAIL PROTECTED] wrote: Hello Denis Thanks for your suggestions... I tried reinstalling DB2 but the same problem is coming... If you look here it asks for someFixPack 2 or later. [...] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DB2/servlet error....Help need please
Then it is most likely a classpath problem. You need to make sure the db2 jars are on the classpath for Tomcat. Looks like you're on NT or Win2K, not sure which version of Tomcat... I think your best bet is to modify tomcat.bat and just add all the db2 jars to the classpath there. (Someone please feel free to jump in with a more correct way to do this... and I think the recommended way changed from Tomcat 3 to 4? This has always confused me...) dwh [EMAIL PROTECTED] wrote: Sorry Dennis to skip answering the first part... well yes DB2 connectivity works fine outside the servlet context... If I run a simple JAVA file to perform DB2 database data retrieval, it works fine. Its only with servlet it is not working... -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]