Good observation Peter...
Actually I missed looking at whether it is JRE or J2SE
Yeah I think is he downloads TDK it will work fine...
Peter Davison
Have you first uninstalled JRE or not here are the steps you should follow:
1. Uninstall JRE
2. Uninstall tomcat
3. Install J2SE
4. Do proper classpath and path settings for the J2SE
5. Install Tomcat after you have properly set JAVA_HOME to new jdk1.3.0_04
you have mentioned
6. Set the
Thanks Mark...Just now I successfully run my first SOAP-DB2 service...
Nishant Awasthi
Corporate Systems Development
Progressive Insurance
Can anyone help me Please !!!
Thanks
Nishant Awasthi
Nishant_Awasthi@progr
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 -
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
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...
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
Can anyone send me a sample code for a simple SOAP
call in which I can have some DB2 database activity
to be performed by webservice and it bring some
information back to the client.
1. Client sends the parameters to the web service, say Name of an employee
2. Web Service will take the
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
Richard
Correct me if I am undertanding it correctly.
If the DB2 server is running on (default port 5) cline tmachine
then in my client application, I need not specify the port number.
But I may or maynot use the port number (5) in my Connection URL
string.
Now When I use
String url =
Hello John
firstnme is the correct column name...
What bugs me is if you see my servlet code which I am again attaching...
I try to put try and ctach every where possible so that
I can at least printStackTrace() .
But to my surprise...I am not getting any exception...or stack trace...
instead I
Hello Mark,
Believe me there are rows in the table when I run the simple JAVA-DB2
file it retrieve
Received results:
empno= 000150 firstname= BRUCE
empno= 10 firstname= CHRISTINE
empno= 000250 firstname= DANIEL
empno= 000200 firstname= DAVID
empno= 000130 firstname= DOLORES
empno=
I tried both ways
while(rs.next())
and
if(!rs.next())
both gives the same web browser output
Nishant Awasthi
Corporate Systems Development
Progressive Insurance
Please don't look at the parameters
As I am not using parameter in my query...
Right now I am just trying to run a very simple query...
Parameter has been output just for testing if servlet is taking wirte
parameter vvalues or not...
Parameters are not being used anywhere in the whole servlet
Corporate Systems Development
Progressive Insurance
Nishant_Awasthi@progr
essive.com
Hello everyone...
I am trying to connect the run a simple servlet to retrieve the
query results from DB2 database.
1. Before writing a servlet, I wrote a simple java file and was successful
in retrieving the
contents from DB2 UDB.
2. Then I just converted the same JAVA file into servlet by
Hello everyone...
Sorry In my prevous file I attach wrong file in the body...
I am trying to connect the run a simple servlet to retrieve the
query results from DB2 database.
1. Before writing a servlet, I wrote a simple java file and was successful
in retrieving the
contents from DB2 UDB.
2.
Can you send me more details what exactly you see...in error message?
Nishant Awasthi
Corporate Systems Development
Progressive Insurance
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
Hello Mark,
I am currently using COM.ibm.db2.jdbc.app.DB2Driver driver to run my
simple
java program for establishing DB2-Tomcat connectivity.
I tried changing it to COM.ibm.db2.jdbc.net.DB2Driver still it says,
No suitable driver
I think my tomcat is not able to find out db2java.zip file
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
Hello Mark,
Both of the servers
DB2 JDBC Applet Server and
DB2 JDBC Applet Server - Control Center are running...
Nishant Awasthi
Corporate Systems Development
Progressive Insurance
Hello Ralph
Thanks for your suggestion.
I tried putting runtime.jar, db2java.jar and sqlj.jar files in
%JAVA_HOME%/jre/lib/ext directory.
and also in %TOMCAT_HOME%/common/lib directory and restarted TOMCAT but
it still couldn't find the driver when I try to run the compiled java file
it says
No
Hello Mark
I think you are right Mark when You say that, it is do finding the
db2jaa.jar/zip file
but question is why it is not getting COM.ibm.db2.jdbc.app.DB2Driver
which is placed in db2java.zip/db2java.zip.jar file.
This is the source code of the file I am trying to run undr tomcat
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
Hello John
This is the source code of the file I am trying to run under tomcat
Is there any problem with connection string ???
It is working fine in %SQLLIB%\bin directory
Here's the code
import java.sql.*;
import java.lang.*;
import java.io.*;
public class Ndb2servlet{
public static
Hello Damien,
I have already converted my .zip files to.jar files.
I think as majority of the responses says..there is some problem with the
connection string and driver URL I should look into it..
Any suggestions on this
Class.forName(COM.ibm.db2.jdbc.net.DB2Driver);
String url =
Mark
I think you have sent an absolutely needed links...
It seems as the link suggests, it is the problem with
jdbc:db2:sample
I need something like
jdbc:db2://n5533030:5/sample where
my database is sample
and port (actually I don't know what is my prt but I picked ): 5
To find the
Hello John,
I think you have sent an absolutely needed links...
It seems as the link suggests, it is the problem with
jdbc:db2:sample
I need something like
jdbc:db2://n5533030:5/sample where
my database is sample
and port (actually I don't know what is my prt but I picked ): 5
To find
Hello George,
I tried both the URLs..
COM.ibm.db2.jdbc.app.DB2Driver
COM.ibm.db2.jdbc.net.DB2Driver
Nishant Awasthi
Corporate Systems Development
Progressive Insurance
Hello Ralph,
I already have the suitable db2jdbc.dll file in my %SQLLIB%\lib directory
It also have all the suitable .jar files in its place.
What I think is getting qorng is the URL connection string..
String url = jdbc:db2:sample ;
I also tried writing follwing in place of above setting:
Hello all,
I finally resolved the problem...
Problem lied in the as everyone mentioned Connection URL
Earlier I was using url = jdbc:db2:sample
Then I changed it to follwing
and everything worked fine...
String url = jdbc:db2://xxx.xxx.xxx.xxx/SAMPLE;
where xxx.xxx.xxx.xxx is the IP address
Hello Richard..
Now I just tested the all lowercase (sample) and all uppercase (SAMPLE)
name of database
and it works or both the cases.
It showed some strange behaviours..sometime back.
AN hour ago I tried to compile using all lowercases and it didn't find the
database.
then I opted for all
Thanks Richard for your help,
Yes, just now I managed to connect DB2 to Tomcat and using simple java file
able to retrieve the values from sample database.
But I have a question for you.
while defining my Connection URL I never specified a port number.
String url =
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
friendly error messages checkbox is already disabled Juha...
Thanks for persistently..helping me...
Let's hope it would work fine soon...
Nishant Awasthi
Corporate Systems Development
Progressive Insurance
I did update it to tomcat 4.0.4 but again the same error is occurring...
its really strange...Anyways thanks for your help,
Nishant Awasthi
Corporate Systems Development
Progressive Insurance
Hello Guys...
Unable to run JSP examples using tomcat 4.0.3. Localhost_log file has been
written vbelow.
Can some kind soul help me out why this problem is being occurred...
--ERROR-
2002-07-29 10:54:16
Hello Juha
Thanks for replying.
I tried to uninstal tomcat 4.0.3. Restart my computer. Installed Tomcat
4.0.3 again. Restart my computer
and when I run Tomcat again. It has this Internal Server Problem.
I don't know why?
tHEN i UNISTALL IT AGAIN AND IN DIFFERENT DIRECTORY INSTALLED TOMCAT 4.0.4
I am using tomcat 4.0.3 version.
Everything was working fine until I restarted my computer and now I cannot
have my JSP examples
of tomcat running.
Before restarting my computer JSP, SOAP examples and my own examples were
running
great. Now when I
try to run JSP example at http://localhost:8080
Hello Ashish
I have the same problem. I have created a SOAP client servlet.
When I try to run for first time everything is at place.
But when I try to change and recompile my servlet it doesnot work.
It picks up the earlier servlet code from somewhere.
When I tried to use the same thing with
Hello Anthony,
FYI, Well I am trying to run servlet/beans with tomcat and place new class
files
at the specific classpath its working fine for me...
I neednot restart the tomcat everytime.I am using tomcat 4.0.3.
I haven't changed anything in the configuration files...
I didn't change anything jus placed all my class file in
%TOMCAT_HOME%/webapps/examples/servlets/WEB-INF/classes directory
The context path for /example is already set in the defualt server.conf
file.
I didn't change anything...its running fine..
You need to use IIS 5.0 to run ASP pages...
Nishant Awasthi
Corporate Systems Development
Progressive Insurance
ASP files only run using a server that supports Active
Server Pages. This include Microsoft Internet Information
Server and for Windows 95/98 Microsoft Personal Web Server
Hello Bruce,..
I don't know about TRU64 systems but...The problem you are getting might
be because of the ports...
Some other applications my be using the same port check typing netstat /an
command on dos prompt...
the other case can be please include tools.jar file in your %TOMCAT_HOME%
Hello Murugan
I ahve installed tomcat 4.0.4 and it is running fine here:
All you need to set is JAVA_HOME and CATALINA_HOME.
You need not worry about any of the other files like setenv.bat or
startup.bat or catalina.bat.
Actually if you want you can edit catalina.bat which contains you
Sunit j2RE1.4 is just the runtime environment for java.
You need to install J2SDK 1.4 from
http://java.sun.com/j2se/1.4/download.html
From this link download SDK and not JRE version
that is the second column in the table not the first one...
tell me if you have some problems...
Hello everyone,
I am new to SOAP and Tomcat and I am continuously getting this problem:
Fault Code = SOAP-ENV:Server.BadTargetObjectURI
Fault String = Unable to resolve target object: Hello
As per I have read so far it is due to the classpath settings.
I have all my .java and .class files(
Hello eneryone...
I have problem that have been discussed many times but I couldn't find the
answer to it.
I am trying to run SOAP on tomcat.
I am using
Apache SOAP 2.0
51 matches
Mail list logo