From: Waswa b. <wa...@gm...> - 2007-03-22 08:45:41
|
Dear Winarno, My 1 pence advice: The cause may be that mysql drops the connection after some time (I think 8 hours) if there is no activity. You can use the <reconnectTime> parameter of the mysql database resource in the config.xml file to force a reconnection if more than a given time elapsed since last activity. For instance, the following entry forces a reconnection after one hour: <resource enabled="false"> <name>main-db</name> <provider>jeeves.resources.dbms.DbmsPool</provider> <config> <user>admin</user> <password>admin</password> <driver>com.mysql.jdbc.Driver</driver> <url>jdbc:mysql://$WEBSERVER_HOST/geonetwork</url> <poolSize>4</poolSize> <reconnectTime>3600</reconnectTime> </config> </resource> Regards, Stephen Waswa FAO-SWALIM Nairobi, Kenya. On 3/22/07, Tim Jacobs <jac...@ho...> wrote: > > Dear Winarno, > > Maybe your JDBC connection pool (if you have one) is exhausted. > Are there any messages in the logs of Tomcat? > > If this is the case, you may want to set up Tomcat to recycle idle > connections after a certain time. > This is one of the properties of your JDBC connector, if I'm not mistaken. > I > can't really give you any more details, though. > > Regards, > > Tim > > > >From: "Winarno Makmur Jaya" <neo...@gm...> > >To: geo...@li... > >Subject: [GeoNetwork-users] JDBC Conection failed > >Date: Thu, 22 Mar 2007 10:34:35 +0700 > > > >Dear Geonetwork Users, > > > >My name Winarno from Indonesia new geonetwork user. > >I Install Geonetwork on my Server and so far running well. But i have > >problem, every morning when i want searching metadata, i get error like > >JDBC > >conection failed. And then when i restart Tomcat the problem solve. and I > >have to restart Tomcat every morning. > > > >Any idea for solve my problem ? > > > >Thanks, > > > >Winarno > >------------------------------------------------------------------------- > >Take Surveys. Earn Cash. Influence the Future of IT > >Join SourceForge.net's Techsay panel and you'll get the chance to share > >your > >opinions on IT & business topics through brief surveys-and earn cash > >http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > >_______________________________________________ > >GeoNetwork-users mailing list > >Geo...@li... > >https://lists.sourceforge.net/lists/listinfo/geonetwork-users > >GeoNetwork OpenSource is maintained at > >http://sourceforge.net/projects/geonetwork > > _________________________________________________________________ > All things trendy for Windows Live Messenger ... > http://entertainment.msn.be/funwithmessenger > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > GeoNetwork-users mailing list > Geo...@li... > https://lists.sourceforge.net/lists/listinfo/geonetwork-users > GeoNetwork OpenSource is maintained at > http://sourceforge.net/projects/geonetwork > -- Stephen B. Waswa Somalia Water and Land Information Management System, Food and Agriculture Organization of the United Nations, P.O. Box 30470 -00100 Nairobi (Kenya) Office: 3rd Floor Kalson Tower, Crescent Road, Parklands, Nairobi Tel: + 254 20 3743464 Fax: +254 20 3743498 Cellphone +254 721 826 320 e-mail: sw...@fa... wa...@gm... wa...@ya... www.faoswalim.org |