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]

Reply via email to