tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Curwen" <gb_...@gb-im.com>
Subject RE: Java/JSP/Servlet Programmer [off topic]
Date Fri, 17 Oct 2003 21:23:35 GMT
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:gb_dev@gb-im.com] 
> 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:epyonneNOSPAM@hotmail.com]
> > 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." <BrendleDA@c-b.com>
> > To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
> > 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: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
> > 
> 
> 
> ---------------------------------------------------------------------
> 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