<!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.00.3315.2870" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff style="COLOR: #000000; FONT-FAMILY: Arial">
<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 align=left class=OutlookMessageHeader dir=ltr><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="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A href="mailto:Brendon.Price@sytec.co.nz"
title=Brendon.Price@sytec.co.nz>Brendon Price</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
href="mailto:'opencms-dev@opencms.org'"
title=opencms-dev@opencms.org>'opencms-dev@opencms.org'</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A
href="mailto:'steven@livingimpact.com.my'"
title=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 align=left class=OutlookMessageHeader dir=ltr><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></BODY></HTML>