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 PROTECTED]
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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/krank%
40logicunited.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
