Return-Path: Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org Received: (qmail 89839 invoked from network); 17 Nov 2006 16:42:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 17 Nov 2006 16:42:50 -0000 Received: (qmail 71549 invoked by uid 500); 17 Nov 2006 16:42:59 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 71537 invoked by uid 500); 17 Nov 2006 16:42:59 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 71528 invoked by uid 99); 17 Nov 2006 16:42:59 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 17 Nov 2006 08:42:59 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of milant@gmail.com designates 64.233.182.184 as permitted sender) Received: from [64.233.182.184] (HELO nf-out-0910.google.com) (64.233.182.184) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 17 Nov 2006 08:42:46 -0800 Received: by nf-out-0910.google.com with SMTP id x4so1554979nfb for ; Fri, 17 Nov 2006 08:42:25 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=YnLdHErKcDIJsOlI+/5wH5rb5HR+Xn3qqUgX3xfEcU5TRKoZaIUfEQXhz03+cwCD11wdZKglp9xP8JJWfp8lRC6mhXbT9naGJiTt8YJG+0Zq29C8yvilLU+PixOpd3rmBRwzQUo7hSnY6aggk/K+GA2jNpMW10qAX2Sgf/g9oBM= Received: by 10.82.120.15 with SMTP id s15mr252383buc.1163781744392; Fri, 17 Nov 2006 08:42:24 -0800 (PST) Received: by 10.82.126.10 with HTTP; Fri, 17 Nov 2006 08:42:24 -0800 (PST) Message-ID: Date: Fri, 17 Nov 2006 17:42:24 +0100 From: "Milan Trajkovic" To: users@jackrabbit.apache.org Subject: Re: About the parameter config of Mysql autoReconnect In-Reply-To: <510143ac0611170553u22fe1d57hf6a739bf88db41bf@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <6b52103f0611161755j2281840bhbfbbe95b5158049f@mail.gmail.com> <6b52103f0611161804p27ee830eq9459423115c1947d@mail.gmail.com> <5f211bd50611170125o1dc93061u254bc7f0e7a61622@mail.gmail.com> <6b52103f0611170411g7752f21ex34f7e1119a2decf8@mail.gmail.com> <5f211bd50611170528o6518b005o982c1dffdd67a943@mail.gmail.com> <510143ac0611170553u22fe1d57hf6a739bf88db41bf@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org I had the same problem. I have created TimerTask that add and remove node to workspace (along with session.save() - so it is actually persisted in Database). It is fired once an hour, and keeps connection open. 2006/11/17, Jukka Zitting : > Hi, > > On 11/17/06, Thomas Mueller wrote: > > Why does the connection to the database breaks by the way? > > I think there's a default 8 hour timeout in MySQL. One way to prevent > that could be to include a background thread in a custom > MySQLPersistenceManager that pings the database every now and then to > keep the connection alive. > > BR, > > Jukka Zitting >