Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PUZZLE: A call that succeeds N times then fails for any single connection
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