[opencms-dev] Opencms 8 and Oracle

[Tim Howland]

set up your database pool to test on borrow, usually a select 1 from dual
is the test query on oracle.

Sent from my iPhone

On Oct 17, 2012, at 4:32 PM, Jordi Marti <jmarti at theinit.com> wrote:

 Hi,

I think I have the same issue as described here:


http://old.nabble.com/Re%3A-FW%3A-OpenCMS-JDBC-connection-hangs-Oracle-database-p2221312.html

A firewall between the DMZ and the database "kills" the connections between
opencms and oracle (due to inactivity). I think OpenCMS is not aware of
this, and then, it hangs while trying to retrieve any page. The only way to
make it work is restarting the server.

Does anybody know any mechanism that I can configure to avoid this?

Regards and thanks,

Jordi


_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20121017/5924b35f/attachment.htm>