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= 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> > <[EMAIL PROTECTED]> > 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: [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("<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. > <[EMAIL PROTECTED]> > > 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 > [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]> > > > > > > -- > 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]>
