You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Ni...@progressive.com on 2002/08/02 19:33:32 UTC

Re: DB2/servlet error....Help need please

Can anyone help me Please !!!
Thanks
------------------------------------------------------------------------------------

Nishant Awasthi








                                                                                                   
                    Nishant_Awasthi@progr                                                          
                    essive.com                   To:     soap-user@xml.apache.org,                 
                                                 tomcat-user@jakarta.apache.org,                   
                    08/02/2002 11:20 AM          tomcat-dev@jakarta.apache.org                     
                    Please respond to            cc:     (bcc: Nishant Awasthi)                    
                    "Tomcat Users List"          Subject:     DB2/servlet error....Can 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:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <
mailto:tomcat-user-help@jakarta.apache.org>





--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


Re: DB2/servlet error....Help need please

Posted by Denis Haskin <De...@HaskinFerguson.net>.
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


Nishant_Awasthi@progressive.com 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:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>