Re: JDBC

[Brett Delia]

Does this require a certain flavor of JDK?  I am currently using 1.3.1 and I get this error.   /servlet/WebSQL;jsessionid=2545531012499240335: null java.lang.AbstractMethodError at WebSQL.printResultSet(WebSQL.java:226) at WebSQL.doGet(WebSQL.java:484) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1416) at allaire.jrun.session.JRunSessionService.service(../session/JRunSessionService.java:1082) at allaire.jrun.servlet.JRunSE.runServlet(../servlet/JRunSE.java:1270) at allaire.jrun.servlet.JRunNamedDispatcher.forward(../servlet/JRunNamedDispatcher.java:39) at allaire.jrun.servlet.Invoker.service(../servlet/Invoker.java:84) at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1416) at allaire.jrun.session.JRunSessionService.service(../session/JRunSessionService.java:1082) at allaire.jrun.servlet.JRunSE.runServlet(../servlet/JRunSE.java:1270) at allaire.jrun.servlet.JRunRequestDispatcher.forward(../servlet/JRunRequestDispatcher.java:89) at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1552) at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1542) at allaire.jrun.servlet.JvmContext.dispatch(../servlet/JvmContext.java:364) at allaire.jrun.jrpp.ProxyEndpoint.run(../jrpp/ProxyEndpoint.java:388) at allaire.jrun.ThreadPool.run(../ThreadPool.java:272) at allaire.jrun.WorkerThread.run(../WorkerThread.java:75)   -- Brett M. Delia | Software Engineer Nine Dots 503.228.4008 ext.173 Portland . Irvine . San Francisco . Toronto [EMAIL PROTECTED] It is there, right where you are; If you seek it, obviously you do not see it. -Muso Kokushi -----Original Message----- From: Surya Narayana [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 10:34 PM To: [EMAIL PROTECTED] Subject: Re: JDBC Dear Rama,      To know the number of records returned, use the following two lines of code.      rs.last(); //moves the control to the last record    int count = rs.getRow(); //gets the row count   Thanks and Regards, Surya. ----- Original Message ----- From: Rama To: [EMAIL PROTECTED] Sent: Thursday, January 31, 2002 11:53 AM Subject: JDBC Hi, I wonder how to know if the query returned is empty or not. I use this code: ResultSet rs = stmt.executeQuery("SELECT * FROM user"); if (rs.next()) {   while (rs.next()) {     out.println("username " + rs.getString("username"));   } } else {   out.println("No record found"); } but it always skips the first line of the record. 1. How to know if the query returned is empty or not. 2. Also, is there any way to know how many records returned? Thank you, Rama _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at:  http://archives.java.sun.com/jsp-interest.html  http://java.sun.com/products/jsp/faq.html  http://www.esperanto.org.nz/jsp/jspfaq.jsp  http://www.jguru.com/faq/index.jsp  http://www.jspinsider.com