RE: Java/JSP/Servlet Programmer [off topic]
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 (?,?,?); 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: To
RE: Java/JSP/Servlet Programmer [off topic]
Perhaps. I still like my solution of going to the last row and getting the current
row number better though :-P
-Original Message-
From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 5:20 PM
To: Tomcat Users List
Subject: RE: Java/JSP/Servlet Programmer [off topic]
Howdy,
These are all tradeoffs, as there are with almost every real-life design
decision. With well-maintained modern databases, even complicates
queries can run very quickly. This extra row count query, as I said
originally, is a way to get the result count without getting the actual
full result set. It's useful in some cases and not in others.
If you have potentially large results to your queries, this is a prudent
approach that slightly sacrifices performance for
stability/availability. I.e. it might run a little slower, but it won't
crash.
Yoav Shapira
Millennium ChemInformatics
>-Original Message-
>From: Hart, Justin [mailto:[EMAIL PROTECTED]
>Sent: Friday, October 17, 2003 5:15 PM
>To: Tomcat Users List
>Subject: RE: Java/JSP/Servlet Programmer [off topic]
>
>But what if it's a busy database, or the query is complex?
>
>-Original Message-
>From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
>Sent: Friday, October 17, 2003 5:13 PM
>To: Tomcat Users List
>Subject: RE: Java/JSP/Servlet Programmer [off topic]
>
>
>
>Howdy,
>
>>Yeah, but that means you have to run the query twice.
>
>Yup, it does. There are cases when that's extremely useful if the
query
>result set is large: you might not want to load it into memory, or
>modify the query, so that you don't run out of heap memory.
>
>Yoav Shapira
>
>>
>>-Original Message-
>>From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
>>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 = "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:[EMAIL PROTECTED]
>>>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:[EMAIL PROTECTED]
>>>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:[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:@.
RE: Java/JSP/Servlet Programmer [off topic]
Howdy,
These are all tradeoffs, as there are with almost every real-life design
decision. With well-maintained modern databases, even complicates
queries can run very quickly. This extra row count query, as I said
originally, is a way to get the result count without getting the actual
full result set. It's useful in some cases and not in others.
If you have potentially large results to your queries, this is a prudent
approach that slightly sacrifices performance for
stability/availability. I.e. it might run a little slower, but it won't
crash.
Yoav Shapira
Millennium ChemInformatics
>-Original Message-
>From: Hart, Justin [mailto:[EMAIL PROTECTED]
>Sent: Friday, October 17, 2003 5:15 PM
>To: Tomcat Users List
>Subject: RE: Java/JSP/Servlet Programmer [off topic]
>
>But what if it's a busy database, or the query is complex?
>
>-Original Message-
>From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
>Sent: Friday, October 17, 2003 5:13 PM
>To: Tomcat Users List
>Subject: RE: Java/JSP/Servlet Programmer [off topic]
>
>
>
>Howdy,
>
>>Yeah, but that means you have to run the query twice.
>
>Yup, it does. There are cases when that's extremely useful if the
query
>result set is large: you might not want to load it into memory, or
>modify the query, so that you don't run out of heap memory.
>
>Yoav Shapira
>
>>
>>-Original Message-
>>From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
>>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 = "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:[EMAIL PROTECTED]
>>>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:[EMAIL PROTECTED]
>>>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:[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 (?,?,?); end;";
>>>CallableStatement cs = conn.prepareCall(plsql,
>>> ResultSet.TYPE_SCROLL_INSENSITIVE,
>>ResultSet.CONCUR_UPDATABLE);
>>>cs.reg
RE: Java/JSP/Servlet Programmer [off topic]
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
[EMAIL PROTECTED]
> -Original Message-
> From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
> 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:[EMAIL PROTECTED]
> >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:[EMAIL PROTECTED]
> >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:[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 (?,?,?); 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
&g
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 (?,?,?); 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]> > > >
RE: Java/JSP/Servlet Programmer [off topic]
But what if it's a busy database, or the query is complex?
-Original Message-
From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 5:13 PM
To: Tomcat Users List
Subject: RE: Java/JSP/Servlet Programmer [off topic]
Howdy,
>Yeah, but that means you have to run the query twice.
Yup, it does. There are cases when that's extremely useful if the query
result set is large: you might not want to load it into memory, or
modify the query, so that you don't run out of heap memory.
Yoav Shapira
>
>-Original Message-
>From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
>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 = "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:[EMAIL PROTECTED]
>>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:[EMAIL PROTECTED]
>>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:[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 (?,?,?); 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
RE: Java/JSP/Servlet Programmer [off topic]
Howdy,
This slight overhead (assuming your database is properly indexed) is far
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:[EMAIL PROTECTED]
>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" <[EMAIL PROTECTED]>
>To: "Tomcat Users List" <[EMAIL PROTECTED]>
>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:[EMAIL PROTECTED]
>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 = "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:[EMAIL PROTECTED]
>>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:[EMAIL PROTECTED]
>>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:[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 (?,?,?); 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 th
RE: Java/JSP/Servlet Programmer [off topic]
Howdy,
>Yeah, but that means you have to run the query twice.
Yup, it does. There are cases when that's extremely useful if the query
result set is large: you might not want to load it into memory, or
modify the query, so that you don't run out of heap memory.
Yoav Shapira
>
>-Original Message-
>From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
>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 = "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:[EMAIL PROTECTED]
>>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:[EMAIL PROTECTED]
>>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:[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 (?,?,?); 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
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" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
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 = "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:[EMAIL PROTECTED]
>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:[EMAIL PROTECTED]
>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:[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 (?,?,?); 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
>> >
>> >
>> >
>> >
>> >
Re: Java/JSP/Servlet Programmer [off topic]
Thanks. But I know for the fact that there should have data in the ResultSet. If I remove the definition for scrollability (is it a word?) and remove the rs.last() method, I get data back. Furthermore, if I do the same thing for stored procedure in SQL Server, it works. And if I do the same thing on regular Statement for Oracle database like this: Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); It works as well. That makes me think it has something to do with calling an Oracle stored procedure. But I just cannot figure that out where it goes wrong. Thank you very much. - Original Message - From: "mike jackson" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" <[EMAIL PROTECTED]> Sent: Friday, October 17, 2003 03:48 PM Subject: RE: Java/JSP/Servlet Programmer [off topic] You might have to call rs.next() first before the rs.last(). I know that prior to getting a ResultSetMetaData object you have to call the rs.next(). Could be the rs.last() requires the same thing (in case there's no records returned). But that's just a guess. --mikej -=-- mike jackson [EMAIL PROTECTED] > -Original Message- > From: epyonne [mailto:[EMAIL PROTECTED] > Sent: Friday, October 17, 2003 12: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 (?,?,?); 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
RE: Java/JSP/Servlet Programmer [off topic]
Yeah, but that means you have to run the query twice.
-Original Message-
From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
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 = "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:[EMAIL PROTECTED]
>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:[EMAIL PROTECTED]
>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:[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 (?,?,?); 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
>> >
>> >
>> >
RE: Java/JSP/Servlet Programmer [off topic]
My mistake. After reading Justin's reply I looked back at my code. I am using getRow from ResultSet. -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 (?,?,?); 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 Mess
RE: Java/JSP/Servlet Programmer [off topic]
Also OT... I've an older implementation of Apache ( i.e. not Tomcat and pre-webservice ). I am trying to send data from my servlet to co-workers webservice. Using the java.net.URL package I am opening a connection to his page and using an OutputStream and OutputStreamWriter to write my data to his page and an InputStream to read his reply. We are both using ntlm authentication for our apps but I am receiving a 401 error when reading from the InputStream. Seems it's either losing the authenticated user or user a different account. Any ideas? -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 (?,?,?); 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 bas
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:[EMAIL PROTECTED]
>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:[EMAIL PROTECTED]
>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:[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 (?,?,?); 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 b
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 (?,?,?); 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 curre
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:[EMAIL PROTECTED] 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:[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 (?,?,?); 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
RE: Java/JSP/Servlet Programmer [off topic]
You might have to call rs.next() first before the rs.last(). I know that prior to getting a ResultSetMetaData object you have to call the rs.next(). Could be the rs.last() requires the same thing (in case there's no records returned). But that's just a guess. --mikej -=-- mike jackson [EMAIL PROTECTED] > -Original Message- > From: epyonne [mailto:[EMAIL PROTECTED] > Sent: Friday, October 17, 2003 12: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 (?,?,?); 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
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 (?,?,?); 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,
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 (?,?,?); 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-mai
