commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dirk Verbeeck <dirk.verbe...@pandora.be>
Subject Re: DBCP oracle connections less than minActive ?
Date Thu, 04 Dec 2003 22:33:19 GMT
Oracle can indeed service multiple clients using one server process.
In the latest version you can also configure that multiple Connections 
are using the same network socket to connect to the database.
But this is all transparant to the user.
On the client you will still have a normal "Connection" object and you 
will see for each "Connection" an oracle session in v$session.

-- Dirk

John Zoetebier wrote:

> Maybe the reason for different number of connections shown by Oracle and 
> DBCP is that Oracle has its own connection pool ?
> For example Oracle may decide to return a connection to the pool after a 
> query is finished even of the connection is not closed by the client.
> The reason may be that not all clients properly close a connection.
> By pooling connections on the server + timeout mechanism Oracle can save 
> resources.
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message