<!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>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></BODY></HTML>