Mailing-List: contact user-help@commons.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Commons Users List" <user@commons.apache.org>
Received-SPF: pass (athena.apache.org: domain of craig.spry@gmail.com
 designates 209.85.142.188 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=Mnm/cUZio8uSMtiDwGpYHzaN6l+Yc3E/ZJeiO6zTboUEL+Qh+i7oHOSyYW2/PPCXgt8AoMNK7hM8551xxuHDBbKN560tFoGGNb1wPGlg6w6ZcWIskLvhokUecFnxKVQUC3LXlf3gxSg/VFQIsD4FjTDbgHQ6g7uEqvKcEvTOMDg=
Message-ID: <f7e4c1930805220531x42689a2dye35cbb019f9c7e92@mail.gmail.com>
Date: Thu, 22 May 2008 22:31:26 +1000
From: "Craig Spry" <craig.spry@gmail.com>
To: "Commons Users List" <user@commons.apache.org>
Subject: Re: recreation of connections in the dbcp
In-Reply-To: <483561D8.1020906@yale.edu>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_3274_31858124.1211459486449"
References: <1841a3c10805220143w659fcd7dgc20223593babdbac@mail.gmail.com>
	 <f2e8eedf0805220342t5504f669u37f121712e783b71@mail.gmail.com>
	 <483561D8.1020906@yale.edu>

------=_Part_3274_31858124.1211459486449
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

For Postgres I use:
select now()

On Thu, May 22, 2008 at 10:06 PM, Mark Shifman <mark.shifman@yale.edu>
wrote:

> for Oracle use
>
> validationQuery="SELECT 1 from dual"
>
> James Carman wrote:
> > I'd use a validation query.  I believe that will solve your problem.
> > That way, the pool implementation can check to see that the connection
> > is "valid" before handing it off to you.  For HSQLDB, I use:
> >
> > select 1 from INFORMATION_SCHEMA.SYSTEM_USERS
> >
> > You can come up with something similar for other database products.
> > Hope that helps!
> >
> > On Thu, May 22, 2008 at 4:43 AM,  <sed.nivo@gmail.com> wrote:
> >> Hello,
> >>
> >> I use database connection pool BasicDataSource for manegment of DB
> >> connections. When DB Server is restarted all connections are loosed.
> >> How can I handle this situation? Should I create new BasicDataSource
> >> or invoke some method.
> >>
> >> Thank you.
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
> >> For additional commands, e-mail: user-help@commons.apache.org
> >>
> >>
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
> > For additional commands, e-mail: user-help@commons.apache.org
> >
>
>
> --
>  Mark Shifman MD. Ph.D.
>  Yale Center for Medical Informatics
>  Phone (203)737-5219
>  mark.shifman@yale.edu
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
> For additional commands, e-mail: user-help@commons.apache.org
>
>

------=_Part_3274_31858124.1211459486449--