Re: smarter fetch limits
Re: smarter fetch limits
- Subject: Re: smarter fetch limits
- From: Anjo Krank <email@hidden>
- Date: Wed, 16 Nov 2005 07:18:48 +0100
The easiest way would be to subclass the openbase plugin and
expression class, override the expressionsClass() to return your
subclass and the creation of the select statement and append the sql
you want if a fetchspec has limits. Take a look at Wonder's
PostgresqlExpression. The you need to set your plugin class via some
method in the jdbcadaptor so that it gets picked instead of the
default. Which one you need to find out yourself, I don't have WO here.
Am 15.11.2005 um 22:27 schrieb Alex Cone:
So I am trying to avoid a known EOF gotcha. I would like to make
use of server-side
fetch limiting. In OpenBase one can append RETURN RESULTS X where
X is the
fetchLimit. I'm trying to find a nice generic way to add this to
ad-hoc fetch spec
generated SQL. Anyone got a good insertion point? The JDBCPlugin
api does not
provide access to the fetch spec or the fetch limit during SQL
generation.
abc
___alex b cone___
ceo codefab inc
212 465-8484 x101
email@hidden
http://www.codefab.com
... my other signature is terribly clever.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40logicunited.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden