[opencms-dev] Communication Link Error

[Brendon Price]

Steve,
 
I haven't looked at this much myself, but It looks like it is set with the
opencms.properties file,
>From the source code of OpenCMS it says:
 
com.opencms.dbpool.CmsPool.java
/**

* Test the connection by executing an select statement. This is done

* only if the statement is defined in opencms.properties. Normally there

* is no need for this testing - but in difficult environments (like
firewalls)

* you can use it to find out whats going wrong.

* @param con The connection to test.

* @return true if the connection could be tested without an SQLException.

* Returns true if there is no test-statement defined in opencms.properties.

* Returns false if there was an SQLException by executing the statement.

*/

 

The property to use is shown here; but choose your own select query (keep it
simple).
pool.mysql.testQuery=select count(*) from CMS_USERS

 

Regards

Brendon

-----Original Message-----
From: Steve [mailto:steven at livingimpact.com.my]
Sent: Wednesday, 11 June 2003 3:16 p.m.
To: opencms-dev at opencms.org
Subject: Re: [opencms-dev] Communication Link Error


Hi all,
 
    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?
 
Thanks a lot,
Steven Ho

----- Original Message ----- 
From: Brendon Price <mailto:Brendon.Price at sytec.co.nz>  
To: 'opencms-dev at opencms.org' <mailto:'opencms-dev at opencms.org'>  
Cc: 'steven at livingimpact.com.my' <mailto:'steven at livingimpact.com.my'>  
Sent: Wednesday, June 11, 2003 10:28 AM
Subject: RE: [opencms-dev] Communication Link Error

Hi Steve,
 
Just guessing, but is it possible that your connection to your database is
via a firewall that times out your database connections?
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.
 
Regards
Brendon

-----Original Message-----
From: Steve [mailto:steven at livingimpact.com.my]
Sent: Wednesday, 11 June 2003 2:00 p.m.
To: opencms-dev at opencms.org
Subject: [opencms-dev] Communication Link Error


Hi all,
 
    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. 
    Anyone have experience in this, I have surf the archive b4 and tried
updating mysql-J connector to the latest release. But nothing work.
 
Thanks in advance,
Steven Ho
 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20030611/0f82b6b8/attachment.htm>