tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Durham David Cntr 805CSS/SCBE" <David.Durh...@scott.af.mil>
Subject RE: DB2 and servlet ??? Help !!!
Date Thu, 01 Aug 2002 18:12:04 GMT
brings nothing??  There is no SQLException, or nullpointer or something like that??  

> -----Original Message-----
> From: Nishant_Awasthi@progressive.com
> [mailto:Nishant_Awasthi@progressive.com]
> 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= 000010 firstname= CHRISTINE
>  empno= 000250 firstname= DANIEL
>  empno= 000200 firstname= DAVID
>  empno= 000130 firstname= DOLORES
>  empno= 000090 firstname= EILEEN
>  empno= 000160 firstname= ELIZABETH
>  empno= 000280 firstname= ETHEL
>  empno= 000070 firstname= EVA
>  empno= 000140 firstname= HEATHER
>  empno= 000060 firstname= IRVING
>  empno= 000190 firstname= JAMES
>  empno= 000230 firstname= JAMES
>  empno= 000340 firstname= JASON
>  empno= 000220 firstname= JENNIFER
>  empno= 000050 firstname= JOHN
>  empno= 000290 firstname= JOHN
>  empno= 000270 firstname= MARIA
>  empno= 000180 firstname= MARILYN
>  empno= 000170 firstname= MASATOSHI
>  empno= 000310 firstname= MAUDE
>  empno= 000020 firstname= MICHAEL
>  empno= 000300 firstname= PHILIP
>  empno= 000320 firstname= RAMLAL
>  empno= 000030 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@wildfl        To:     'Tomcat 
> Users List'                       
>                     avors.com>              
> <tomcat-user@jakarta.apache.org>                  
>                                             cc:     (bcc: 
> Nishant Awasthi)                    
>                     08/01/2002 02:02        Subject:     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: Nishant_Awasthi@progressive.com
> [mailto:Nishant_Awasthi@progressive.com]
> 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("<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://10.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>God Please help");
>                 }
>       }
>     public void doPost (HttpServletRequest req, 
> HttpServletResponse res)
>     throws ServletException, IOException
>     {
>         doGet(req,res);
>     }
> 
> 
> }
> --------------------------------------------------------------
> --------------
> 
> --------
> 
> Nishant Awasthi
> 
> 
> 
> 
> 
> 
> 
> 
>                     "Turner,
> 
>                     John"                To:     'Tomcat Users List'
> 
>                     <JTurner@AAS.        
> <tomcat-user@jakarta.apache.org>
> 
>                     com>                 cc:     (bcc: 
> Nishant Awasthi)
> 
>                                          Subject:     RE: DB2 
> and servlet
> ??? Help !!!
>                     08/01/2002
> 
>                     01:50 PM
> 
>                     Please
> 
>                     respond to
> 
>                     "Tomcat Users
> 
>                     List"
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 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
> jturner@NOSPAM.aas.com
> 
> -----Original Message-----
> From: Nishant_Awasthi@progressive.com
> [mailto:Nishant_Awasthi@progressive.com]
> Sent: Thursday, August 01, 2002 1:47 PM
> To: soap-user@xml.apache.org; tomcat-user@jakarta.apache.org;
> tomcat-dev@jakarta.apache.org
> 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:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail:
> <mailto:tomcat-user-help@jakarta.apache.org>
> 
> --
> To unsubscribe, e-mail:   <
> mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: <
> mailto:tomcat-user-help@jakarta.apache.org>
> 
> 
> 
> 
> 
> --
> To unsubscribe, e-mail:
> <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail:
> <mailto:tomcat-user-help@jakarta.apache.org>
> 
> --
> To unsubscribe, e-mail:   <
> mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: <
> mailto:tomcat-user-help@jakarta.apache.org>
> 
> 
> 
> 
> 
> --
> To unsubscribe, e-mail:   
<mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>


--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>


Mime
View raw message