Hello Michael,
I am doing exactly what you said.
I have placed my .zip files which I rename as .jar files and placed them in
c:\jakarta-tomcat-4.0.3\common\lib.
I had all my tomcat environment variables properly set and tomcat runs
fine...
but When I run the java file on c:\jakarta-tomcat-4.0.3\webapps\soap
WEB_INF\classes folder it couldn't find the suitable driver to run my java
file.
So now do you think the drivers are not 100% java and rely on native method
calls to some dll?
What typr of dll should I look for?
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:51 AM Subject: RE: Connection between
TOMCAT and
Please respond to DB2 ???
"Tomcat Users List"
No,
It should be as simple as dropping the xxx.jar file (if it's xxx.zip rename
it to xxx.jar!) into the %TOMCAT_HOME%/common/lib directory.
I would do/verify the following
1) put tomcat in a directory structure where the names of the directories
don't contain spaces
2) make sure TOMCAT_HOME is set
3) make sure CATALINA_HOME=%TOMCAT_HOME%
4) copy xxx.jar to %TOMCAT_HOME%/common/lib
5) open a new DOS window to get the new values of the environment variables
6) change directory to %TOMCAT_HOME%/bin
7) issue c:\..>catalina.bat run
8) if it's still not working it's probably becuase the drivers are not 100%
java and rely on native method calls to some dll.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 9:40 AM
To: Tomcat Users List
Subject: RE: Connection between TOMCAT and DB2 ???
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]>
--
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]>
