Re: Connection Pool to Oracle

From: Marin Dimitrov <marin_at_sirma.bg>
Date: Fri, 26 Jan 2001 15:05:36 +0200
Message-Id: <10753.127572@fatcity.com>

• Original Message ----- From: Javi Tabemoor <jtabemoor_at_yahoo.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, January 26, 2001 05:55 Subject: Connection Pool to Oracle

> We have a data access framework that allows a client
> to create its database connection pool to Oracle with
> JDBC.
>
> Session timeouts defeat the goal of the connection
> pool. How does one keep the connections alive and
> connected to Oracle for say the whole day without
> enumerating through each element and issuing an Oracle
> call?
>

AFAIK WebLogic's JDBC pool does exactly that - probe the connection with a dummy SELECT statement at a specified interval.

When creating a connection pool u could specify "refreshTestMinutes" and "testTable" against which a SELECT count(*) from "testTable" will be executed

hth,

    Marin

---

"When someone is seeking, it happens quite easily that he only sees the thing that he is seeking; that he is unable to find anything, unable to absorb anything, because he is only thinking of the thing he is seeking, because he is obsessed with his goal. Seeking means: to have a goal; but finding means: to be free, to be receptive, to have no goal. ..."

                                Herman Hesse, "Siddhartha"

Received on Fri Jan 26 2001 - 07:05:36 CST