/show_bug.cgi?id=16878
Exception while using (TYPE_SCROLL_INSENSITIVE) ResultSet in Tomcat 4.0
[EMAIL PROTECTED] changed:
What|Removed |Added
Status|UNCONFIRMED
/show_bug.cgi?id=16878
Exception while using (TYPE_SCROLL_INSENSITIVE) ResultSet in Tomcat 4.0
Summary: Exception while using (TYPE_SCROLL_INSENSITIVE)
ResultSet in Tomcat 4.0
Product: Tomcat 4
Version: 4.0.3 Final
Platform: Other
OS
Thankyou.
I've just tried this.
In fact i write a select count(1) which is faster (for a reason i don't know).
The problem is that in many cases i have a group clause that cause problems with
this method.
So i thought this:
resultset= statement.CreateQuery();
resultset2= resultset;
Obviously
count(*)... would be the option I would go with.
Anand
-Original Message-
From: Manuel Rodriguez Diaz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 1:00 PM
To: Tomcat Developers List
Subject: Re: ResultSet
Thankyou.
I've just tried this.
In fact i write a select count(1) which
Hi all,
I'm working with java 1.1. (this is a mandatory requirement).
In this version of Java, resultset are FORWARD ONLY.
The fact is that i need to count the rows contained in a resultset
before displaying its data and the way i've thought to do this is read
all the resultset.
rows= 0;
while
Col1, Col2
String sqlFrom = From myTable
String sqlWhere = Where Col3 = 'SomeVal';
//typically a helper function
//execute the sql on your connection
Resultset rs = getMyResults(Select count(*) as ct + sqlFrom + sqlWhere);
size = rs.getLong(ct)
//proceed as you did before, but this time you
Hi,
For the brave, can anyone guess why with this rather unsociable code:
if ((res.getString(3) == null) || (res.getString(3) == )) {
out.println(tda href=takeDetails.jsp?timeSlot= +
res.getString(2) + myDate= + myDate + + res.getString(2) +
/a/td);
}
if ((res.getString(3) !=
empty string '' and null value,
just becareful of that!
-Original Message-
From: Paul Wallace [SMTP:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 3:58 AM
To: Tomcat Developers List
Subject: ResultSet
Hi,
For the brave, can anyone guess why with this rather unsociable
If you want to compare String objects as literals, use the intern() method.
Micael
At 03:58 PM 3/11/02 +0700, you wrote:
Hi,
For the brave, can anyone guess why with this rather unsociable code:
if ((res.getString(3) == null) || (res.getString(3) == )) {
out.println(tda
hi,
Hi!
I'm using Tomcat and JSP but there are problem, my JSP don' work.
I have this code in my JSP
(code.)
Statement
s=cn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_
READ_ONLY);
(more code)
In begin of my JSP there is this code line %@ page
10 matches
Mail list logo