[GeoNetwork-users] JDBC Conection failed

Winarno_Makmur_Jaya · March 22, 2007, 3:34am

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

Tim_Jacobs · March 22, 2007, 8:15am

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" <neowinarno@anonymised.com>
To: geonetwork-users@lists.sourceforge.net
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
GeoNetwork-users@lists.sourceforge.net
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

Waswa_Steve · March 22, 2007, 8:45am

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:

<provider>jeeves.resources.dbms.DbmsPool</provider>

<user>admin</user>

<password>admin</password>

<driver>com.mysql.jdbc.Driver</driver>

<url>jdbc:mysql://$WEBSERVER_HOST/geonetwork</url>

</config>

</resource>

Regards,
Stephen Waswa
FAO-SWALIM
Nairobi,
Kenya.

On 3/22/07, Tim Jacobs <jacobs_tim100@anonymised.com> 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" <neowinarno@anonymised.com>
>To: geonetwork-users@lists.sourceforge.net
>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
>GeoNetwork-users@lists.sourceforge.net
>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
GeoNetwork-users@lists.sourceforge.net
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: swaswa@anonymised.com
waswabs@anonymised.com
www.faoswalim.org