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
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
[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
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
[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
-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
:[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
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
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
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
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
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
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
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
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
, 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
-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
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
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
19 matches
Mail list logo