<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>set up your database pool to test on borrow, usually a select 1 from dual is the test query on oracle.<br><br>Sent from my iPhone</div>
<div><br>On Oct 17, 2012, at 4:32 PM, Jordi Marti <<a href="mailto:jmarti@theinit.com">jmarti@theinit.com</a>> wrote:<br><br></div><blockquote type="cite"><div>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
Hi,<br>
<br>
I think I have the same issue as described here:<br>
<br>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<a href="http://old.nabble.com/Re%3A-FW%3A-OpenCMS-JDBC-connection-hangs-Oracle-database-p2221312.html">http://old.nabble.com/Re%3A-FW%3A-OpenCMS-JDBC-connection-hangs-Oracle-database-p2221312.html</a><br>
<br>
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.<br>
<br>
Does anybody know any mechanism that I can configure to avoid this?
<br>
<br>
Regards and thanks,<br>
<br>
Jordi<br>
<br>
<br>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>This mail is sent to you from the opencms-dev mailing list</span><br><span>To change your list options, or to unsubscribe from the list, please visit</span><br>
<span><a href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a></span><br><span></span><br><span></span><br><span></span><br></div></blockquote>
</body></html>