RE: DB2 and servlet ??? Help !!!
Is firstnme the name of your column? Or should it be firstname? If
that's an error, there should be a SQLException thrown, but I don't know the
behavior fo DB2...it may just be that you get null back. In any case,
besides printing a stack trace, I would output something to the browser on a
SQLException just so you can see what's going on.
John Turner
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 1:47 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: DB2 and servlet ??? Help !!!
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 adding Servlet
API and syntax in it.
3. It compiles fine.
4. Then from a web page I try to pass one parameter to my servlet.
5. The servlet doesnot retrieve any records from the database which
initially it was bringing
when I wrote simple java file.
Code of my servlet is as:
--
import java.sql.*;
import java.lang.*;
import java.io.*;
public class Ndb2Tomcat{
public static void main(String args[]) {
try{
Class.forName(COM.ibm.db2.jdbc.net.DB2Driver);
}
catch( ClassNotFoundException e2)
{
System.out.println(\nJDBC Driver class not found exception);
}
catch( Exception e)
{
System.out.println(\nDriver class not found exception);
}
try{
Connection con = null;
String url = jdbc:db2://100.3.13.34/SAMPLE;
con = DriverManager.getConnection(url,db2admin, db2pwd);
// retrieve data from the database
System.out.println(Retrieve some data from the database...);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(SELECT * from db2admin.employee
order by firstnme);
System.out.println(Received results:);
while (rs.next())
{
String a = rs.getString(1);
String str = rs.getString(2);
System.out.print( empno= + a);
System.out.print( firstname= + str);
System.out.print(\n);
}
rs.close();
stmt.close();
con.close();
}
catch (SQLException e1)
{
e1.printStackTrace();
}
}
Nishant Awasthi
--
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 and servlet ??? Help !!!
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 am getting simple HTML output ...
I am attaching what
1. I see in browser
2. servlet code
BROWSER OUTPUT
---
paramater passed is 012
Count is0
Found the JDBC driver
Driver is properly loaded and registered
Connection URL is good
Retrieve some data from the database...
Received results:
Count is0
God Please help
--SERVLET CODE-
import java.sql.*;
import java.lang.*;
import java.io.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Ndb2Websphere extends HttpServlet {
Statement stmt;
ResultSet rs;
int count =0;
public void doGet (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
res.setContentType(text/html);
ServletOutputStream out = res.getOutputStream();
String emp = req.getParameter(empnumber);
out.println(paramater passed is +emp + BR);
out.println(BRBRCount is+ count);
try{
Class.forName(COM.ibm.db2.jdbc.net.DB2Driver);
out.println(BRFound the JDBC driver BR);
}
catch( Exception e)
{
//e.printStackTrace();
out.println(\nDriver class not found
exception);
}
finally
{
out.println(BRDriver is properly loaded and
registered );
}
try{
Connection con = null;
String url;
out.println(BRConnection URL is good);
try{
con = DriverManager.getConnection
(jdbc:db2://10.3.13.34/SAMPLE,db2admin,db2pwd);
}
catch( Exception e4)
{
e4.getMessage();
e4.printStackTrace();
}
// retrieve data from the database
out.println(BRRetrieve some data from the
database...);
try{
stmt = con.createStatement();
rs = stmt.executeQuery(SELECT empno from
db2admin.employee);
}
catch( Exception e5)
{
e5.getMessage();
e5.printStackTrace();
}
out.println(BRReceived results:);
try{
if(!rs.next())
{
count = count +1;
String a = rs.getString(1);
out.println( empno is + a );
out.println(BRBRWhile Count is+ count);
}
}
catch( Exception e6)
{
e6.printStackTrace();
}
out.println(BRBRCount is+ count);
rs.close();
stmt.close();
con.close();
}
catch (SQLException e1)
{
e1.getMessage();
e1.printStackTrace();
}
catch( Exception e)
{
e.getMessage();
e.printStackTrace();
}
finally
{
out.println(BRGod Please help);
}
}
public void doPost (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
doGet(req,res);
}
}
Nishant Awasthi
Turner,
JohnTo: 'Tomcat Users List'
JTurner@AAS.[EMAIL PROTECTED]
com cc: (bcc: Nishant Awasthi)
Subject: RE: DB2 and servlet ??? Help !!!
08/01/2002
RE: DB2 and servlet ??? Help !!!
I think you are attempting to output the value if there is nothing in the
result set.
if(!rs.next())
The .next() method will return true if it was able to fetch a row. You are
saying, if there is no row then...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 1:57 PM
To: Tomcat Users List
Subject: RE: DB2 and servlet ??? Help !!!
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 am getting simple HTML output ...
I am attaching what
1. I see in browser
2. servlet code
BROWSER OUTPUT
---
paramater passed is 012
Count is0
Found the JDBC driver
Driver is properly loaded and registered
Connection URL is good
Retrieve some data from the database...
Received results:
Count is0
God Please help
--SERVLET CODE-
import java.sql.*;
import java.lang.*;
import java.io.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Ndb2Websphere extends HttpServlet {
Statement stmt;
ResultSet rs;
int count =0;
public void doGet (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
res.setContentType(text/html);
ServletOutputStream out = res.getOutputStream();
String emp = req.getParameter(empnumber);
out.println(paramater passed is +emp + BR);
out.println(BRBRCount is+ count);
try{
Class.forName(COM.ibm.db2.jdbc.net.DB2Driver);
out.println(BRFound the JDBC driver BR);
}
catch( Exception e)
{
//e.printStackTrace();
out.println(\nDriver class not found
exception);
}
finally
{
out.println(BRDriver is properly loaded and
registered );
}
try{
Connection con = null;
String url;
out.println(BRConnection URL is good);
try{
con = DriverManager.getConnection
(jdbc:db2://10.3.13.34/SAMPLE,db2admin,db2pwd);
}
catch( Exception e4)
{
e4.getMessage();
e4.printStackTrace();
}
// retrieve data from the database
out.println(BRRetrieve some data from the
database...);
try{
stmt = con.createStatement();
rs = stmt.executeQuery(SELECT empno from
db2admin.employee);
}
catch( Exception e5)
{
e5.getMessage();
e5.printStackTrace();
}
out.println(BRReceived results:);
try{
if(!rs.next())
{
count = count +1;
String a = rs.getString(1);
out.println( empno is + a );
out.println(BRBRWhile Count is+ count);
}
}
catch( Exception e6)
{
e6.printStackTrace();
}
out.println(BRBRCount is+ count);
rs.close();
stmt.close();
con.close();
}
catch (SQLException e1)
{
e1.getMessage();
e1.printStackTrace();
}
catch( Exception e)
{
e.getMessage();
e.printStackTrace();
}
finally
{
out.println(BRGod Please help);
}
}
public void doPost (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
doGet(req,res);
}
}
Nishant Awasthi
Turner,
JohnTo: 'Tomcat Users List'
JTurner@AAS.[EMAIL PROTECTED]
com cc: (bcc: Nishant Awasthi
RE: DB2 and servlet ??? Help !!!
Nice catch! You are right. It should be
if(rs.next())
Or better yet...
while(rs.next())
John Turner
[EMAIL PROTECTED]
-Original Message-
From: Wagoner, Mark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 2:02 PM
To: 'Tomcat Users List'
Subject: RE: DB2 and servlet ??? Help !!!
I think you are attempting to output the value if there is nothing in the
result set.
if(!rs.next())
The .next() method will return true if it was able to fetch a row. You are
saying, if there is no row then...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 1:57 PM
To: Tomcat Users List
Subject: RE: DB2 and servlet ??? Help !!!
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 am getting simple HTML output ...
I am attaching what
1. I see in browser
2. servlet code
BROWSER OUTPUT
---
paramater passed is 012
Count is0
Found the JDBC driver
Driver is properly loaded and registered
Connection URL is good
Retrieve some data from the database...
Received results:
Count is0
God Please help
--SERVLET CODE-
import java.sql.*;
import java.lang.*;
import java.io.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Ndb2Websphere extends HttpServlet {
Statement stmt;
ResultSet rs;
int count =0;
public void doGet (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
res.setContentType(text/html);
ServletOutputStream out = res.getOutputStream();
String emp = req.getParameter(empnumber);
out.println(paramater passed is +emp + BR);
out.println(BRBRCount is+ count);
try{
Class.forName(COM.ibm.db2.jdbc.net.DB2Driver);
out.println(BRFound the JDBC driver BR);
}
catch( Exception e)
{
//e.printStackTrace();
out.println(\nDriver class not found
exception);
}
finally
{
out.println(BRDriver is properly loaded and
registered );
}
try{
Connection con = null;
String url;
out.println(BRConnection URL is good);
try{
con = DriverManager.getConnection
(jdbc:db2://10.3.13.34/SAMPLE,db2admin,db2pwd);
}
catch( Exception e4)
{
e4.getMessage();
e4.printStackTrace();
}
// retrieve data from the database
out.println(BRRetrieve some data from the
database...);
try{
stmt = con.createStatement();
rs = stmt.executeQuery(SELECT empno from
db2admin.employee);
}
catch( Exception e5)
{
e5.getMessage();
e5.printStackTrace();
}
out.println(BRReceived results:);
try{
if(!rs.next())
{
count = count +1;
String a = rs.getString(1);
out.println( empno is + a );
out.println(BRBRWhile Count is+ count);
}
}
catch( Exception e6)
{
e6.printStackTrace();
}
out.println(BRBRCount is+ count);
rs.close();
stmt.close();
con.close();
}
catch (SQLException e1)
{
e1.getMessage();
e1.printStackTrace();
}
catch( Exception e)
{
e.getMessage();
e.printStackTrace();
}
finally
{
out.println(BRGod Please help);
}
}
public void doPost (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
doGet(req,res
RE: DB2 and servlet ??? Help !!!
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= 90 firstname= EILEEN
empno= 000160 firstname= ELIZABETH
empno= 000280 firstname= ETHEL
empno= 70 firstname= EVA
empno= 000140 firstname= HEATHER
empno= 60 firstname= IRVING
empno= 000190 firstname= JAMES
empno= 000230 firstname= JAMES
empno= 000340 firstname= JASON
empno= 000220 firstname= JENNIFER
empno= 50 firstname= JOHN
empno= 000290 firstname= JOHN
empno= 000270 firstname= MARIA
empno= 000180 firstname= MARILYN
empno= 000170 firstname= MASATOSHI
empno= 000310 firstname= MAUDE
empno= 20 firstname= MICHAEL
empno= 000300 firstname= PHILIP
empno= 000320 firstname= RAMLAL
empno= 30 firstname= SALLY
empno= 000240 firstname= SALVATORE
empno= 000120 firstname= SEAN
empno= 000260 firstname= SYBIL
empno= 000100 firstname= THEODORE
empno= 000110 firstname= VINCENZO
empno= 000210 firstname= WILLIAM
empno= 000330 firstname= WING
But When I write the same thing in a servlet it brings nothing...
Is there a problem with Connection URL or Connection String...
well I am using the same things in my simple java file
Thanks
Nishant Awasthi
Wagoner, Mark
MWagoner@wildflTo: 'Tomcat Users List'
avors.com [EMAIL PROTECTED]
cc: (bcc: Nishant Awasthi)
08/01/2002 02:02Subject: RE: DB2 and servlet ??? Help
!!!
PM
Please respond
to Tomcat Users
List
I think you are attempting to output the value if there is nothing in the
result set.
if(!rs.next())
The .next() method will return true if it was able to fetch a row. You are
saying, if there is no row then...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 1:57 PM
To: Tomcat Users List
Subject: RE: DB2 and servlet ??? Help !!!
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 am getting simple HTML output ...
I am attaching what
1. I see in browser
2. servlet code
BROWSER OUTPUT
---
paramater passed is 012
Count is0
Found the JDBC driver
Driver is properly loaded and registered
Connection URL is good
Retrieve some data from the database...
Received results:
Count is0
God Please help
--SERVLET CODE-
import java.sql.*;
import java.lang.*;
import java.io.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Ndb2Websphere extends HttpServlet {
Statement stmt;
ResultSet rs;
int count =0;
public void doGet (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
res.setContentType(text/html);
ServletOutputStream out = res.getOutputStream();
String emp = req.getParameter(empnumber);
out.println(paramater passed is +emp + BR);
out.println(BRBRCount is+ count);
try{
Class.forName(COM.ibm.db2.jdbc.net.DB2Driver);
out.println(BRFound the JDBC driver BR);
}
catch( Exception e)
{
//e.printStackTrace();
out.println(\nDriver class not found
exception);
}
finally
{
out.println(BRDriver is properly loaded and
registered );
}
try{
Connection con = null;
String url
RE: DB2 and servlet ??? Help !!!
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
Turner,
JohnTo: 'Tomcat Users List'
JTurner@AAS.[EMAIL PROTECTED]
com cc: (bcc: Nishant Awasthi)
Subject: RE: DB2 and servlet ??? Help !!!
08/01/2002
02:07 PM
Please
respond to
Tomcat Users
List
Nice catch! You are right. It should be
if(rs.next())
Or better yet...
while(rs.next())
John Turner
[EMAIL PROTECTED]
-Original Message-
From: Wagoner, Mark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 2:02 PM
To: 'Tomcat Users List'
Subject: RE: DB2 and servlet ??? Help !!!
I think you are attempting to output the value if there is nothing in the
result set.
if(!rs.next())
The .next() method will return true if it was able to fetch a row. You are
saying, if there is no row then...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 1:57 PM
To: Tomcat Users List
Subject: RE: DB2 and servlet ??? Help !!!
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 am getting simple HTML output ...
I am attaching what
1. I see in browser
2. servlet code
BROWSER OUTPUT
---
paramater passed is 012
Count is0
Found the JDBC driver
Driver is properly loaded and registered
Connection URL is good
Retrieve some data from the database...
Received results:
Count is0
God Please help
--SERVLET CODE-
import java.sql.*;
import java.lang.*;
import java.io.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Ndb2Websphere extends HttpServlet {
Statement stmt;
ResultSet rs;
int count =0;
public void doGet (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
res.setContentType(text/html);
ServletOutputStream out = res.getOutputStream();
String emp = req.getParameter(empnumber);
out.println(paramater passed is +emp + BR);
out.println(BRBRCount is+ count);
try{
Class.forName(COM.ibm.db2.jdbc.net.DB2Driver);
out.println(BRFound the JDBC driver BR);
}
catch( Exception e)
{
//e.printStackTrace();
out.println(\nDriver class not found
exception);
}
finally
{
out.println(BRDriver is properly loaded and
registered );
}
try{
Connection con = null;
String url;
out.println(BRConnection URL is good);
try{
con = DriverManager.getConnection
(jdbc:db2://10.3.13.34/SAMPLE,db2admin,db2pwd);
}
catch( Exception e4)
{
e4.getMessage();
e4.printStackTrace();
}
// retrieve data from the database
out.println(BRRetrieve some data from the
database...);
try{
stmt = con.createStatement();
rs = stmt.executeQuery(SELECT empno from
db2admin.employee);
}
catch( Exception e5
Re: DB2 and servlet ??? Help !!!
Hi,
Assuming this is the SQL you want to submit:
try{
stmt = con.createStatement();
rs = stmt.executeQuery(SELECT empno
from
db2admin.employee);
shouldn't it be
if( rs.next() ){
do{
count++;
out.println( empno is +rs.getString( 1 ) );
}while( rs.next() );
}
or something along those lines? (rather than the !rs.next() )
try{
if(!rs.next())
{
count = count +1;
String a = rs.getString(1);
out.println( empno is + a );
out.println(BRBRWhile Count is+ count);
}
--
To unsubscribe, e-mail: mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: DB2 and servlet ??? Help !!!
Hi,
Your parameter is '012', while it appears that the employeenumbers in your
database are more like:
empno= 000150
quote
BROWSER OUTPUT
---
paramater passed is 012
Count is0
Found the JDBC driver
Driver is properly loaded and registered
Connection URL is good
Retrieve some data from the database...
Received results:
Count is0
God Please help
/quote
Regards,
Michael
- Original Message -
From: [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Thursday, August 01, 2002 2:10 PM
Subject: RE: DB2 and servlet ??? Help !!!
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
Turner,
JohnTo: 'Tomcat Users List'
JTurner@AAS.
[EMAIL PROTECTED]
com cc: (bcc: Nishant Awasthi)
Subject: RE: DB2 and
servlet ??? Help !!!
08/01/2002
02:07 PM
Please
respond to
Tomcat Users
List
Nice catch! You are right. It should be
if(rs.next())
Or better yet...
while(rs.next())
John Turner
[EMAIL PROTECTED]
-Original Message-
From: Wagoner, Mark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 2:02 PM
To: 'Tomcat Users List'
Subject: RE: DB2 and servlet ??? Help !!!
I think you are attempting to output the value if there is nothing in
the
result set.
if(!rs.next())
The .next() method will return true if it was able to fetch a row. You
are
saying, if there is no row then...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 1:57 PM
To: Tomcat Users List
Subject: RE: DB2 and servlet ??? Help !!!
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 am getting simple HTML output ...
I am attaching what
1. I see in browser
2. servlet code
BROWSER OUTPUT
---
paramater passed is 012
Count is0
Found the JDBC driver
Driver is properly loaded and registered
Connection URL is good
Retrieve some data from the database...
Received results:
Count is0
God Please help
--SERVLET CODE-
import java.sql.*;
import java.lang.*;
import java.io.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Ndb2Websphere extends HttpServlet {
Statement stmt;
ResultSet rs;
int count =0;
public void doGet (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
res.setContentType(text/html);
ServletOutputStream out = res.getOutputStream();
String emp = req.getParameter(empnumber);
out.println(paramater passed is +emp + BR);
out.println(BRBRCount is+ count);
try{
Class.forName(COM.ibm.db2.jdbc.net.DB2Driver);
out.println(BRFound the JDBC driver BR);
}
catch( Exception e)
{
//e.printStackTrace();
out.println(\nDriver class not found
exception);
}
finally
{
out.println(BRDriver is properly loaded
and
registered );
}
try{
Connection con = null;
String url;
out.println(BRConnection URL is good);
try{
con = DriverManager.getConnection
(jdbc:db2://10.3.13.34/SAMPLE,db2admin,db2pwd);
}
catch( Exception e4)
{
e4.getMessage();
e4.printStackTrace();
}
// retrieve data from the database
out.println(BRRetrieve some data from the
database...);
try{
stmt = con.createStatement();
rs = stmt.executeQuery(SELECT empno
from
db2admin.employee);
}
catch( Exception e5)
{
e5.getMessage();
e5
RE: DB2 and servlet ??? Help !!!
brings nothing?? There is no SQLException, or nullpointer or something like that??
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 1:08 PM
To: Tomcat Users List
Subject: RE: DB2 and servlet ??? Help !!!
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= 90 firstname= EILEEN
empno= 000160 firstname= ELIZABETH
empno= 000280 firstname= ETHEL
empno= 70 firstname= EVA
empno= 000140 firstname= HEATHER
empno= 60 firstname= IRVING
empno= 000190 firstname= JAMES
empno= 000230 firstname= JAMES
empno= 000340 firstname= JASON
empno= 000220 firstname= JENNIFER
empno= 50 firstname= JOHN
empno= 000290 firstname= JOHN
empno= 000270 firstname= MARIA
empno= 000180 firstname= MARILYN
empno= 000170 firstname= MASATOSHI
empno= 000310 firstname= MAUDE
empno= 20 firstname= MICHAEL
empno= 000300 firstname= PHILIP
empno= 000320 firstname= RAMLAL
empno= 30 firstname= SALLY
empno= 000240 firstname= SALVATORE
empno= 000120 firstname= SEAN
empno= 000260 firstname= SYBIL
empno= 000100 firstname= THEODORE
empno= 000110 firstname= VINCENZO
empno= 000210 firstname= WILLIAM
empno= 000330 firstname= WING
But When I write the same thing in a servlet it brings nothing...
Is there a problem with Connection URL or Connection String...
well I am using the same things in my simple java file
Thanks
--
--
Nishant Awasthi
Wagoner, Mark
MWagoner@wildflTo: 'Tomcat
Users List'
avors.com
[EMAIL PROTECTED]
cc: (bcc:
Nishant Awasthi)
08/01/2002 02:02Subject: RE:
DB2 and servlet ??? Help !!!
PM
Please respond
to Tomcat Users
List
I think you are attempting to output the value if there is
nothing in the
result set.
if(!rs.next())
The .next() method will return true if it was able to fetch a
row. You are
saying, if there is no row then...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 1:57 PM
To: Tomcat Users List
Subject: RE: DB2 and servlet ??? Help !!!
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 am getting simple HTML output ...
I am attaching what
1. I see in browser
2. servlet code
BROWSER OUTPUT
---
paramater passed is 012
Count is0
Found the JDBC driver
Driver is properly loaded and registered
Connection URL is good
Retrieve some data from the database...
Received results:
Count is0
God Please help
--SERVLET CODE-
import java.sql.*;
import java.lang.*;
import java.io.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Ndb2Websphere extends HttpServlet {
Statement stmt;
ResultSet rs;
int count =0;
public void doGet (HttpServletRequest req,
HttpServletResponse res)
throws ServletException, IOException
{
res.setContentType(text/html);
ServletOutputStream out = res.getOutputStream();
String emp = req.getParameter(empnumber);
out.println(paramater passed is +emp + BR);
out.println(BRBRCount is+ count);
try{
Class.forName(COM.ibm.db2.jdbc.net.DB2Driver);
out.println(BRFound the JDBC driver BR);
}
catch( Exception e
Re: DB2 and servlet ??? Help !!!
...and I'm an idiot, because the SQL statement doesn't filter by them, so
it's quite inconsequential, really. :)
rs = stmt.executeQuery(SELECT empno from db2admin.employee);
Michael
- Original Message -
From: Michael Locasto [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Thursday, August 01, 2002 2:16 PM
Subject: Re: DB2 and servlet ??? Help !!!
Hi,
Your parameter is '012', while it appears that the employeenumbers in
your
database are more like:
empno= 000150
quote
BROWSER OUTPUT
---
paramater passed is 012
Count is0
Found the JDBC driver
Driver is properly loaded and registered
Connection URL is good
Retrieve some data from the database...
Received results:
Count is0
God Please help
/quote
Regards,
Michael
- Original Message -
From: [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Thursday, August 01, 2002 2:10 PM
Subject: RE: DB2 and servlet ??? Help !!!
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
Turner,
JohnTo: 'Tomcat Users List'
JTurner@AAS.
[EMAIL PROTECTED]
com cc: (bcc: Nishant
Awasthi)
Subject: RE: DB2 and
servlet ??? Help !!!
08/01/2002
02:07 PM
Please
respond to
Tomcat Users
List
Nice catch! You are right. It should be
if(rs.next())
Or better yet...
while(rs.next())
John Turner
[EMAIL PROTECTED]
-Original Message-
From: Wagoner, Mark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 2:02 PM
To: 'Tomcat Users List'
Subject: RE: DB2 and servlet ??? Help !!!
I think you are attempting to output the value if there is nothing in
the
result set.
if(!rs.next())
The .next() method will return true if it was able to fetch a row.
You
are
saying, if there is no row then...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 1:57 PM
To: Tomcat Users List
Subject: RE: DB2 and servlet ??? Help !!!
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 am getting simple HTML output ...
I am attaching what
1. I see in browser
2. servlet code
BROWSER OUTPUT
---
paramater passed is 012
Count is0
Found the JDBC driver
Driver is properly loaded and registered
Connection URL is good
Retrieve some data from the database...
Received results:
Count is0
God Please help
--SERVLET CODE-
import java.sql.*;
import java.lang.*;
import java.io.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Ndb2Websphere extends HttpServlet {
Statement stmt;
ResultSet rs;
int count =0;
public void doGet (HttpServletRequest req, HttpServletResponse
res)
throws ServletException, IOException
{
res.setContentType(text/html);
ServletOutputStream out = res.getOutputStream();
String emp = req.getParameter(empnumber);
out.println(paramater passed is +emp + BR);
out.println(BRBRCount is+ count);
try{
Class.forName(COM.ibm.db2.jdbc.net.DB2Driver);
out.println(BRFound the JDBC driver BR);
}
catch( Exception e)
{
//e.printStackTrace();
out.println(\nDriver class not found
exception);
}
finally
{
out.println(BRDriver is properly loaded
and
registered );
}
try{
Connection con = null;
String url;
out.println(BRConnection URL is good);
try{
con = DriverManager.getConnection
(jdbc:db2://10.3.13.34/SAMPLE,db2admin,db2pwd);
}
catch( Exception e4
Re: DB2 and servlet ??? Help !!!
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 code..
Thanks
Nishant Awasthi
Corporate Systems Development
Progressive Insurance
Michael
Locasto To: Tomcat Users List
[EMAIL PROTECTED][EMAIL PROTECTED]
umbia.edu cc: (bcc: Nishant Awasthi)
Subject: Re: DB2 and servlet ??? Help
!!!
08/01/2002
02:16 PM
Please respond
to Tomcat
Users List
Hi,
Your parameter is '012', while it appears that the employeenumbers in your
database are more like:
empno= 000150
quote
BROWSER OUTPUT
---
paramater passed is 012
Count is0
Found the JDBC driver
Driver is properly loaded and registered
Connection URL is good
Retrieve some data from the database...
Received results:
Count is0
God Please help
/quote
Regards,
Michael
- Original Message -
From: [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Thursday, August 01, 2002 2:10 PM
Subject: RE: DB2 and servlet ??? Help !!!
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
Turner,
JohnTo: 'Tomcat Users List'
JTurner@AAS.
[EMAIL PROTECTED]
com cc: (bcc: Nishant Awasthi)
Subject: RE: DB2 and
servlet ??? Help !!!
08/01/2002
02:07 PM
Please
respond to
Tomcat Users
List
Nice catch! You are right. It should be
if(rs.next())
Or better yet...
while(rs.next())
John Turner
[EMAIL PROTECTED]
-Original Message-
From: Wagoner, Mark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 2:02 PM
To: 'Tomcat Users List'
Subject: RE: DB2 and servlet ??? Help !!!
I think you are attempting to output the value if there is nothing in
the
result set.
if(!rs.next())
The .next() method will return true if it was able to fetch a row. You
are
saying, if there is no row then...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 1:57 PM
To: Tomcat Users List
Subject: RE: DB2 and servlet ??? Help !!!
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 am getting simple HTML output ...
I am attaching what
1. I see in browser
2. servlet code
BROWSER OUTPUT
---
paramater passed is 012
Count is0
Found the JDBC driver
Driver is properly loaded and registered
Connection URL is good
Retrieve some data from the database...
Received results:
Count is0
God Please help
--SERVLET CODE-
import java.sql.*;
import java.lang.*;
import java.io.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Ndb2Websphere extends HttpServlet {
Statement stmt;
ResultSet rs;
int count =0;
public void doGet (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
res.setContentType(text/html);
ServletOutputStream out = res.getOutputStream
Re: DB2 and servlet ??? Help !!!
Hello
I think I found where the problem is
When I try to print e4.getmessage() while opening my conenction as given
below:
try{
con = DriverManager.getConnection
(jdbc:db2://10.3.13.34/SAMPLE,db2admin,db2pwd);
}
catch( Exception e4)
{
out.println( connection +e4.getMessage
());
e4.printStackTrace();
}
I got something different in the web browser output:
It now says
WEB BROWSER OUTPUT -
[paramater passed is 10
Count is0
Found the JDBC driver
Driver is properly loaded and registered connection [IBM][JDBC Driver]
CLI0621E Unsupported JDBC Server configuration.
Connection URL is good
Retrieve some data from the database... stmt and rs null
Received results:
Count is0
God Please help
Now at least I know that there is some problem with JDBC Driver...
But I don't know why this is hapenning though while compiling simple java
file it
never gave this error...
Nishant Awasthi
Corporate Systems Development
Progressive Insurance
Nishant_Awasthi@progr
essive.com To: Tomcat Users List
[EMAIL PROTECTED]
08/01/2002 02:25 PM cc: (bcc: Nishant Awasthi)
Please respond toSubject: Re: DB2 and servlet ???
Help !!!
Tomcat Users List
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 code..
Thanks
Nishant Awasthi
Corporate Systems Development
Progressive Insurance
Michael
Locasto To: Tomcat Users List
[EMAIL PROTECTED][EMAIL PROTECTED]
umbia.edu cc: (bcc: Nishant Awasthi)
Subject: Re: DB2 and servlet
??? Help !!!
08/01/2002
02:16 PM
Please respond
to Tomcat
Users List
Hi,
Your parameter is '012', while it appears that the employeenumbers in your
database are more like:
empno= 000150
quote
BROWSER OUTPUT
---
paramater passed is 012
Count is0
Found the JDBC driver
Driver is properly loaded and registered
Connection URL is good
Retrieve some data from the database...
Received results:
Count is0
God Please help
/quote
Regards,
Michael
- Original Message -
From: [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Thursday, August 01, 2002 2:10 PM
Subject: RE: DB2 and servlet ??? Help !!!
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
Turner,
JohnTo: 'Tomcat Users List'
JTurner@AAS.
[EMAIL PROTECTED]
com cc: (bcc: Nishant Awasthi)
Subject: RE: DB2 and
servlet ??? Help !!!
08/01/2002
02:07 PM
Please
respond to
Tomcat Users
List
Nice catch! You are right. It should be
if(rs.next())
Or better yet...
while(rs.next())
John Turner
[EMAIL PROTECTED]
-Original Message-
From: Wagoner, Mark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 2:02 PM
To: 'Tomcat Users List'
Subject: RE: DB2 and servlet ??? Help !!!
I think you are attempting to output the value if there is nothing in
the
result set.
if(!rs.next())
The .next() method will return true if it was able to fetch a row. You
are
saying, if there is no row
DB2 and servlet ??? Help !!!
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 adding Servlet
API and syntax in it.
3. It compiles fine.
4. Then from a web page I try to pass one parameter to my servlet.
5. The servlet doesnot retrieve any records from the database which
initially it was bringing
when I wrote simple java file.
Code of my servlet is as:
--
import java.sql.*;
import java.lang.*;
import java.io.*;
public class Ndb2Tomcat{
public static void main(String args[]) {
try{
Class.forName(COM.ibm.db2.jdbc.net.DB2Driver);
}
catch( ClassNotFoundException e2)
{
System.out.println(\nJDBC Driver class not found exception);
}
catch( Exception e)
{
System.out.println(\nDriver class not found exception);
}
try{
Connection con = null;
String url = jdbc:db2://100.3.13.34/SAMPLE;
con = DriverManager.getConnection(url,db2admin, db2pwd);
// retrieve data from the database
System.out.println(Retrieve some data from the database...);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(SELECT * from db2admin.employee
order by firstnme);
System.out.println(Received results:);
while (rs.next())
{
String a = rs.getString(1);
String str = rs.getString(2);
System.out.print( empno= + a);
System.out.print( firstname= + str);
System.out.print(\n);
}
rs.close();
stmt.close();
con.close();
}
catch (SQLException e1)
{
e1.printStackTrace();
}
}
Nishant Awasthi
--
To unsubscribe, e-mail: mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]
