Mike

I don't understand by what you mean by 100% java native. But yes I am sure
that if I run my java code by placing my java file in C:\Program
Files\SQLLIB\bin directory
it works absolutely fine hence I can say it is java native to DB2
directory.

But I cannot make the same file run from outside the DB2 realm...that is
when I place same java file in TOMCAT_HOME directory it doesnot find the
driver...

DO I need to make changes in my server.xml file in %TOMCAT_HOME%\conf and
add some context
ot do I need to add some <Realm> information ???

Thanks
------------------------------------------------------------------------------------

Nishant Awasthi
Corporate Systems Development
Progressive Insurance





                                                                                       
          
                    "Michael Remijan"                                                  
          
                    <Michael.Remijan@so        To:     "Tomcat Users List"             
          
                    locup.com>                 <[EMAIL PROTECTED]>        
          
                                               cc:     (bcc: Nishant Awasthi)          
          
                    07/31/2002 10:13 AM        Subject:     RE: Connection between 
TOMCAT and    
                    Please respond to          DB2 ???                                 
          
                    "Tomcat Users List"                                                
          
                                                                                       
          
                                                                                       
          





...

Here's a thought.  are the drivers for DB2 100% java native.  I'm
remembering a problem a colleage of mind had using the the jdbc drivers for
a database named Progress.  It turns out they were not 100% java and relied
on calls to native libraries.  If you're running on windows it'll be a dll
or something.

<mike/>

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 8:46 AM
To: Tomcat Users List
Subject: RE: Connection between TOMCAT and DB2 ???



Hello John,

It was a nice thinking but I didn't worked.
It is not finding the driver even now...I tried printing the
classpath..though it shows the
all 3 ".jar" files included but it is working only in %SQLLIB%\bin

directory that is if I try to run my file by keeping it in %SQLLIB%\bin
directory
it worked fine and retieve resultsets from database but
not from TOMCAT_HOME directory...

Any other tries..?
------------------------------------------------------------------------------------


Nishant Awasthi
Corporate Systems Development
Progressive Insurance






                    "Turner,
                    John"                To:     'Tomcat Users List'
                    <JTurner@AAS.        <[EMAIL PROTECTED]>
                    com>                 cc:     (bcc: Nishant Awasthi)
                                         Subject:     RE: Connection
between TOMCAT and
                    07/31/2002           DB2 ???
                    09:27 AM
                    Please
                    respond to
                    "Tomcat Users
                    List"








Try renaming your .zip files to .jar files.  Just change the extension from
.zip to .jar without changing the files themselves.

John Turner
[EMAIL PROTECTED]

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 9:22 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Connection between TOMCAT and DB2 ???


Hello everyone...
thanks for showing interest in the list and to make it grow...

I have a situation here.
I am using tomcat 4.0.3 and jdk 1.3.1_04. I want to write a soap
service which will bring the resultset from IBM DB2 database.

Before implementing soap I am writing a simple Java "Ndb2servlet.java" file
inside
%TOMCAT_HOME%\webapps\soap\WEB-INF\classes

Now it compile fine but when I try to run it it says:

>>>>> COMPILING >>C:
\jakarta-tomcat-4.0.4\webapps\soap\WEB-INF\classes>javac Ndb2servlet.java

>>>>> RUNNING >>C:\jakarta-tomcat-4.0.4\webapps\soap\WEB-INF\classes>java
Ndb2servlet
SQL Exception:  No suitable driver

I have tried to put db2java.zip, runtime.zip and sqlj.zip in %TOMCAT_HOME%
\common\lib and
and also included in system classpath  then restarted TOMCAT but still it
couldn't find driver.

DO I need to do something special for my JAVA file in tomcat to find
"DB2driver"

Please help....
thanks

----------------------------------------------------------------------------


--------

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





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

Reply via email to