DO NOT REPLY [Bug 16878] - Exception while using (TYPE_SCROLL_INSENSITIVE) ResultSet in Tomcat 4.0

2003-02-09 Thread bugzilla
/show_bug.cgi?id=16878 Exception while using (TYPE_SCROLL_INSENSITIVE) ResultSet in Tomcat 4.0 [EMAIL PROTECTED] changed: What|Removed |Added Status|UNCONFIRMED

DO NOT REPLY [Bug 16878] New: - Exception while using (TYPE_SCROLL_INSENSITIVE) ResultSet in Tomcat 4.0

2003-02-07 Thread bugzilla
/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

Re: ResultSet

2002-05-29 Thread Manuel Rodriguez Diaz
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

RE: ResultSet

2002-05-29 Thread Anand Bashyam Narasimhan
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

ResultSet

2002-05-28 Thread Manuel Rodriguez Diaz
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

RE: ResultSet

2002-05-28 Thread James Mitchell
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

ResultSet

2002-03-11 Thread Paul Wallace
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) !=

RE: ResultSet

2002-03-11 Thread Ed Yu
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

Re: ResultSet

2002-03-11 Thread Micael Padraig Og mac Grene
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

problems with resultSet

2001-05-29 Thread Enrique Prados Valiente
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