Thanks Brian!
-------- David -----Mensaje original----- De: Brian Johnson [mailto:[EMAIL PROTECTED] Enviado el: jueves, 29 de mayo de 2003 22:30 Para: [EMAIL PROTECTED] Asunto: Re: SQLTransformer bug 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
