Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PUZZLE: A call that succeeds N times then fails for any single connection

Re: PUZZLE: A call that succeeds N times then fails for any single connection

From: <joeNOSPAM_at_BEA.com>
Date: 27 Apr 2007 08:37:49 -0700
Message-ID: <1177688269.686072.15680@t38g2000prd.googlegroups.com>


On Apr 26, 8:30 pm, Galen Boyer <galen_bo..._at_yahoo.com> wrote:
> On 26 Apr 2007, joe.weinst..._at_gmail.com wrote:
>
> > Hi all. I want some parameter-less SQL or procedure that will run
> > uneventfully N times for any given DBMS connection, but will then
> > *fail* such that the caller gets some ORA-XXXXXX error. I would
> > like this as light-weight and quick as possible.
>
> Is this procedure called by java and therefore java has been forced to
> deal with an exception, or are you trying to mimic a connection in the
> connection pool all of the sudden croaking?
>
> --
> Galen Boyer

Hi. I want a pool to execute this procedure as part of it's "is this connection still good"
test, to enforce that the connection test fail because of receiving a DBMS-based
exception after N such tests. Received on Fri Apr 27 2007 - 10:37:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US