I used to work in an Oracle/Sun shop, so this really tickled my memory. Does your query break any of the rules on this page ? : http://sales.esicom.com/sales/oracle/java.816/a81354/resltse2.htm
> -----Original Message----- > From: Mike Curwen [mailto:[EMAIL PROTECTED] > Sent: Friday, October 17, 2003 4:16 PM > To: 'Tomcat Users List' > Subject: RE: Java/JSP/Servlet Programmer [off topic] > > > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]