Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@cocoon.apache.org
Received-SPF: pass (athena.apache.org: domain of
 insomniacpenguin@googlemail.com designates 74.125.46.157 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=googlemail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=tYy3nXbukudPqfrD7MYUCUZjgyhlK7L6Iy0UQ7Tlo2sVxaBoT2uWEEFYMrwL7i2TeJiBW/S3Ym4hT1zssJIYpiEXr0HGbDvX+IwYbpzDv+tDDzUo8yIliPSo254+nbygRjaMzj7fMu9GwEdTFLgTSZaMkbiqfSN7Xwf0pP7gh2g=
Message-ID: <efe2a0400805070905mbc25dfexad389187a30c6403@mail.gmail.com>
Date: Wed, 7 May 2008 17:05:12 +0100
From: "Andy Stevens" <insomniacpenguin@googlemail.com>
To: users@cocoon.apache.org
Subject: Re: Database connection problems
In-Reply-To: <4821C83C.5CE9.00D4.0@csir.co.za>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <4821C83C.5CE9.00D4.0@csir.co.za>

2008/5/7 Derek Hohls <DHohls@csir.co.za>:
> Using Cocoon 2.1.8
>
> I have an app which has been working fine... up to now.
> I am now in a situation where:
> * the "plain" pages on the website (ie. not accessing the
> database) display just fine
> * I can access the database from a 3rd party tool (the
> MySQL Query Browser) without any problems
>
> BUT I am unable to retrieve any database data via the
> interface... the browser simply shows me its hourglass
> and there is no further response.  I have looked at the
> Cocoon log and the Tomcat log but even the URLs do
> not show up in these.

Are you sure Cocoon is actually managing to connect to the database?
You say "there is no further response" - how long are you waiting?
I'm not sure about the other database components, but certainly in the
case of the SQLTransformer if it can't get a connection it will (by
default) retry 5 times at 5 second intervals, so it could be 30
seconds before you actually get an error message returned.  And if
it's waiting on a TCP-level timout ConnectException (e.g. because the
port is blocked by a firewall and the packets are being dropped rather
than actually rejecting the connection) that could involve a 20 second
timeout in itself...
I'd have thought you'd still see something in Cocoon's errors.log or
handled-errors.log, though.
You say you can access the database okay yourself; is the application
running locally on the same machine, or is it deployed on some other
server?


Andy
-- 
http://pseudoq.sourceforge.net/  Open source java Sudoku solver

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