<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">wops, thank you. I don't know how I
missed that one... I'll try it out. Thanks.<br>
<br>
El 17/10/12 22:37, Tim Howland escribió:<br>
</div>
<blockquote cite="mid:-9033907592450651702@unknownmsgid" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<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
moz-do-not-send="true" 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 moz-do-not-send="true"
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 moz-do-not-send="true"
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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
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
<a class="moz-txt-link-freetext" href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a>
</pre>
</blockquote>
<br>
</body>
</html>