db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: Paging Result Sets
Date Fri, 02 May 2008 15:01:32 GMT
Six Fried Rice wrote:
> On Apr 28, 2008, at 8:02 AM, Rick Hillegas wrote:
>
>> The new 10.4 release provides support for the sql standard ROW_NUMBER 
>> function, which you can use for paging through query results. You can 
>> find this function documented in the ROW_NUMBER subsection of the 
>> "Built-in functions" section of the 10.4 Reference Manual.
>
> Thanks for the info. I have another developer working on this part, 
> and he reports that, ie, this query:
>
>> select * from (select row_number() over() as rownum, 
>> table_occurrence.* from table_occurrence) as temp where rownum>=1 and 
>> rownum<=10
>
> Works as expected when executed through the IJ console. But when 
> executed through the JDBC application, he gets this error:
>
>> 1147 FATAL [http-8080-Processor25] 
>> com.sixfriedrice.lumen.ddrserver.utility.BuildQuery - Error in query 
>> :java.sql.SQ
>> LSyntaxErrorException: Syntax error: Encountered "(" at line 1, 
>> column 40.
>
> Does that make sense to anyone?
Hi Geoff,

That's the error you'll get if you execute the query in a Derby release 
that doesn't support the ROW_NUMBER function (e.g., Derby 10.3). So I 
would have double checked that the JDBC application in fact uses Derby 
10.4. derby.log should tell you which version was used.

-- 
Knut Anders

Mime
View raw message