Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org Received: (qmail 26380 invoked from network); 1 Aug 2002 18:35:17 -0000 Received: from unknown (HELO nagoya.betaversion.org) (192.18.49.131) by daedalus.apache.org with SMTP; 1 Aug 2002 18:35:17 -0000 Received: (qmail 3503 invoked by uid 97); 1 Aug 2002 18:35:01 -0000 Delivered-To: qmlist-jakarta-archive-tomcat-user@jakarta.apache.org Received: (qmail 3466 invoked by uid 97); 1 Aug 2002 18:35:00 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 3454 invoked by uid 98); 1 Aug 2002 18:34:59 -0000 X-Antivirus: nagoya (v4198 created Apr 24 2002) Subject: Re: DB2 and servlet ??? Help !!! To: "Tomcat Users List" X-Mailer: Lotus Notes Release 5.0.6a January 17, 2001 Message-ID: From: Nishant_Awasthi@progressive.com Date: Thu, 1 Aug 2002 14:34:31 -0400 X-MIMETrack: Serialize by Router on Camp-SMTP-01/Progressive(Release 5.0.6a |January 17, 2001) at 08/01/2002 02:34:36 PM MIME-Version: 1.0 Content-type: text/plain; charset="us-ascii" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N 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 000010 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" 08/01/2002 02:25 PM cc: (bcc: Nishant Awasthi) Please respond to Subject: 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" 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 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 Regards, Michael ----- Original Message ----- From: To: "Tomcat Users List" 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, > John" To: 'Tomcat Users List' > > 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 > jturner@NOSPAM.aas.com > > -----Original Message----- > From: Wagoner, Mark [mailto:MWagoner@wildflavors.com] > 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: 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 +"
"); > out.println("

Count is"+ count); > try{ > Class.forName("COM.ibm.db2.jdbc.net.DB2Driver"); > out.println("
Found the JDBC driver
"); > } > catch( Exception e) > { > // e.printStackTrace(); > out.println("\nDriver class not found > exception"); > } > finally > { > out.println("
Driver is properly loaded and > registered "); > } > > try{ > Connection con = null; > > > String url; > > out.println("
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("
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("
Received results:"); > > try{ > if(!rs.next()) > { > count = count +1; > String a = rs.getString(1); > > out.println(" empno is " + a ); > out.println("

While Count is"+ count); > } > } > catch( Exception e6) > { > e6.printStackTrace(); > } > out.println("

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("
God Please help"); > } > } > public void doPost (HttpServletRequest req, HttpServletResponse res) > throws ServletException, IOException > { > doGet(req,res); > } > > > } > ------------------------------------------------------------------------ ---- > > -------- > > Nishant Awasthi > > > > > > > > > "Turner, > > John" To: 'Tomcat Users List' > > > > 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: > > For additional commands, e-mail: > > > -- > 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: > > For additional commands, e-mail: > > > -- > To unsubscribe, e-mail: > > For additional commands, e-mail: > > > -- > 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: > For additional commands, e-mail: -- 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: For additional commands, e-mail: