James and Oracle database backend

[Adrien Flammarion <ad...@autonomy.com>]

Hello experts,

I have setup my james server to use an Oracle database as the 
inbox/spool/user repository.
I can see in my Oracle logs that James is openning a new connection with 
the DB roughly 22 000 times a day.

Is this expected behaviour? I would have expected James to use a pool 
and not open new connection for every dialogue it has with the DB.

I would appreciate any input.
Thanks.
-- 

_Adrien Flammarion_
Technical Consultant
Autonomy Systems Limited
+44 (0) 777 622 8065
adrienf@autonomy.com <ma...@autonomy.com>


The information contained in this message is for the intended addressee 
only and may contain confidential and/or privileged  information.  If 
you are not the intended addressee, please delete this message and 
notify the sender, and do not copy or distribute this message or 
disclose its contents to anyone.  Any views or opinions expressed in 
this message are those of the author and do not necessarily represent 
those of Autonomy Systems Limited or of any of its associated 
companies.  No reliance may be placed on this message without written 
confirmation from an authorised representative of the company.  Autonomy 
Systems Limited, Registered Office:  Cambridge Business Park, Cowley 
Road, Cambridge CB4 0WZ, Registered Number 03063054.



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

Re: James and Oracle database backend

[Norman <no...@apache.org>]

Am 12.08.2010 11:53, schrieb Adrien Flammarion:
> Hello experts,
>
> I have setup my james server to use an Oracle database as the 
> inbox/spool/user repository.
> I can see in my Oracle logs that James is openning a new connection 
> with the DB roughly 22 000 times a day.
>
> Is this expected behaviour? I would have expected James to use a pool 
> and not open new connection for every dialogue it has with the DB.
>
> I would appreciate any input.
> Thanks.

Hi,

what version of James you are using ? I guess its 2.3.x. By default it 
use a connection pool of 20 connections there. You can find howto tune 
this here:

http://james.apache.org/server/2.3.2/apidocs/org/apache/james/util/dbcp/JdbcDataSource.html


Hope it helps,
Norman


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