Thanks. But I know for the fact that there should have data in the ResultSet. If I remove the definition for scrollability (is it a word?) and remove the rs.last() method, I get data back.
Furthermore, if I do the same thing for stored procedure in SQL Server, it works. And if I do the same thing on regular Statement for Oracle database like this: Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); It works as well. That makes me think it has something to do with calling an Oracle stored procedure. But I just cannot figure that out where it goes wrong. Thank you very much. ----- Original Message ----- From: "mike jackson" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" <[EMAIL PROTECTED]> Sent: Friday, October 17, 2003 03:48 PM Subject: RE: Java/JSP/Servlet Programmer [off topic] You might have to call rs.next() first before the rs.last(). I know that prior to getting a ResultSetMetaData object you have to call the rs.next(). Could be the rs.last() requires the same thing (in case there's no records returned). But that's just a guess. --mikej -=------ mike jackson [EMAIL PROTECTED] > -----Original Message----- > From: epyonne [mailto:[EMAIL PROTECTED] > Sent: Friday, October 17, 2003 12: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]