Re: how to get ScrollableResultSet?

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

Article #8555

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

#8555

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

15 lines
1407 bytes

Stephen,

1. how did you create your Statement, it should be something 
like this:
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);

2. Not all JDBC drivers support scrollable result sets. 
You can check it with DatabaseMetaData.supportsResultSetType.

Torsten

"Stephen Zeng" <chinafax1@cmmail.com> wrote:
>I use Connection.createStatement and
>ResultSet rs=sqlstr.executeQuery(psql);

Technical Details

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

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!colt.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>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f74b3,43b15916b98056cd
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?
Newsgroups: borland.public.jbuilder.java.language
X-User-Info: 193.158.55.74 193.158.55.74    
References:  <3aaedb3a_1@dnews> 
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3aaf0f35$1_1@dnews>
Date: 13 Mar 2001 22:27:01 -0800
X-Trace: 13 Mar 2001 22:27:01 -0800, 207.105.83.65
Lines: 15
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!colt.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