cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vadim Gritsenko" <vgritse...@hns.com>
Subject RE: [C2.0/1] Error in SQLTransformer??
Date Mon, 09 Jul 2001 20:09:27 GMT
Check CVS version of transformer - IIRC this issue is already resolved.

Vadim

> -----Original Message-----
> From: Lajos Moczar [mailto:lmocz@galatea.com]
> Sent: Monday, July 09, 2001 15:20
> To: cocoon-users@xml.apache.org
> 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: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
> 
> 

---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message