cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Morrison, John" <>
Subject RE: SQL Transformer
Date Thu, 17 Apr 2003 13:45:11 GMT
Irving Salisbury wrote:
> Boon Hian Tek wrote:
>> Irving Salisbury wrote:
>>> At our company, we have now had two instances where we would have
>>> like to extend the SQLTransformer. For one of them, we wanted to do
>>> paging utilizing the ResultSet methods setFetchSize and absolute().
>>> The current PagingTransformer loads the entire ResultSet in, which
>>> wouldn't work for our enromous ResultSets. We succesfully wrote
>>> this, but the way we had to do it was to take the existing
>>> SQLTransformer and "hack" into it.  It was not very easy to get at
>>> the very reusable class Query
>> I just realized that too. I almost wanted to go through what you did.
>> Any chance you can share the mods you made and
>> is using? Or is it proprietary code?
>> Boon
> It is not proprietary code.  It is a little "ugly", but I am happy to
> share it.  We are using it on a reasonably large system, and it seems
> to be working well.  I'll just send it to you so I don't spam this
> whole list. (Unless others want it)  I should be able to bundle it up
> and send it in about 2 hours.

Patches welcome :)


PS, Irving, *please* don't mix top and bottom posting :)

Information in this email and any attachments are confidential, and may
not be copied or used by anyone other than the addressee, nor disclosed
to any third party without our permission.  There is no intention to
create any legally binding contract or other commitment through the use
of this email.
Experian Limited (registration number 653331).
Registered office: Talbot House, Talbot Street, Nottingham NG1 5HF

View raw message