cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Derek Hohls" <DHo...@csir.co.za>
Subject Re: Database connection problems
Date Thu, 08 May 2008 06:14:54 GMT
Andy

I am assuming that Cocoon cannot connect to the DB;
the issue is why.  The browser hangs indefinitely, and
there is no message in the cocoon.log.  Also, there does
not appear to be ant errors.log or handled-errors.log files
in the "cocoon/WEB-INF/logs" directory ... should there be?
The app and DB are running on the same machine (though
in future they may be on different machines).

PS See also my reply to Jeroen.

>>> On 2008/05/07 at 06:05, in message <efe2a0400805070905mbc25dfexad389187a30c6403@mail.gmail.com>,
"Andy Stevens" <insomniacpenguin@googlemail.com> wrote:
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 


-- 
This message is subject to the CSIR's copyright terms and conditions, e-mail legal notice,
and implemented Open Document Format (ODF) standard. 
The full disclaimer details can be found at http://www.csir.co.za/disclaimer.html.

This message has been scanned for viruses and dangerous content by MailScanner, 
and is believed to be clean.  MailScanner thanks Transtec Computers for their support.



-- 
This message is subject to the CSIR's copyright terms and conditions, e-mail legal notice,
and implemented Open Document Format (ODF) standard. 
The full disclaimer details can be found at http://www.csir.co.za/disclaimer.html.

This message has been scanned for viruses and dangerous content by MailScanner, 
and is believed to be clean.  MailScanner thanks Transtec Computers for their support.


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


Mime
View raw message