cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vadim Gritsenko" <>
Subject RE: [C2] SQLTransformer
Date Wed, 08 Aug 2001 13:13:31 GMT

I don't know what version of SQLTransformer you are talking about,
IIRC this was fixed in CVS a weeks ago. If not, please show these 
lines of code.

Right now ($Revision: from cocoon_20_branch), query is executed
in method "executeQuery(int index)", and it also extracts all results in
"while (" loop, and then connection is closed in "finally" statement.


> -----Original Message-----
> From: []
> Sent: Tuesday, August 07, 2001 2:41 PM
> To:
> Subject: [C2] SQLTransformer
> Hi all,
> There's a serious bug in the SQLTransformer: a query gets executed, and
> after that the results are sucked out of it. Now, the moment the query is
> executed, its Connection is given back to the Pool it belongs is (which is
> good). But, if this Connection is reused before the results are sucked out
> of it, serious problems arise (genre NullPointerException).
> The problem does not arise ATM with the Excalibur that is in C2 now, because
> that also has a serious bug in it (which I will report and patch tomorrow to
> the Avalon people).
> I'm working on a solution for the SQLTransformer, but I need one piece of
> information: can I trust C2 to execute recycle() or dispose() as soon as the
> pipeline has ended executing? This would allow me to allocate a Connection
> in the setup(), and throw it back in the Pool in the recycle() resp.
> dispose().
> Once this is solved, I will of course send the patch to the list, but I need
> this information to be able to patch it.
> Thanks a lot,
> tomK
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, email:

To unsubscribe, e-mail:
For additional commands, email:

View raw message