Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: neutral (hermes.apache.org: local policy)
Message-ID: <418910D8.CE3951AA@Remulak.Net>
Date: Wed, 03 Nov 2004 09:09:44 -0800
From: Mamta Satoor <mamta@Remulak.Net>
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: Problems in using an SQL Client
References: <4f17b29304110302333c814f30@mail.gmail.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

My guess is that the Statement object is getting created with default
resultset TYPE_FORWARD_ONLY.
Is there a way to configure the client to create the Statement with
TYPE_SCROLL_INSENSITIVE?

Mamta

Amit Rao wrote:

> I have configured iSQL- Viewer and tried to connected to derby from
> it.I created a schem,table and inserted values into it...but when i
> run a simple select query i get the following error (on the console in
> iSQL).
>
> [15:51:12] Exception Occured While Retrieving Query Results
> [15:51:12] Runtime Exception::(com.ibm.db2.jcc.c.SqlException: This
> method should only be called on ResultSet objects that are
> scrollable(type TYPE_SCROLL_SENSITIVE or TYPE_SCROLL_INSENSITIVE))
>
> On reading around on the manual i came across the following in the
> reference manual for
> java.sql.Connection under section Table 15. JDBC 2.0 Connection
> Methods Supported
>
> Returns                           :  Statement
> Signature                        :  createStatement( int
> resultSetType, int resultSetConcurrency)
> Implementation Notes      :  ResultSet.TYPE_FORWARD_ONLY and
> ResultSet.TYPE_SCROLL_INSENSITIVE are the only scrolling types
> supported. If you request TYPE_SCROLL_SENSITIVE, Derby issues an
> SQLWarning and returns a TYPE_SCROLL_INSENSITIVE ResultSet.
>
> Any work-around for this???
> Please help
>
> Thanks,
> Amit