<!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 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY style="COLOR: #000000; FONT-FAMILY: Arial" bgColor=#ffffff>
<DIV><FONT size=2>Steve, thanks for posting this. I was observing exactly the
same symptoms you were -- if I hadn't used the site for awhile, then logged on,
the first few pages would have these errors. Then I just kept going for a few
pages they would clear up. I added ?autoReconnect = true to all my MySQL
connection pools and the issue cleared up for me too.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Note: I had never observed this on my home PC -- only started
seeing it once I put OpenCMS up on an ISP hoster. Must be the ISP hoster has
different MySQL settings than the default I get on my own system. </FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Probably a good FAQ item ;-></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=steven@livingimpact.com.my
href="mailto:steven@livingimpact.com.my">Steve</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>Sent:</B> Thursday, June 12, 2003 6:42
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [opencms-dev] Communication Link
problem</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>Hello all,</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2> I think I finally found the problem, it
maybe because that the mySQL wait_timeout variable is set to 100 miliseconds.
Since I cannot update the mySQL server's variable on hosting service. I
just add to the connection URL
jdbc:mysql://localhost:3306/test_cms?autoReconnect=true. That's
all.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2> Thanks to all.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Steven Ho.</FONT></DIV></BLOCKQUOTE></BODY></HTML>