My mistake. After reading Justin's reply I looked back at my code. I am using getRow from ResultSet.
-----Original Message----- From: epyonne [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:54 PM To: Tomcat Users List Subject: Re: Java/JSP/Servlet Programmer [off topic] Thanks for the reply. I searched for ResultSetMetaData in JavaDoc, and there is no method to get row count. It only has column count. Did I miss something? Please explain. Thank you very much. ----- Original Message ----- From: "Brendle, Douglas A." <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Friday, October 17, 2003 03:45 PM Subject: RE: Java/JSP/Servlet Programmer [off topic] Have you tried using ResultetMetaData to get row count BEFORE you process the Resultset? -----Original Message----- From: epyonne [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:44 PM To: Tomcat Users List Subject: Re: Java/JSP/Servlet Programmer [off topic] Pardon me that it is off topics.... Speaking about re-usable ResultSet, I am having a little problem with a ResultSet and I cannot find the solution. I have a routine in my servlet to call an Oracle stored procedure, using CallableStatement. Everything works fine. Then, I want to get the row count of the ResultSet. I can do that by using the rs.last() method. However, that requires the ResultSet to be scrollable. So I change the code accordingly. After that, I keep getting the error message of: SQLException: Invalid operation of forward only resultset: last I can't figure out why. I thought I have defined the ResultSet to be scrollable already. The following is the snippets: //code begins------------------------------ DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); String url = "jdbc:oracle:thin:@.........."; conn = DriverManager.getConnection(url,........); String plsql = "begin <my stored procedure>(?,?,?); end;"; CallableStatement cs = conn.prepareCall(plsql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); cs.registerOutParameter(1, OracleTypes.CURSOR); cs.setString(2, InputParam1); cs.registerOutParameter(3, Types.INTEGER); cs.execute(); ResultSet rs = null; rs = (ResultSet)cs.getObject(1); rs.last(); //code ends------------------------------------ Any help will be very much appreciated. ----- Original Message ----- From: "Mike Curwen" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" <[EMAIL PROTECTED]> Sent: Friday, October 17, 2003 03:12 PM Subject: RE: Java/JSP/Servlet Programmer > I would send y'all my resume, but ever since the humiliation of the > re-usable ResultSet, I'm sure I'm one of those that can't walk yet. ;) > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Friday, October 17, 2003 3:08 PM > > To: Tomcat Users List > > Subject: RE: Java/JSP/Servlet Programmer > > > > > > I agree. I'm getting funds to hire a new person and I dread it. I've > > screened a lot of people on the last time I hired someone an > > still got a > > lemon. Lot's of people talk to talk, but can't even walk yet. > > > > > > Thank You, > > > > Justin A. Stanczak > > Web Manager > > Shake Learning Resource Center > > Vincennes University > > (812)888-5813 > > > > > > > > > > "Hart, Justin" <[EMAIL PROTECTED]> > > 10/17/2003 03:00 PM > > Please respond to "Tomcat Users List" > > > > > > To: "Tomcat Users List" <[EMAIL PROTECTED]> > > cc: > > Subject: RE: Java/JSP/Servlet Programmer > > > > > > That's what I've found. The market is full of tech workers, but that > > doesn't mean that they're a programmer, or as familiar with > > technology X > > (for position Y) as they should be. I went to a job fair a > > couple years > > ago for 4 job opennings, 2 for programmers. 2 for techs. > > 1000 people > > showed up, and I spoke with only 4-5 that I really thought > > qualified for > > the programming jobs or had credentials that showed that they > > qualified > > for the job. > > > > -----Original Message----- > > From: Ruben Gamez [mailto:[EMAIL PROTECTED] > > Sent: Friday, October 17, 2003 3:57 PM > > To: Tomcat Users List > > Subject: RE: Java/JSP/Servlet Programmer > > > > > > I would think so, but it's true. I've gotten several people > > that interview well, but none that can pass a couple of > > simple tests (I consider them simple). > > > > -----Original Message----- > > From: epyonne [mailto:[EMAIL PROTECTED] > > Sent: Friday, October 17, 2003 3:55 PM > > To: Tomcat Users List > > Subject: Re: Java/JSP/Servlet Programmer > > > > Cannot find anyone?!?!?! It is rather hard to believe based > > on current job market. > > > > > > ----- Original Message ----- > > From: "Ruben Gamez" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, October 17, 2003 02:33 PM > > Subject: Java/JSP/Servlet Programmer > > > > > > I'm looking for an experienced JSP/Servlet programmer located > > in our area. We're located in West Palm Beach, FL. We've > > tried posting the Job on Monster, and looking for candidates > > on there, but still cannot find someone that can do the job. > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]