Re: how to get ScrollableResultSet? More question with this.

Article View: borland.public.jbuilder.java.language

Article #8554

Back to borland.public.jbuilder.java.language Previous Next

#8554

From: Torsten Welches
Date: Wed, 14 Mar 2001 06:32

28 lines
1734 bytes

Stephen,

ResultSet.last() does not work for TYPE_FORWARD_ONLY result sets.
Check the documentation, it states this clearly.
http://java.sun.com/j2se/1.3/docs/api/java/sql/ResultSet.html#last()

Torsten

"Stephen Zeng" <chinafax1@cmmail.com> wrote:
>
>"Stephen Zeng" <chinafax1@cmmail.com> wrote in message
>news:3aaedb3a_1@dnews...
>> I use Connection.createStatement and
>> ResultSet rs=sqlstr.executeQuery(psql);
>>
>> The ResultSet is forward only.  How to get  ScrollableResultSet?
>>
>>
>
>when I use rs.isLast(), show error ResultSet is forward only. How to use
>this isLast() method?
>while(rs.next()) {
>      if (!rs.isLast()) {
>        ......
>        }
>
>

Technical Details

Message-ID: <3aaf1094$1_1@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!news-out.usenetserver.com!news-out-sjo.usenetserver.com!feed2.onemain.com!feed1.onemain.com!isdnet!newsfeed.icl.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!bornews.borland.com!dnews!207.105.83.65

References: <3aaedb3a_1@dnews> <3aaedd04_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f74b3,d4ca4bd6e1361e2b
X-Google-Attributes: gidf74b3,public
X-Google-ArrivalTime: 2001-03-13 22:44:04 PST
From: "Torsten Welches" <torsten.welches@who.cares.netcologne.de>
Sender: "Torsten Welches" <torsten.welches@who.cares.netcologne.de>
Reply-To: "Torsten Welches" <torsten.welches@who.cares.netcologne.de>
Subject: Re: how to get ScrollableResultSet? More question with this.
Newsgroups: borland.public.jbuilder.java.language
X-User-Info: 193.158.55.74 193.158.55.74    
References: <3aaedb3a_1@dnews>  <3aaedd04_2@dnews> 
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3aaf1094$1_1@dnews>
Date: 13 Mar 2001 22:32:52 -0800
X-Trace: 13 Mar 2001 22:32:52 -0800, 207.105.83.65
Lines: 29
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!news-out.usenetserver.com!news-out-sjo.usenetserver.com!feed2.onemain.com!feed1.onemain.com!isdnet!newsfeed.icl.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!bornews.borland.com!dnews!207.105.83.65

Reply to Parent Message