<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4522.1800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY style="COLOR: #000000; FONT-FAMILY: Arial" bgColor=#ffffff>
<DIV><FONT size=2>Hello, </FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2> Thanks for taking your time to answer my
question, I have altered the opencms.properties file parameter timeout and
maxage of mysql pool but without any improvement. I am still getting the same
message. </FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2> Can anyone please help.
Thanks.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Steven Ho </FONT></DIV>
<DIV><FONT size=2><A
href="mailto:steven@livingimpact.com.my">steven@livingimpact.com.my</A></FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=Brendon.Price@sytec.co.nz
href="mailto:Brendon.Price@sytec.co.nz">Brendon Price</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=opencms-dev@opencms.org
href="mailto:'opencms-dev@opencms.org'">'opencms-dev@opencms.org'</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=steven@livingimpact.com.my
href="mailto:'steven@livingimpact.com.my'">'steven@livingimpact.com.my'</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, June 11, 2003 11:32
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [opencms-dev] Communication
Link Error</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2><SPAN class=520521803-11062003>Steve,</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=520521803-11062003></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=520521803-11062003>I haven't looked at this much
myself, but It looks like it is set with the opencms.properties
file,</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=520521803-11062003>From the source code of
OpenCMS it says:</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=520521803-11062003></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN
class=520521803-11062003>com.opencms.dbpool.CmsPool.java</SPAN></FONT></DIV>
<DIV><SPAN class=520521803-11062003>
<P><FONT size=2>/**</FONT></P>
<P><FONT size=2>* Test the connection by executing an select statement. This
is done</FONT></P>
<P><FONT size=2>* only if the statement is defined in opencms.properties.
Normally there</FONT></P>
<P><FONT size=2>* is no need for this testing - but in difficult environments
(like firewalls)</FONT></P>
<P><FONT size=2>* you can use it to find out whats going wrong.</FONT></P>
<P><FONT size=2>* @param con The connection to test.</FONT></P>
<P><FONT size=2>* @return true if the connection could be tested without an
SQLException.</FONT></P>
<P><FONT size=2>* Returns true if there is no test-statement defined in
opencms.properties.</FONT></P>
<P><FONT size=2>* Returns false if there was an SQLException by executing the
statement.</FONT></P>
<P><FONT size=2><SPAN class=520521803-11062003>*/</SPAN></FONT></P>
<P><FONT size=2><SPAN class=520521803-11062003></SPAN></FONT> </P><FONT
size=2><SPAN class=520521803-11062003>
<DIV><FONT size=2><SPAN class=520521803-11062003>The property to use is shown
here; but choose your own select query (keep it simple).</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=520521803-11062003><FONT size=2><SPAN
class=520521803-11062003>pool.mysql.testQuery=select count(*) from
CMS_USERS</SPAN></FONT></SPAN></FONT></DIV></SPAN></FONT>
<P><FONT size=2><SPAN class=520521803-11062003></SPAN></FONT> </P>
<P><FONT size=2><SPAN class=520521803-11062003>Regards</SPAN></FONT></P>
<P><FONT size=2><SPAN
class=520521803-11062003>Brendon</SPAN></FONT></P></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Steve
[mailto:steven@livingimpact.com.my]<BR><B>Sent:</B> Wednesday, 11 June 2003
3:16 p.m.<BR><B>To:</B> opencms-dev@opencms.org<BR><B>Subject:</B> Re:
[opencms-dev] Communication Link Error<BR><BR></DIV></FONT>
<DIV><FONT size=2>Hi all,</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2> I already contacted the hosting company
and they claim that there is no firewall for the mysql server. Btw how to
set connection pool to use "keep alives"? Is the setting done in opencms or
mysql server?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Thanks a lot,</FONT></DIV>
<DIV><FONT size=2>Steven Ho</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=Brendon.Price@sytec.co.nz
href="mailto:Brendon.Price@sytec.co.nz">Brendon Price</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=opencms-dev@opencms.org
href="mailto:'opencms-dev@opencms.org'">'opencms-dev@opencms.org'</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A
title=steven@livingimpact.com.my
href="mailto:'steven@livingimpact.com.my'">'steven@livingimpact.com.my'</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, June 11, 2003 10:28
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [opencms-dev]
Communication Link Error</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2><SPAN class=495222202-11062003>Hi
Steve,</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN
class=495222202-11062003></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN class=495222202-11062003>Just guessing, but
i</SPAN></FONT><FONT size=2><SPAN class=495222202-11062003>s it possible
that your connection to your database is via a firewall that times out
your database connections?</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=495222202-11062003>I know we have had
similar issues in the past with other applications we have hosted. If
the connection pool uses "keep alives" you can avoid this problem. If it
is indeed this problem that is actually occurring.</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN
class=495222202-11062003></SPAN></FONT> </DIV>
<DIV><FONT size=2><SPAN
class=495222202-11062003>Regards</SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN
class=495222202-11062003>Brendon</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Steve
[mailto:steven@livingimpact.com.my]<BR><B>Sent:</B> Wednesday, 11 June
2003 2:00 p.m.<BR><B>To:</B> opencms-dev@opencms.org<BR><B>Subject:</B>
[opencms-dev] Communication Link Error<BR><BR></DIV></FONT>
<DIV><FONT size=2>Hi all,</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2> I have deployed a website using
which occasionally have error mesg that display mysql exception:
communication link error. The current workaround I have now is to use a
webpage that keep refreshing the website, this way the communication
link would not appear. </FONT></DIV>
<DIV><FONT size=2> Anyone have experience in this, I
have surf the archive b4 and tried updating mysql-J connector to the
latest release. But nothing work.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Thanks in advance,</FONT></DIV>
<DIV><FONT size=2>Steven Ho</FONT></DIV>
<DIV><FONT
size=2></FONT> </DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>