Re: Java/JSP/Servlet Programmer [off topic]
Pardon me that it is off topics Speaking about re-usable ResultSet, I am having a little problem with a ResultSet and I cannot find the solution. I have a routine in my servlet to call an Oracle stored procedure, using CallableStatement. Everything works fine. Then, I want to get the row count of the ResultSet. I can do that by using the rs.last() method. However, that requires the ResultSet to be scrollable. So I change the code accordingly. After that, I keep getting the error message of: SQLException: Invalid operation of forward only resultset: last I can't figure out why. I thought I have defined the ResultSet to be scrollable already. The following is the snippets: //code begins-- DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); String url = jdbc:oracle:thin:@..; conn = DriverManager.getConnection(url,); String plsql = begin my stored procedure(?,?,?); end;; CallableStatement cs = conn.prepareCall(plsql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); cs.registerOutParameter(1, OracleTypes.CURSOR); cs.setString(2, InputParam1); cs.registerOutParameter(3, Types.INTEGER); cs.execute(); ResultSet rs = null; rs = (ResultSet)cs.getObject(1); rs.last(); //code ends Any help will be very much appreciated. - Original Message - From: Mike Curwen [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Sent: Friday, October 17, 2003 03:12 PM Subject: RE: Java/JSP/Servlet Programmer I would send y'all my resume, but ever since the humiliation of the re-usable ResultSet, I'm sure I'm one of those that can't walk yet. ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:08 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I agree. I'm getting funds to hire a new person and I dread it. I've screened a lot of people on the last time I hired someone an still got a lemon. Lot's of people talk to talk, but can't even walk yet. Thank You, Justin A. Stanczak Web Manager Shake Learning Resource Center Vincennes University (812)888-5813 Hart, Justin [EMAIL PROTECTED] 10/17/2003 03:00 PM Please respond to Tomcat Users List To: Tomcat Users List [EMAIL PROTECTED] cc: Subject:RE: Java/JSP/Servlet Programmer That's what I've found. The market is full of tech workers, but that doesn't mean that they're a programmer, or as familiar with technology X (for position Y) as they should be. I went to a job fair a couple years ago for 4 job opennings, 2 for programmers. 2 for techs. 1000 people showed up, and I spoke with only 4-5 that I really thought qualified for the programming jobs or had credentials that showed that they qualified for the job. -Original Message- From: Ruben Gamez [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:57 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I would think so, but it's true. I've gotten several people that interview well, but none that can pass a couple of simple tests (I consider them simple). -Original Message- From: epyonne [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:55 PM To: Tomcat Users List Subject: Re: Java/JSP/Servlet Programmer Cannot find anyone?!?!?! It is rather hard to believe based on current job market. - Original Message - From: Ruben Gamez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 17, 2003 02:33 PM Subject: Java/JSP/Servlet Programmer I'm looking for an experienced JSP/Servlet programmer located in our area. We're located in West Palm Beach, FL. We've tried posting the Job on Monster, and looking for candidates on there, but still cannot find someone that can do the job. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Java/JSP/Servlet Programmer [off topic]
Have you tried using ResultetMetaData to get row count BEFORE you process the Resultset? -Original Message- From: epyonne [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:44 PM To: Tomcat Users List Subject: Re: Java/JSP/Servlet Programmer [off topic] Pardon me that it is off topics Speaking about re-usable ResultSet, I am having a little problem with a ResultSet and I cannot find the solution. I have a routine in my servlet to call an Oracle stored procedure, using CallableStatement. Everything works fine. Then, I want to get the row count of the ResultSet. I can do that by using the rs.last() method. However, that requires the ResultSet to be scrollable. So I change the code accordingly. After that, I keep getting the error message of: SQLException: Invalid operation of forward only resultset: last I can't figure out why. I thought I have defined the ResultSet to be scrollable already. The following is the snippets: //code begins-- DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); String url = jdbc:oracle:thin:@..; conn = DriverManager.getConnection(url,); String plsql = begin my stored procedure(?,?,?); end;; CallableStatement cs = conn.prepareCall(plsql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); cs.registerOutParameter(1, OracleTypes.CURSOR); cs.setString(2, InputParam1); cs.registerOutParameter(3, Types.INTEGER); cs.execute(); ResultSet rs = null; rs = (ResultSet)cs.getObject(1); rs.last(); //code ends Any help will be very much appreciated. - Original Message - From: Mike Curwen [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Sent: Friday, October 17, 2003 03:12 PM Subject: RE: Java/JSP/Servlet Programmer I would send y'all my resume, but ever since the humiliation of the re-usable ResultSet, I'm sure I'm one of those that can't walk yet. ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:08 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I agree. I'm getting funds to hire a new person and I dread it. I've screened a lot of people on the last time I hired someone an still got a lemon. Lot's of people talk to talk, but can't even walk yet. Thank You, Justin A. Stanczak Web Manager Shake Learning Resource Center Vincennes University (812)888-5813 Hart, Justin [EMAIL PROTECTED] 10/17/2003 03:00 PM Please respond to Tomcat Users List To: Tomcat Users List [EMAIL PROTECTED] cc: Subject:RE: Java/JSP/Servlet Programmer That's what I've found. The market is full of tech workers, but that doesn't mean that they're a programmer, or as familiar with technology X (for position Y) as they should be. I went to a job fair a couple years ago for 4 job opennings, 2 for programmers. 2 for techs. 1000 people showed up, and I spoke with only 4-5 that I really thought qualified for the programming jobs or had credentials that showed that they qualified for the job. -Original Message- From: Ruben Gamez [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:57 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I would think so, but it's true. I've gotten several people that interview well, but none that can pass a couple of simple tests (I consider them simple). -Original Message- From: epyonne [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:55 PM To: Tomcat Users List Subject: Re: Java/JSP/Servlet Programmer Cannot find anyone?!?!?! It is rather hard to believe based on current job market. - Original Message - From: Ruben Gamez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 17, 2003 02:33 PM Subject: Java/JSP/Servlet Programmer I'm looking for an experienced JSP/Servlet programmer located in our area. We're located in West Palm Beach, FL. We've tried posting the Job on Monster, and looking for candidates on there, but still cannot find someone that can do the job. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED
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 my stored procedure(?,?,?); end;; CallableStatement cs = conn.prepareCall(plsql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); cs.registerOutParameter(1, OracleTypes.CURSOR); cs.setString(2, InputParam1); cs.registerOutParameter(3, Types.INTEGER); cs.execute(); ResultSet rs = null; rs = (ResultSet)cs.getObject(1); rs.last(); //code ends Any help will be very much appreciated. - Original Message - From: Mike Curwen [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Sent: Friday, October 17, 2003 03:12 PM Subject: RE: Java/JSP/Servlet Programmer I would send y'all my resume, but ever since the humiliation of the re-usable ResultSet, I'm sure I'm one of those that can't walk yet. ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:08 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I agree. I'm getting funds to hire a new person and I dread it. I've screened a lot of people on the last time I hired someone an still got a lemon. Lot's of people talk to talk, but can't even walk yet. Thank You, Justin A. Stanczak Web Manager Shake Learning Resource Center Vincennes University (812)888-5813 Hart, Justin [EMAIL PROTECTED] 10/17/2003 03:00 PM Please respond to Tomcat Users List To: Tomcat Users List [EMAIL PROTECTED] cc: Subject:RE: Java/JSP/Servlet Programmer That's what I've found. The market is full of tech workers, but that doesn't mean that they're a programmer, or as familiar with technology X (for position Y) as they should be. I went to a job fair a couple years ago for 4 job opennings, 2 for programmers. 2 for techs. 1000 people showed up, and I spoke with only 4-5 that I really thought qualified for the programming jobs or had credentials that showed that they qualified for the job. -Original Message- From: Ruben Gamez [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:57 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I would think so, but it's true. I've gotten several people that interview well, but none that can pass a couple of simple tests (I consider them simple). -Original Message- From: epyonne [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:55 PM To: Tomcat Users List Subject: Re: Java/JSP/Servlet Programmer Cannot find anyone?!?!?! It is rather hard to believe based on current job market. - Original Message - From: Ruben Gamez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 17, 2003 02:33 PM Subject: Java/JSP/Servlet Programmer I'm looking for an experienced JSP/Servlet programmer located in our area. We're located in West Palm Beach, FL. We've tried posting the Job on Monster, and looking for candidates on there, but still cannot find someone that can do the job. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED
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 my stored procedure(?,?,?); end;; CallableStatement cs = conn.prepareCall(plsql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); cs.registerOutParameter(1, OracleTypes.CURSOR); cs.setString(2, InputParam1); cs.registerOutParameter(3, Types.INTEGER); cs.execute(); ResultSet rs = null; rs = (ResultSet)cs.getObject(1); rs.last(); //code ends Any help will be very much appreciated. - Original Message - From: Mike Curwen [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Sent: Friday, October 17, 2003 03:12 PM Subject: RE: Java/JSP/Servlet Programmer I would send y'all my resume, but ever since the humiliation of the re-usable ResultSet, I'm sure I'm one of those that can't walk yet. ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:08 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I agree. I'm getting funds to hire a new person and I dread it. I've screened a lot of people on the last time I hired someone an still got a lemon. Lot's of people talk to talk, but can't even walk yet. Thank You, Justin A. Stanczak Web Manager Shake Learning Resource Center Vincennes University (812)888-5813 Hart, Justin [EMAIL PROTECTED] 10/17/2003 03:00 PM Please respond to Tomcat Users List To: Tomcat Users List [EMAIL PROTECTED] cc: Subject:RE: Java/JSP/Servlet Programmer That's what I've found. The market is full of tech workers, but that doesn't mean that they're a programmer, or as familiar with technology X (for position Y) as they should be. I went to a job fair a couple years ago for 4 job opennings, 2 for programmers. 2 for techs. 1000 people showed up, and I spoke with only 4-5 that I really thought qualified for the programming jobs or had credentials that showed that they qualified for the job. -Original Message- From: Ruben Gamez [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:57 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I would think so, but it's true. I've gotten several people that interview well, but none that can pass a couple of simple tests (I consider them simple). -Original Message- From: epyonne [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:55 PM To: Tomcat Users List Subject: Re: Java/JSP/Servlet Programmer Cannot find anyone?!?!?! It is rather hard to believe based on current job market. - Original Message - From: Ruben Gamez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 17, 2003 02:33 PM Subject: Java/JSP/Servlet Programmer I'm looking for an experienced JSP/Servlet programmer located in our area. We're located in West Palm Beach, FL. We've tried posting the Job on Monster, and looking for candidates on there, but still cannot find someone that can do the job. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED
Re: Java/JSP/Servlet Programmer [off topic]
Thanks for the reply. I searched for ResultSetMetaData in JavaDoc, and there is no method to get row count. It only has column count. Did I miss something? Please explain. Thank you very much. - Original Message - From: Brendle, Douglas A. [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Friday, October 17, 2003 03:45 PM Subject: RE: Java/JSP/Servlet Programmer [off topic] Have you tried using ResultetMetaData to get row count BEFORE you process the Resultset? -Original Message- From: epyonne [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:44 PM To: Tomcat Users List Subject: Re: Java/JSP/Servlet Programmer [off topic] Pardon me that it is off topics Speaking about re-usable ResultSet, I am having a little problem with a ResultSet and I cannot find the solution. I have a routine in my servlet to call an Oracle stored procedure, using CallableStatement. Everything works fine. Then, I want to get the row count of the ResultSet. I can do that by using the rs.last() method. However, that requires the ResultSet to be scrollable. So I change the code accordingly. After that, I keep getting the error message of: SQLException: Invalid operation of forward only resultset: last I can't figure out why. I thought I have defined the ResultSet to be scrollable already. The following is the snippets: //code begins-- DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); String url = jdbc:oracle:thin:@..; conn = DriverManager.getConnection(url,); String plsql = begin my stored procedure(?,?,?); end;; CallableStatement cs = conn.prepareCall(plsql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); cs.registerOutParameter(1, OracleTypes.CURSOR); cs.setString(2, InputParam1); cs.registerOutParameter(3, Types.INTEGER); cs.execute(); ResultSet rs = null; rs = (ResultSet)cs.getObject(1); rs.last(); //code ends Any help will be very much appreciated. - Original Message - From: Mike Curwen [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Sent: Friday, October 17, 2003 03:12 PM Subject: RE: Java/JSP/Servlet Programmer I would send y'all my resume, but ever since the humiliation of the re-usable ResultSet, I'm sure I'm one of those that can't walk yet. ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:08 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I agree. I'm getting funds to hire a new person and I dread it. I've screened a lot of people on the last time I hired someone an still got a lemon. Lot's of people talk to talk, but can't even walk yet. Thank You, Justin A. Stanczak Web Manager Shake Learning Resource Center Vincennes University (812)888-5813 Hart, Justin [EMAIL PROTECTED] 10/17/2003 03:00 PM Please respond to Tomcat Users List To: Tomcat Users List [EMAIL PROTECTED] cc: Subject:RE: Java/JSP/Servlet Programmer That's what I've found. The market is full of tech workers, but that doesn't mean that they're a programmer, or as familiar with technology X (for position Y) as they should be. I went to a job fair a couple years ago for 4 job opennings, 2 for programmers. 2 for techs. 1000 people showed up, and I spoke with only 4-5 that I really thought qualified for the programming jobs or had credentials that showed that they qualified for the job. -Original Message- From: Ruben Gamez [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:57 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I would think so, but it's true. I've gotten several people that interview well, but none that can pass a couple of simple tests (I consider them simple). -Original Message- From: epyonne [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:55 PM To: Tomcat Users List Subject: Re: Java/JSP/Servlet Programmer Cannot find anyone?!?!?! It is rather hard to believe based on current job market. - Original Message - From: Ruben Gamez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 17, 2003 02:33 PM Subject: Java/JSP/Servlet Programmer I'm looking for an experienced JSP/Servlet programmer located in our area. We're located in West Palm Beach, FL. We've tried posting the Job on Monster, and looking for candidates on there, but still cannot find someone that can do the job. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e
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 my stored procedure(?,?,?); end;;
CallableStatement cs = conn.prepareCall(plsql,
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
cs.registerOutParameter(1, OracleTypes.CURSOR);
cs.setString(2, InputParam1);
cs.registerOutParameter(3, Types.INTEGER);
cs.execute();
ResultSet rs = null;
rs = (ResultSet)cs.getObject(1);
rs.last();
//code ends
Any help will be very much appreciated.
- Original Message -
From: Mike Curwen [EMAIL PROTECTED]
To: 'Tomcat Users List' [EMAIL PROTECTED]
Sent: Friday, October 17, 2003 03:12 PM
Subject: RE: Java/JSP/Servlet Programmer
I would send y'all my resume, but ever since the humiliation of the
re-usable ResultSet, I'm sure I'm one of those that can't walk yet.
;)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 3:08 PM
To: Tomcat Users List
Subject: RE: Java/JSP/Servlet Programmer
I agree. I'm getting funds to hire a new person and I dread it.
I've
screened a lot of people on the last time I hired someone an
still got a
lemon. Lot's of people talk to talk, but can't even walk yet.
Thank You,
Justin A. Stanczak
Web Manager
Shake Learning Resource Center
Vincennes University
(812)888-5813
Hart, Justin [EMAIL PROTECTED]
10/17/2003 03:00 PM
Please respond to Tomcat Users List
To: Tomcat Users List
[EMAIL PROTECTED]
cc:
Subject:RE: Java/JSP/Servlet Programmer
That's what I've found. The market is full of tech workers, but
that
doesn't mean that they're a programmer, or as familiar with
technology X
(for position Y) as they should be. I went to a job fair a
couple years
ago for 4 job opennings, 2 for programmers. 2 for techs.
1000 people
showed up, and I spoke with only 4-5 that I really thought
qualified for
the programming jobs or had credentials that showed that they
qualified
for the job.
-Original Message-
From: Ruben Gamez [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 3:57 PM
To: Tomcat Users List
Subject: RE: Java/JSP/Servlet Programmer
I would think so, but it's true. I've gotten several people
that interview well, but none that can pass a couple of
simple tests (I consider them simple).
-Original Message-
From: epyonne [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 3:55 PM
To: Tomcat Users List
Subject: Re: Java/JSP/Servlet Programmer
Cannot find anyone?!?!?! It is rather hard to believe based
on current job market.
- Original Message -
From: Ruben Gamez [EMAIL PROTECTED
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 my stored procedure(?,?,?); end;; CallableStatement cs = conn.prepareCall(plsql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); cs.registerOutParameter(1, OracleTypes.CURSOR); cs.setString(2, InputParam1); cs.registerOutParameter(3, Types.INTEGER); cs.execute(); ResultSet rs = null; rs = (ResultSet)cs.getObject(1); rs.last(); //code ends Any help will be very much appreciated. - Original Message - From: Mike Curwen [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Sent: Friday, October 17, 2003 03:12 PM Subject: RE: Java/JSP/Servlet Programmer I would send y'all my resume, but ever since the humiliation of the re-usable ResultSet, I'm sure I'm one of those that can't walk yet. ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:08 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I agree. I'm getting funds to hire a new person and I dread it. I've screened a lot of people on the last time I hired someone an still got a lemon. Lot's of people talk to talk, but can't even walk yet. Thank You, Justin A. Stanczak Web Manager Shake Learning Resource Center Vincennes University (812)888-5813 Hart, Justin [EMAIL PROTECTED] 10/17/2003 03:00 PM Please respond to Tomcat Users List To: Tomcat Users List [EMAIL PROTECTED] cc: Subject:RE: Java/JSP/Servlet Programmer That's what I've found. The market is full of tech workers, but that doesn't mean that they're a programmer, or as familiar with technology X (for position Y) as they should be. I went to a job fair a couple years ago for 4 job opennings, 2 for programmers. 2 for techs. 1000 people showed up, and I spoke with only 4-5 that I really thought qualified for the programming jobs or had credentials that showed that they qualified for the job. -Original Message- From: Ruben Gamez [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:57 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I would think so, but it's true. I've gotten several people that interview well, but none that can pass a couple of simple tests (I consider them simple). -Original Message- From: epyonne [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:55 PM To: Tomcat Users List Subject: Re: Java/JSP/Servlet Programmer Cannot find anyone?!?!?! It is rather hard to believe based on current job market. - Original Message - From: Ruben Gamez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 17, 2003 02:33 PM Subject: Java/JSP/Servlet Programmer I'm looking for an experienced JSP/Servlet programmer located in our area. We're located in West Palm Beach, FL. We've tried posting the Job on Monster, and looking for candidates on there, but still cannot find someone that can do the job. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e
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 my stored procedure(?,?,?); end;; CallableStatement cs = conn.prepareCall(plsql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); cs.registerOutParameter(1, OracleTypes.CURSOR); cs.setString(2, InputParam1); cs.registerOutParameter(3, Types.INTEGER); cs.execute(); ResultSet rs = null; rs = (ResultSet)cs.getObject(1); rs.last(); //code ends Any help will be very much appreciated. - Original Message - From: Mike Curwen [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Sent: Friday, October 17, 2003 03:12 PM Subject: RE: Java/JSP/Servlet Programmer I would send y'all my resume, but ever since the humiliation of the re-usable ResultSet, I'm sure I'm one of those that can't walk yet. ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:08 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I agree. I'm getting funds to hire a new person and I dread it. I've screened a lot of people on the last time I hired someone an still got a lemon. Lot's of people talk to talk, but can't even walk yet. Thank You, Justin A. Stanczak Web Manager Shake Learning Resource Center Vincennes University (812)888-5813 Hart, Justin [EMAIL PROTECTED] 10/17/2003 03:00 PM Please respond to Tomcat Users List To: Tomcat Users List [EMAIL PROTECTED] cc: Subject:RE: Java/JSP/Servlet Programmer That's what I've found. The market is full of tech workers, but that doesn't mean that they're a programmer, or as familiar with technology X (for position Y) as they should be. I went to a job fair a couple years ago for 4 job opennings, 2 for programmers. 2 for techs. 1000 people showed up, and I spoke with only 4-5 that I really thought qualified for the programming jobs or had credentials that showed that they qualified for the job. -Original Message- From: Ruben Gamez [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:57 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I would think so, but it's true. I've gotten several people that interview well, but none that can pass a couple of simple tests (I consider them simple). -Original Message- From: epyonne [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:55 PM To: Tomcat Users List Subject: Re: Java/JSP/Servlet Programmer Cannot find anyone?!?!?! It is rather hard to believe based on current job market. - Original Message - From: Ruben Gamez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 17, 2003 02:33 PM Subject: Java/JSP/Servlet Programmer I'm looking for an experienced JSP/Servlet programmer located in our area. We're located in West Palm Beach, FL. We've tried posting the Job on Monster, and looking for candidates on there, but still cannot find someone that can do the job
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 my stored procedure(?,?,?); end;;
CallableStatement cs = conn.prepareCall(plsql,
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
cs.registerOutParameter(1, OracleTypes.CURSOR);
cs.setString(2, InputParam1);
cs.registerOutParameter(3, Types.INTEGER);
cs.execute();
ResultSet rs = null;
rs = (ResultSet)cs.getObject(1);
rs.last();
//code ends
Any help will be very much appreciated.
- Original Message -
From: Mike Curwen [EMAIL PROTECTED]
To: 'Tomcat Users List' [EMAIL PROTECTED]
Sent: Friday, October 17, 2003 03:12 PM
Subject: RE: Java/JSP/Servlet Programmer
I would send y'all my resume, but ever since the humiliation of the
re-usable ResultSet, I'm sure I'm one of those that can't walk yet.
;)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 3:08 PM
To: Tomcat Users List
Subject: RE: Java/JSP/Servlet Programmer
I agree. I'm getting funds to hire a new person and I dread it.
I've
screened a lot of people on the last time I hired someone an
still got a
lemon. Lot's of people talk to talk, but can't even walk yet.
Thank You,
Justin A. Stanczak
Web Manager
Shake Learning Resource Center
Vincennes University
(812)888-5813
Hart, Justin [EMAIL PROTECTED]
10/17/2003 03:00 PM
Please respond to Tomcat Users List
To: Tomcat Users List
[EMAIL PROTECTED]
cc:
Subject:RE: Java/JSP/Servlet Programmer
That's what I've found. The market is full of tech workers, but
that
doesn't mean that they're a programmer, or as familiar with
technology X
(for position Y) as they should be. I went to a job fair a
couple years
ago for 4 job opennings, 2 for programmers. 2 for techs.
1000 people
showed up, and I spoke with only 4-5 that I really thought
qualified for
the programming jobs or had credentials that showed that they
qualified
for the job.
-Original Message-
From: Ruben Gamez [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 3:57 PM
To: Tomcat Users List
Subject: RE: Java/JSP/Servlet Programmer
I would think so, but it's true. I've gotten several people
that interview well, but none that can pass a couple of
simple tests (I consider them simple).
-Original Message-
From: epyonne [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17
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 my stored procedure(?,?,?); end;; CallableStatement cs = conn.prepareCall(plsql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); cs.registerOutParameter(1, OracleTypes.CURSOR); cs.setString(2, InputParam1); cs.registerOutParameter(3, Types.INTEGER); cs.execute(); ResultSet rs = null; rs = (ResultSet)cs.getObject(1); rs.last(); //code ends Any help will be very much appreciated. - Original Message - From: Mike Curwen [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Sent: Friday, October 17, 2003 03:12 PM Subject: RE: Java/JSP/Servlet Programmer I would send y'all my resume, but ever since the humiliation of the re-usable ResultSet, I'm sure I'm one of those that can't walk yet. ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:08 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I agree. I'm getting funds to hire a new person and I dread it. I've screened a lot of people on the last time I hired someone an still got a lemon. Lot's of people talk to talk, but can't even walk yet. Thank You, Justin A. Stanczak Web Manager Shake Learning Resource Center Vincennes University (812)888-5813 Hart, Justin [EMAIL PROTECTED] 10/17/2003 03:00 PM Please respond to Tomcat Users List To: Tomcat Users List [EMAIL PROTECTED] cc: Subject:RE: Java/JSP/Servlet Programmer That's what I've found. The market is full of tech workers, but that doesn't mean that they're a programmer, or as familiar with technology X (for position Y) as they should be. I went to a job fair a couple years ago for 4 job opennings, 2 for programmers. 2 for techs. 1000 people showed up, and I spoke with only 4-5 that I really thought qualified for the programming jobs or had credentials that showed that they qualified for the job. -Original Message- From: Ruben Gamez [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:57 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I would think so, but it's true. I've gotten several people that interview well, but none that can pass a couple of simple tests (I consider them simple). -Original Message- From: epyonne [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:55 PM To: Tomcat Users List Subject: Re: Java/JSP/Servlet Programmer Cannot find anyone?!?!?! It is rather hard to believe based on current
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 my stored procedure(?,?,?); end;;
CallableStatement cs = conn.prepareCall(plsql,
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
cs.registerOutParameter(1, OracleTypes.CURSOR);
cs.setString(2, InputParam1);
cs.registerOutParameter(3, Types.INTEGER);
cs.execute();
ResultSet rs = null;
rs = (ResultSet)cs.getObject(1);
rs.last();
//code ends
Any help will be very much appreciated.
- Original Message -
From: Mike Curwen [EMAIL PROTECTED]
To: 'Tomcat Users List' [EMAIL PROTECTED]
Sent: Friday, October 17, 2003 03:12 PM
Subject: RE: Java/JSP/Servlet Programmer
I would send y'all my resume, but ever since the humiliation of the
re-usable ResultSet, I'm sure I'm one of those that can't walk yet.
;)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 3:08 PM
To: Tomcat Users List
Subject: RE: Java/JSP/Servlet Programmer
I agree. I'm getting funds to hire a new person and I dread it.
I've
screened a lot of people on the last time I hired someone an
still got a
lemon. Lot's of people talk to talk, but can't even walk yet.
Thank You,
Justin A. Stanczak
Web Manager
Shake Learning Resource Center
Vincennes University
(812)888-5813
Hart, Justin [EMAIL PROTECTED]
10/17/2003 03:00 PM
Please respond to Tomcat Users List
To: Tomcat Users List
[EMAIL PROTECTED]
cc:
Subject:RE: Java/JSP/Servlet Programmer
That's what I've found. The market is full of tech workers, but
that
doesn't mean that they're a programmer, or as familiar with
technology X
(for position Y) as they should be. I went to a job fair a
couple years
ago for 4 job opennings, 2 for programmers. 2 for techs.
1000 people
showed up, and I spoke with only 4-5 that I really thought
qualified for
the programming jobs or had credentials that showed that they
qualified
for the job.
-Original Message-
From: Ruben Gamez [mailto:[EMAIL PROTECTED]
Sent
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 my stored procedure(?,?,?); end;;
CallableStatement cs = conn.prepareCall(plsql,
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
cs.registerOutParameter(1, OracleTypes.CURSOR);
cs.setString(2, InputParam1);
cs.registerOutParameter(3, Types.INTEGER);
cs.execute();
ResultSet rs = null;
rs = (ResultSet)cs.getObject(1);
rs.last();
//code ends
Any help will be very much appreciated.
- Original Message -
From: Mike Curwen [EMAIL PROTECTED]
To: 'Tomcat Users List' [EMAIL PROTECTED]
Sent: Friday, October 17, 2003 03:12 PM
Subject: RE: Java/JSP/Servlet Programmer
I would send y'all my resume, but ever since the humiliation of the
re-usable ResultSet, I'm sure I'm one of those that can't walk yet.
;)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 3:08 PM
To: Tomcat Users List
Subject: RE: Java/JSP/Servlet Programmer
I agree. I'm getting funds to hire a new person and I dread it.
I've
screened a lot of people on the last time I hired someone an
still got a
lemon. Lot's of people talk to talk, but can't even walk yet.
Thank You,
Justin A. Stanczak
Web Manager
Shake Learning Resource Center
Vincennes University
(812)888-5813
Hart, Justin [EMAIL PROTECTED]
10/17/2003 03:00 PM
Please respond to Tomcat Users List
To: Tomcat Users List
[EMAIL PROTECTED]
cc:
Subject:RE: Java/JSP/Servlet Programmer
That's what I've found. The market is full of tech workers, but
that
doesn't mean that they're a programmer, or as familiar with
technology X
(for position Y) as they should be. I went to a job fair a
couple years
ago for 4 job opennings, 2 for programmers. 2 for techs.
1000 people
showed up, and I spoke with only 4-5 that I really thought
qualified for
the programming jobs or had credentials that showed that they
qualified
for the job.
-Original Message-
From: Ruben Gamez [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 3:57 PM
To: Tomcat Users List
Subject: RE: Java/JSP/Servlet Programmer
I would think so, but it's true
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 my stored procedure(?,?,?); end;;
CallableStatement cs = conn.prepareCall(plsql,
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
cs.registerOutParameter(1, OracleTypes.CURSOR);
cs.setString(2, InputParam1);
cs.registerOutParameter(3, Types.INTEGER);
cs.execute();
ResultSet rs = null;
rs = (ResultSet)cs.getObject(1);
rs.last();
//code ends
Any help will be very much appreciated.
- Original Message -
From: Mike Curwen [EMAIL PROTECTED]
To: 'Tomcat Users List' [EMAIL PROTECTED]
Sent: Friday, October 17, 2003 03:12 PM
Subject: RE: Java/JSP/Servlet Programmer
I would send y'all my resume, but ever since the humiliation of the
re-usable ResultSet, I'm sure I'm one of those that can't walk yet.
;)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 3:08 PM
To: Tomcat Users List
Subject: RE: Java/JSP/Servlet Programmer
I agree. I'm getting funds to hire a new person and I dread it.
I've
screened a lot of people on the last time I hired someone an
still got a
lemon. Lot's of people talk to talk, but can't even walk yet.
Thank You,
Justin A. Stanczak
Web Manager
Shake Learning Resource Center
Vincennes University
(812)888-5813
Hart, Justin [EMAIL PROTECTED]
10/17/2003 03:00 PM
Please respond to Tomcat Users List
To: Tomcat Users List
[EMAIL PROTECTED]
cc:
Subject:RE: Java/JSP/Servlet Programmer
That's what I've found. The market is full of tech workers, but
that
doesn't mean that they're a programmer, or as familiar
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 my stored procedure(?,?,?); end;;
CallableStatement cs = conn.prepareCall(plsql,
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
cs.registerOutParameter(1, OracleTypes.CURSOR);
cs.setString(2, InputParam1);
cs.registerOutParameter(3, Types.INTEGER);
cs.execute();
ResultSet rs = null;
rs = (ResultSet)cs.getObject(1);
rs.last();
//code ends
Any help will be very much appreciated.
- Original Message -
From: Mike Curwen [EMAIL PROTECTED]
To: 'Tomcat Users List' [EMAIL PROTECTED]
Sent: Friday, October 17, 2003 03:12 PM
Subject: RE: Java/JSP/Servlet Programmer
I would send y'all my resume, but ever since the humiliation of the
re-usable ResultSet, I'm sure I'm one of those that can't walk yet.
;)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 3:08 PM
To: Tomcat Users List
Subject: RE: Java/JSP/Servlet Programmer
I agree. I'm getting funds to hire a new person and I dread it.
I've
screened a lot of people on the last time I hired someone an
still got a
lemon. Lot's of people talk to talk, but can't even walk yet.
Thank You,
Justin A. Stanczak
Web Manager
Shake Learning Resource Center
Vincennes University
(812)888-5813
Hart, Justin [EMAIL PROTECTED]
10/17/2003 03:00 PM
Please respond to Tomcat Users List
To: Tomcat Users List
[EMAIL PROTECTED]
cc:
Subject:RE: Java/JSP/Servlet Programmer
That's what I've found. The market is full of tech workers, but
that
doesn't mean that they're a programmer, or as familiar with
technology X
(for position Y) as they should be. I went to a job fair a
couple years
ago for 4 job opennings, 2 for programmers. 2 for techs.
1000 people
showed up, and I spoke with only 4-5 that I really thought
qualified for
the programming jobs or had credentials that showed
RE: Java/JSP/Servlet Programmer [off topic]
How about this: Just because you specify things like: ResultSet.TYPE_SCROLL_INSENSITIVE ResultSet.CONCUR_UPDATABLE doesn't mean the driver (or database!) would necessarily support those settings. Oracle of course, ought to, but maybe you have an older driver? In your code, do something like this, and see what it says: [code] cs.execute(); ResultSet rs = null; rs = (ResultSet)cs.getObject(1); // what are the results of these? cs.getResultSetConcurrency(); cs.getResultSetType(); [/code] Also, and I admit I've never used stored procs, but the cs.execute() looks funny. Would this be wrong?: [code] ResultSet rs = cs.executeQuery(); [/code] Just curious about that last one.. -Original Message- From: epyonne [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:54 PM To: Tomcat Users List Subject: Re: Java/JSP/Servlet Programmer [off topic] Thanks for the reply. I searched for ResultSetMetaData in JavaDoc, and there is no method to get row count. It only has column count. Did I miss something? Please explain. Thank you very much. - Original Message - From: Brendle, Douglas A. [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Friday, October 17, 2003 03:45 PM Subject: RE: Java/JSP/Servlet Programmer [off topic] Have you tried using ResultetMetaData to get row count BEFORE you process the Resultset? -Original Message- From: epyonne [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:44 PM To: Tomcat Users List Subject: Re: Java/JSP/Servlet Programmer [off topic] Pardon me that it is off topics Speaking about re-usable ResultSet, I am having a little problem with a ResultSet and I cannot find the solution. I have a routine in my servlet to call an Oracle stored procedure, using CallableStatement. Everything works fine. Then, I want to get the row count of the ResultSet. I can do that by using the rs.last() method. However, that requires the ResultSet to be scrollable. So I change the code accordingly. After that, I keep getting the error message of: SQLException: Invalid operation of forward only resultset: last I can't figure out why. I thought I have defined the ResultSet to be scrollable already. The following is the snippets: //code begins-- DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); String url = jdbc:oracle:thin:@..; conn = DriverManager.getConnection(url,); String plsql = begin my stored procedure(?,?,?); end;; CallableStatement cs = conn.prepareCall(plsql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); cs.registerOutParameter(1, OracleTypes.CURSOR); cs.setString(2, InputParam1); cs.registerOutParameter(3, Types.INTEGER); cs.execute(); ResultSet rs = null; rs = (ResultSet)cs.getObject(1); rs.last(); //code ends Any help will be very much appreciated. - Original Message - From: Mike Curwen [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Sent: Friday, October 17, 2003 03:12 PM Subject: RE: Java/JSP/Servlet Programmer I would send y'all my resume, but ever since the humiliation of the re-usable ResultSet, I'm sure I'm one of those that can't walk yet. ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:08 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I agree. I'm getting funds to hire a new person and I dread it. I've screened a lot of people on the last time I hired someone an still got a lemon. Lot's of people talk to talk, but can't even walk yet. Thank You, Justin A. Stanczak Web Manager Shake Learning Resource Center Vincennes University (812)888-5813 Hart, Justin [EMAIL PROTECTED] 10/17/2003 03:00 PM Please respond to Tomcat Users List To: Tomcat Users List [EMAIL PROTECTED] cc: Subject:RE: Java/JSP/Servlet Programmer That's what I've found. The market is full of tech workers, but that doesn't mean that they're a programmer, or as familiar with technology X (for position Y) as they should be. I went to a job fair a couple years ago for 4 job opennings, 2 for programmers. 2 for techs. 1000 people showed up, and I spoke with only 4-5 that I really thought qualified for the programming jobs or had credentials that showed that they qualified for the job. -Original Message- From: Ruben Gamez [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:57 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I would think so, but it's true. I've gotten several people that interview well, but none that can pass a couple of simple tests (I
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 my stored procedure(?,?,?); end;;
CallableStatement cs = conn.prepareCall(plsql,
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
cs.registerOutParameter(1, OracleTypes.CURSOR);
cs.setString(2, InputParam1);
cs.registerOutParameter(3, Types.INTEGER);
cs.execute();
ResultSet rs = null;
rs = (ResultSet)cs.getObject(1);
rs.last();
//code ends
Any help will be very much appreciated.
- Original Message -
From: Mike Curwen [EMAIL PROTECTED]
To: 'Tomcat Users List' [EMAIL PROTECTED]
Sent: Friday, October 17, 2003 03:12 PM
Subject: RE: Java/JSP/Servlet Programmer
I would send y'all my resume, but ever since the humiliation of the
re-usable ResultSet, I'm sure I'm one of those that can't walk yet.
;)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 3:08 PM
To: Tomcat Users List
Subject: RE: Java/JSP/Servlet Programmer
I agree. I'm getting funds to hire a new person and I dread it.
I've
screened a lot of people on the last time I hired someone an
still got a
lemon. Lot's of people talk to talk, but can't even walk yet.
Thank You,
Justin A. Stanczak
Web Manager
Shake Learning Resource Center
Vincennes University
(812)888-5813
Hart, Justin [EMAIL PROTECTED]
10/17/2003 03:00 PM
Please respond to Tomcat Users List
To: Tomcat Users List
[EMAIL PROTECTED]
cc:
Subject:RE: Java/JSP/Servlet Programmer
That's what I've found. The market is full of tech workers, but
that
doesn't mean that they're a programmer, or as familiar with
technology X
(for position Y) as they should be. I went to a job fair a
couple years
ago for 4 job opennings, 2 for programmers. 2 for techs.
1000 people
showed up, and I spoke with only 4-5 that I really thought
qualified for
the programming jobs or had credentials that showed that they
qualified
for the job.
-Original Message-
From: Ruben Gamez [mailto:[EMAIL PROTECTED]
Sent: Friday
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 my stored procedure(?,?,?); end;;
CallableStatement cs = conn.prepareCall(plsql,
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
cs.registerOutParameter(1, OracleTypes.CURSOR);
cs.setString(2, InputParam1);
cs.registerOutParameter(3, Types.INTEGER);
cs.execute();
ResultSet rs = null;
rs = (ResultSet)cs.getObject(1);
rs.last();
//code ends
Any help will be very much appreciated.
- Original Message -
From: Mike Curwen [EMAIL PROTECTED]
To: 'Tomcat Users List' [EMAIL PROTECTED]
Sent: Friday, October 17, 2003 03:12 PM
Subject: RE: Java/JSP/Servlet Programmer
I would send y'all my resume, but ever since the humiliation of the
re-usable ResultSet, I'm sure I'm one of those that can't walk yet.
;)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 3:08 PM
To: Tomcat Users List
Subject: RE: Java/JSP/Servlet Programmer
I agree. I'm getting funds to hire a new person and I dread it.
I've
screened a lot of people on the last time I hired someone an
still got a
lemon. Lot's of people talk to talk, but can't even walk yet.
Thank You
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:@..;
conn = DriverManager.getConnection(url,);
String plsql = begin my stored procedure(?,?,?); end;;
CallableStatement cs = conn.prepareCall(plsql,
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
cs.registerOutParameter(1, OracleTypes.CURSOR);
cs.setString(2, InputParam1);
cs.registerOutParameter(3, Types.INTEGER);
cs.execute();
ResultSet rs = null;
rs = (ResultSet)cs.getObject(1);
rs.last();
//code ends
Any help will be very much appreciated.
- Original Message -
From: Mike Curwen [EMAIL PROTECTED]
To: 'Tomcat Users List' [EMAIL PROTECTED]
Sent: Friday, October 17, 2003 03:12 PM
Subject: RE: Java/JSP/Servlet Programmer
I would send y'all my resume, but ever since the humiliation of the
re-usable ResultSet, I'm sure I'm one of those that can't walk yet.
;)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 3:08
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 my stored procedure(?,?,?); end;; CallableStatement cs = conn.prepareCall(plsql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); cs.registerOutParameter(1, OracleTypes.CURSOR); cs.setString(2, InputParam1); cs.registerOutParameter(3, Types.INTEGER); cs.execute(); ResultSet rs = null; rs = (ResultSet)cs.getObject(1); rs.last(); //code ends Any help will be very much appreciated. - Original Message - From: Mike Curwen [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Sent: Friday, October 17, 2003 03:12 PM Subject: RE: Java/JSP/Servlet Programmer I would send y'all my resume, but ever since the humiliation of the re-usable ResultSet, I'm sure I'm one of those that can't walk yet. ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 3:08 PM To: Tomcat Users List Subject: RE: Java/JSP/Servlet Programmer I agree. I'm getting funds to hire a new person and I dread it. I've screened a lot of people on the last time I hired someone an still got a lemon. Lot's of people talk to talk, but can't even walk yet. Thank You, Justin A. Stanczak Web Manager Shake Learning Resource Center Vincennes University (812)888-5813 Hart, Justin [EMAIL PROTECTED] 10/17/2003 03:00 PM Please respond to Tomcat Users List To: Tomcat Users List [EMAIL PROTECTED] cc: Subject:RE: Java/JSP/Servlet Programmer That's what I've found. The market is full of tech workers, but that doesn't mean that they're a programmer, or as familiar with technology X (for position Y) as they should be. I went to a job fair a couple years ago for 4 job opennings, 2 for programmers. 2
