tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "mike jackson" <mjack...@cdi-hq.com>
Subject RE: Java/JSP/Servlet Programmer [off topic]
Date Fri, 17 Oct 2003 21:18:42 GMT
I didn't think you could do that with stored procedures.  They usually
require an exec/begin/end to operate.  You could probably do that in a
stored procedure however (and have it return the row count).

--mikej
-=------
mike jackson
mjackson@cdi-hq.com



> -----Original Message-----
> From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> Sent: Friday, October 17, 2003 12:54 PM
> To: Tomcat Users List
> Subject: RE: Java/JSP/Servlet Programmer [off topic]
> 
> 
> Howdy,
> I too don't think ResultSetMetaData has row count.
> 
> There's also the hackish but usually OK approach which wraps the SQL
> query in select count(*).  This has the advantage of giving you just the
> row count without the whole (potentially huge) result set.  Something
> like:
> 
> int getRowCount(Connection connection, String sql) {
>   String countSql = "select count(*) from (" + sql + ")";
>   Statement stmt = connection.createStatement();
>   ResultSet rs = stmt.executeQuery(countSql);
>   rs.next();
>   return rs.getInt(1);
> }
> 
> Or something like that...
> 
> Yoav Shapira
> Millennium ChemInformatics
> 
> 
> >-----Original Message-----
> >From: Hart, Justin [mailto:JHart@sfa.com]
> >Sent: Friday, October 17, 2003 4:49 PM
> >To: Tomcat Users List
> >Subject: RE: Java/JSP/Servlet Programmer [off topic]
> >
> >I thought that resultsetmetadata had column count, but not row count.
> If
> >it has row count, then I am distinctly interested.
> >-----Original Message-----
> >From: Brendle, Douglas A. [mailto:BrendleDA@c-b.com]
> >Sent: Friday, October 17, 2003 4:45 PM
> >To: Tomcat Users List
> >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:epyonneNOSPAM@hotmail.com]
> >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" <gb_dev@gb-im.com>
> >To: "'Tomcat Users List'" <tomcat-user@jakarta.apache.org>
> >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: JStanczak@vinu.edu [mailto:JStanczak@vinu.edu]
> >> > 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" <JHart@sfa.com>
> >> > 10/17/2003 03:00 PM
> >> > Please respond to "Tomcat Users List"
> >> >
> >> >
> >> >         To:     "Tomcat Users List"
> <tomcat-user@jakarta.apache.org>
> >> >         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:rgamez@OasisAdvantage.com]
> >> > 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:epyonneNOSPAM@hotmail.com]
> >> > 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" <rgamez@OasisAdvantage.com>
> >> > To: <tomcat-user@jakarta.apache.org>
> >> > 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: tomcat-user-unsubscribe@jakarta.apache.org
> >> > For additional commands, e-mail:
> tomcat-user-help@jakarta.apache.org
> >> >
> >> >
> >> >
> >> >
> ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> >> > For additional commands, e-mail:
> tomcat-user-help@jakarta.apache.org
> >> >
> >> >
> >> >
> ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> >> > For additional commands, e-mail:
> tomcat-user-help@jakarta.apache.org
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> >> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >>
> >>
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> >For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> >For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> >For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 
> 
> 
> 
> This e-mail, including any attachments, is a confidential business
> communication, and may contain information that is confidential,
> proprietary and/or privileged.  This e-mail is intended only for the
> individual(s) to whom it is addressed, and may not be saved, copied,
> printed, disclosed or used by anyone else.  If you are not the(an)
> intended recipient, please immediately delete this e-mail from your
> computer system and notify the sender.  Thank you.
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message