I reported this bug and posted a fix many months ago, but nothing has been done with it. It seems to only affect certain databases. I'd be glad to forward you the code.
Brian


On Wednesday, May 28, 2003, at 09:36 AM, Carmona Perez, David wrote:

Dear Cocooners,

I've think I found a bug in the SQLTransformer in Cocoon 2.0.4, at least under Informix.

I use a simple query (select * from table) and it fails. After having investigated a bit, I've come to the conclusion that it tries to do the following

open connection
create prepared statement
get resultset
close connection
navigate through the gathered resultset

Of course when navigating through the resultset, you get an SQLException.
If I comment out the connection closing, everything works ok.


The right order would need to be:

open connection
create prepared statement
get resultset
navigate through the gathered resultset
close connection


Has this happened to anyone else?


--------
David


--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to