<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:D="DAV:" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:Z="urn:schemas-microsoft-com:" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Try switching to com.mysql.jdbc.Driver instead of the old mm.mysql
driver.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
opencms-dev-bounces@opencms.org [mailto:opencms-dev-bounces@opencms.org] <b>On
Behalf Of </b>simone.bortolaso@tiscali.it<br>
<b>Sent:</b> Thursday, July 03, 2008 2:52 PM<br>
<b>To:</b> opencms-dev@opencms.org<br>
<b>Subject:</b> [opencms-dev] Is there a way to tell OpenCms not hang?<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Hi all,<br>
to better explain the concept, the configuration of my server is as
follows<br>
<br>
<b> The virtual machine (JDK1.5) , Tomcat (5.5.25) , Apache 2.2.8 ,
Mysql5.0.47, RHL 5.0, Opencms 7.0.4</b> and<br>
<br>
in my project some jsp connect to an external database, which connector
is configured in my path /var/tomcat/conf/contex.xml.<br>
The problem stems from the fact that OpenCms hangs if the connector
context.xml, using my jsp, has problems like database shutdown or<br>
unreachable on the network.<br>
<br>
<b>Is there a way to tell OpenCms not hang?</b><br>
<br>
I configure the connector as follows, but the value maxWait 10 seconds is not
respected:<br>
<br>
<Resource name="jdbc/newsletter"<br>
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"<br>
type="javax.sql.DataSource"<br>
driverClassName="org.gjt.mm.mysql.Driver"<br>
url="jdbc:mysql://192.168.11.11:3306/newsletter"<br>
auth="Container"<br>
scope="Shareable"<br>
username="root"<br>
password="root"<br>
maxActive="50"<br>
maxIdle="10"<br>
maxWait="10000"<br>
removeAbandoned="true"<br>
removeAbandonedTimeout="60"<br>
logAbandoned="true"<br>
/><br>
<br>
The number of threads increase up to the value maxThread configured in
/var/tomcat/conf/server.xml<br>
and than all OpenCms threads waiting for monitor entry.<br>
<br>
<br>
"TP-Processor460" daemon prio=1 tid=0x6f8d9838 nid=0x634e waiting for
monitor entry [0x6c7fe000..0x6c7ff130]<br>
at org.opencms.db.CmsSqlManager.getConnectionByUrl(CmsSqlManager.java:
104) - waiting to lock <0x91a33c80> (a org.opencms.db.mysql.
CmsSqlManager) <br>
at org.opencms.db.generic.CmsSqlManager.getConnection(CmsSqlManager.
java:231) <br>
at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:
1905) <br>
at org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:
6387) <br>
at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.
java:5798) <br>
at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.
java:3987) <br>
at org.opencms.file.CmsObject.readResource(CmsObject.java:3470) <br>
at org.opencms.file.CmsObject.readResource(CmsObject.java:3437) <br>
at org.opencms.i18n.CmsDefaultLocaleHandler.getI18nInfo
(CmsDefaultLocaleHandler.java:103) <br>
at org.opencms.i18n.CmsLocaleManager.getI18nInfo(CmsLocaleManager.
java:767) <br>
at org.opencms.main.OpenCmsCore.initCmsObject(OpenCmsCore.java:2015) <br>
at org.opencms.main.OpenCmsCore.updateContext(OpenCmsCore.java:1657) <br>
at org.opencms.main.A_CmsAuthorizationHandler.registerSession
(A_CmsAuthorizationHandler.java:82) <br>
at org.opencms.security.CmsDefaultAuthorizationHandler.initCmsObject
(CmsDefaultAuthorizationHandler.java:73)<br>
at org.opencms.main.OpenCmsCore.initCmsObject(OpenCmsCore.java:2071) <br>
at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1489) <br>
at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:152) <br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) <br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) <br>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:269) <br>
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:188) <br>
at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:213) <br>
at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:174)
<br>
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:127) <br>
at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:117) <br>
at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:108)
<br>
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.
java:174) <br>
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:
200) <br>
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java: 283) <br>
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773) <br>
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.
java:703) <br>
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt
(ChannelSocket.java:895) <br>
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
(ThreadPool.java:689) <br>
at java.lang.Thread.run(Thread.java:595)<br>
<br>
thanks in advance,<br>
Simone<br>
_________________________________________________________________<br>
Tiscali Family: Adsl e Telefono senza limiti e senza scatto alla risposta. PER
TE CON LO SCONTO DEL 25% FINO AL 2010. In più il software parental control
Magic Desktop Basic è GRATIS! Attiva entro il 03/07/08. <a
href="http://abbonati.tiscali.it/promo/tuttoincluso/" target="_blank">http://abbonati.tiscali.it/promo/tuttoincluso/</a>
<o:p></o:p></p>
</div>
</body>
</html>