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: pass (asf.osuosl.org: local policy)
Message-ID: <4344634C.1050906@nuix.com.au>
Date: Thu, 06 Oct 2005 09:35:40 +1000
From: Daniel Noll <daniel@nuix.com.au>
Organization: NUIX Pty Limited
User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: CLOBs and the Client driver
References: <4342312E.600@nuix.com.au> <4342BA4D.3000902@Source-Zone.Org>
 <4343109A.5080800@nuix.com.au> <43443D7E.6090907@Source-Zone.Org>
In-Reply-To: <43443D7E.6090907@Source-Zone.Org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Rajesh Kartha wrote:

> Hi Daniel,
>
> Please note that the DerbyClient does not support 
> ResultSet.TYPE_SCROLL_SENSITIVE or ResultSet.TYPE_SCROLL_INSENSITIVE 
> if the ResultSet has LOB.

Ah.  That would be it, then.  Now that I knew what to look for, I found 
an issue on JIRA to subscribe myself to. :-)

> In you example changing the PreparedStatement line to:
> reparedStatement 
> pstmt=conn.prepareStatement(selectTable,ResultSet.TYPE_FORWARD_ONLY,
>                   ResultSet.CONCUR_READ_ONLY);
>
> will take care of getting the actual CLOBs.  Do post to the list if 
> you come across any issues.

In this case I'm moving, say, forward 100 rows, and then forward one row 
at a time until row 200.  I'm sure this behaviour comes under the 
umbrella of "forward only", as I'm never moving backward.

However, absolute(101) throws an error, and relative(101) throws an error.

Am I really expected to call next() N times to get to the row I want?  
What if I want row 10,000?

Or is there some SQL syntax I'm supposed to use to limit the returned 
slice to rows 101-200 (I tried OFFSET/LIMIT, and can't see anything 
obvious in the Derby SQL reference which would suggest a feature like this.)

Daniel

-- 
Daniel Noll

NUIX Pty Ltd
Level 8, 143 York Street, Sydney 2000
Phone: (02) 9283 9010
Fax:   (02) 9283 9020

This message is intended only for the named recipient. If you are not
the intended recipient you are notified that disclosing, copying,
distributing or taking any action in reliance on the contents of this
message or attachment is strictly prohibited.