cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andy Stevens" <insomniacpeng...@googlemail.com>
Subject Re: Database connection problems
Date Wed, 07 May 2008 16:05:12 GMT
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


Mime
View raw message