Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org Received: (qmail 30182 invoked from network); 17 Oct 2003 21:15:30 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 17 Oct 2003 21:15:30 -0000 Received: (qmail 8124 invoked by uid 500); 17 Oct 2003 21:14:16 -0000 Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org Received: (qmail 8086 invoked by uid 500); 17 Oct 2003 21:14:15 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 8056 invoked from network); 17 Oct 2003 21:14:15 -0000 Received: from unknown (HELO warhawk.mpi.com) (63.244.250.133) by daedalus.apache.org with SMTP; 17 Oct 2003 21:14:15 -0000 Received: from lightning.mpi.com (lightning.mpi.com [63.244.252.11]) by warhawk.mpi.com (Switch-2.2.8/Switch-2.2.6) with ESMTP id h9HLCRF10475 for ; Fri, 17 Oct 2003 17:12:27 -0400 (EDT) Received: from US-VS1.corp.mpi.com (us-be1.corp.mpi.com [63.244.252.30]) by lightning.mpi.com (Switch-3.0.5/Switch-3.0.0) with ESMTP id h9HLDeFp016945 for ; Fri, 17 Oct 2003 17:14:17 -0400 (EDT) X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: RE: Java/JSP/Servlet Programmer [off topic] Date: Fri, 17 Oct 2003 17:13:22 -0400 Message-ID: <9C5166762F311146951505C6790A9CF8013DF4DC@US-VS1.corp.mpi.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Java/JSP/Servlet Programmer [off topic] Thread-Index: AcOU80byJPc/nBTGT8CRdHYoGX40iwAACIMg From: "Shapira, Yoav" To: "Tomcat Users List" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Howdy, This slight overhead (assuming your database is properly indexed) is f= ar far less trouble than you'd have if the query returned a result set large enough to get a java OutOfMemoryError... Yoav Shapira Millennium ChemInformatics >-----Original Message----- >From: epyonne [mailto:epyonneNOSPAM@hotmail.com] >Sent: Friday, October 17, 2003 5:12 PM >To: Tomcat Users List >Subject: Re: Java/JSP/Servlet Programmer [off topic] > >Yeah, since my web application is going to be run by people in our office >locations all over the world, I try to have as little overhead as possible. >Thanks. > > >----- Original Message ----- >From: "Hart, Justin" >To: "Tomcat Users List" >Sent: Friday, October 17, 2003 04:01 PM >Subject: RE: Java/JSP/Servlet Programmer [off topic] > > >Yeah, but that means you have to run the query twice. > >-----Original Message----- >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com] >Sent: Friday, October 17, 2003 4: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 =3D "select count(*) from (" + sql + ")"; > Statement stmt =3D connection.createStatement(); > ResultSet rs =3D 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 wit= h 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 b= e >>scrollable already. The following is the snippets: >>//code begins------------------------------ >>DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());= >>String url =3D "jdbc:oracle:thin:@.........."; >>conn =3D DriverManager.getConnection(url,........); >>String plsql =3D "begin (?,?,?); end;"; >>CallableStatement cs =3D 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 =3D null; >>rs =3D (ResultSet)cs.getObject(1); >>rs.last(); >>//code ends------------------------------------ >> >>Any help will be very much appreciated. >> >> >> >>----- Original Message ----- >>From: "Mike Curwen" >>To: "'Tomcat Users List'" >>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 th= e >>> 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" >>> > 10/17/2003 03:00 PM >>> > Please respond to "Tomcat Users List" >>> > >>> > >>> > To: "Tomcat Users List" > >>> > 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" >>> > To: >>> > 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.o= rg >>> > For additional commands, e-mail: >tomcat-user-help@jakarta.apache.org >>> > >>> > >>> > >>> > >---------------------------------------------------------------------= >>> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.o= rg >>> > For additional commands, e-mail: >tomcat-user-help@jakarta.apache.org >>> > >>> > >>> > >---------------------------------------------------------------------= >>> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.o= rg >>> > 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.o= rg >>> >>> >> >>--------------------------------------------------------------------= - >>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, disclose= d or >used by anyone else. If you are not the(an) intended recipient, plea= se >immediately delete this e-mail from your computer system and notify t= he >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 > > >---------------------------------------------------------------------= >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 com= munication, and may contain information that is confidential, propriet= ary and/or privileged. This e-mail is intended only for the individua= l(s) to whom it is addressed, and may not be saved, copied, printed, d= isclosed or used by anyone else. If you are not the(an) intended reci= pient, 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