How about this: Just because you specify things like: ResultSet.TYPE_SCROLL_INSENSITIVE ResultSet.CONCUR_UPDATABLE
doesn't mean the driver (or database!) would necessarily support those settings. Oracle of course, ought to, but maybe you have an older driver? In your code, do something like this, and see what it says: [code] cs.execute(); ResultSet rs = null; rs = (ResultSet)cs.getObject(1); // what are the results of these? cs.getResultSetConcurrency(); cs.getResultSetType(); [/code] Also, and I admit I've never used stored procs, but the cs.execute() looks funny. Would this be wrong?: [code] ResultSet rs = cs.executeQuery(); [/code] Just curious about that last one.. > -----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]
