Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cocoon-users@xml.apache.org
Date: 29 May 2003 22:52:47 +0200
Message-ID: <001f01c32624$4334fc90$a501a8c0@computer2>
From: "Andreas Kuckartz" <A.Kuckartz@ping.de>
To: cocoon-users@xml.apache.org
References: <569C2278-9214-11D7-B39C-000393DB9A58@yahoo.com>
Subject: Re: SQLTransformer bug
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

That seems to be this one:

[PATCH] SQLTransformer Query object prematurely closes connection causing
NullPointerException when accessing ResultSet
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=12173

Andreas

----- Original Message ----- 
From: "Brian Johnson" <johnsbrn@yahoo.com>
To: <cocoon-users@xml.apache.org>
Sent: Thursday, May 29, 2003 10:30 PM
Subject: 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: cocoon-users-unsubscribe@xml.apache.org
> > For additional commands, e-mail: cocoon-users-help@xml.apache.org
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org