Check CVS version of transformer - IIRC this issue is already resolved.
Vadim
> -----Original Message-----
> From: Lajos Moczar [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 15:20
> To: [EMAIL PROTECTED]
> Subject: [C2.0/1] Error in SQLTransformer??
>
>
> I've been trying to find out why SQLTransformer has empty result sets.
> After various debug statements, I realized that the "finally" clause in
> the execute() method of the Query object in SQLTransformer.java is
> closing and releasing the connection after the query is executed. Does
> anyone know why this is? I commented out the close/release statements
> and now all my queries work!
>
> Obviously, there needs to be a release of the connection back to the
> pool, but it needs to occur after all result rows have been read. So
> I've added a call to query.close() at the end of the executeQuery()
> method. Anyone know if this is the intended behavior or am I way off here?
>
>
> Lajos Moczar
> galatea.com
>
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>