You are viewing a plain text version of this content. The canonical link for it is here.
Posted to soap-user@ws.apache.org by Ni...@progressive.com on 2002/08/01 19:51:34 UTC
DB2 and servlet (Correct servlet file) ??? Help !!!
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. 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.
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("<BR><BR>Count is"+ count);
try{
Class.forName("COM.ibm.db2.jdbc.net.DB2Driver");
out.println("<BR>Found the JDBC driver <BR>");
}
catch( Exception e)
{
// e.printStackTrace();
out.println("\nDriver class not found
exception");
}
finally
{
out.println("<BR>Driver is properly loaded and
registered ");
}
try{
Connection con = null;
String url;
out.println("<BR>Connection URL is good");
try{
con = DriverManager.getConnection
("jdbc:db2://100.3.13.34/SAMPLE","db2admin","db2pwd");
}
catch( Exception e4)
{
e4.getMessage();
e4.printStackTrace();
}
// retrieve data from the database
out.println("<BR>Retrieve 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("<BR>Received results:");
try{
if(!rs.next())
{
count = count +1;
String a = rs.getString(1);
out.println(" empno is " + a );
out.println("<BR><BR>While Count is"+ count);
}
}
catch( Exception e6)
{
e6.printStackTrace();
}
out.println("<BR><BR>Count 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("<BR>I am out");
}
}
public void doPost (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
doGet(req,res);
}
}
------------------------------------------------------------------------------------
Nishant Awasthi
Re: DB2 and servlet (Correct servlet file) ??? Help !!!
Posted by Deva nathan <sd...@yahoo.com>.
Hi nishant,
did u get any errors or can u see the std out's on the
server screen?
if so, send me those log files or error screens
Deva
--- Nishant_Awasthi@progressive.com wrote:
> 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. 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.
> 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("<BR><BR>Count is"+
> count);
> try{
>
> Class.forName("COM.ibm.db2.jdbc.net.DB2Driver");
> out.println("<BR>Found the JDBC driver
> <BR>");
> }
> catch( Exception e)
> {
> // e.printStackTrace();
> out.println("\nDriver
> class not found
> exception");
> }
> finally
> {
> out.println("<BR>Driver
> is properly loaded and
> registered ");
> }
>
> try{
> Connection con = null;
>
>
> String url;
>
> out.println("<BR>Connection
> URL is good");
>
>
> try{
> con = DriverManager.getConnection
>
("jdbc:db2://100.3.13.34/SAMPLE","db2admin","db2pwd");
> }
> catch( Exception e4)
> {
> e4.getMessage();
> e4.printStackTrace();
> }
>
>
> // retrieve data from the database
>
> out.println("<BR>Retrieve
> 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("<BR>Received
> results:");
>
> try{
> if(!rs.next())
> {
>
> count = count +1;
> String a =
> rs.getString(1);
>
> out.println(" empno is "
> + a );
> out.println("<BR><BR>While Count
> is"+ count);
> }
> }
> catch( Exception e6)
> {
>
> e6.printStackTrace();
> }
>
> out.println("<BR><BR>Count 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("<BR>I am out");
> }
> }
> public void doPost (HttpServletRequest req,
> HttpServletResponse res)
> throws ServletException, IOException
> {
> doGet(req,res);
> }
>
>
> }
>
------------------------------------------------------------------------------------
>
> Nishant Awasthi
>
>
>
>
>
> --
> To unsubscribe, e-mail:
> <ma...@xml.apache.org>
> For additional commands, e-mail:
> <ma...@xml.apache.org>
>
__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
--
To unsubscribe, e-mail: <ma...@xml.apache.org>
For additional commands, e-mail: <ma...@xml.apache.org>
Re: DB2 and servlet (Correct servlet file) ??? Help !!!
Posted by Deva nathan <sd...@yahoo.com>.
Hi nishant,
did u get any errors or can u see the std out's on the
server screen?
if so, send me those log files or error screens
Deva
--- Nishant_Awasthi@progressive.com wrote:
> 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. 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.
> 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("<BR><BR>Count is"+
> count);
> try{
>
> Class.forName("COM.ibm.db2.jdbc.net.DB2Driver");
> out.println("<BR>Found the JDBC driver
> <BR>");
> }
> catch( Exception e)
> {
> // e.printStackTrace();
> out.println("\nDriver
> class not found
> exception");
> }
> finally
> {
> out.println("<BR>Driver
> is properly loaded and
> registered ");
> }
>
> try{
> Connection con = null;
>
>
> String url;
>
> out.println("<BR>Connection
> URL is good");
>
>
> try{
> con = DriverManager.getConnection
>
("jdbc:db2://100.3.13.34/SAMPLE","db2admin","db2pwd");
> }
> catch( Exception e4)
> {
> e4.getMessage();
> e4.printStackTrace();
> }
>
>
> // retrieve data from the database
>
> out.println("<BR>Retrieve
> 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("<BR>Received
> results:");
>
> try{
> if(!rs.next())
> {
>
> count = count +1;
> String a =
> rs.getString(1);
>
> out.println(" empno is "
> + a );
> out.println("<BR><BR>While Count
> is"+ count);
> }
> }
> catch( Exception e6)
> {
>
> e6.printStackTrace();
> }
>
> out.println("<BR><BR>Count 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("<BR>I am out");
> }
> }
> public void doPost (HttpServletRequest req,
> HttpServletResponse res)
> throws ServletException, IOException
> {
> doGet(req,res);
> }
>
>
> }
>
------------------------------------------------------------------------------------
>
> Nishant Awasthi
>
>
>
>
>
> --
> To unsubscribe, e-mail:
> <ma...@xml.apache.org>
> For additional commands, e-mail:
> <ma...@xml.apache.org>
>
__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com