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]>
