Db connections pool in JAMES

[Samuel Sadek <sa...@hotmail.com>]

I have discovered an undocumented feature within JAMES 2.02a using a db 
repository as opposed to a file system version. There is a <max> tag which 
JAMES users can make use of to avoid the annoying situations where JAMES has 
run out of db connections from pool. The default setting is only 2 which is 
obviously not fit for live production purposes. I have used this tag to 
include a maximum limit of 10 connections and have come to the conclusion 
that I have not seen this error which is great news. I think communicating 
this feature to users and possibly making suggestions as to the limit of db 
connections in the pool is in order and would definitely help people! I have 
posted an example of this setting:

In the case for oracle backed-up db repository,

<data-source name="maildb"
class="org.apache.james.util.mordred.JdbcDataSource">
            <driver>oracle.jdbc.driver.OracleDriver</driver>
            
<dburl>jdbc:oracle:thin:@orange.secemail.dnsalias.com:1521:mail01</dburl>
            <user>anyuser</user>
            <password>anypassword</password>
	    <max>10</max>
</data-source>

The above <max> tag sets a db connection pool of 10. This is configurable by 
the client.

Sam.


_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: Db connections pool in JAMES

[Serge Knystautas <se...@lokitech.com>]

Thanks Sam, I'll put it as a commented out setting in the default config.xml
file so it's a bit more apparent. :)

Serge Knystautas
Loki Technologies - Unstoppable Websites
http://www.lokitech.com/
----- Original Message -----
From: "Samuel Sadek" <sa...@hotmail.com>
To: <ja...@jakarta.apache.org>
Cc: <ja...@jakarta.apache.org>
Sent: Thursday, March 07, 2002 2:44 PM
Subject: Db connections pool in JAMES


> I have discovered an undocumented feature within JAMES 2.02a using a db
> repository as opposed to a file system version. There is a <max> tag which
> JAMES users can make use of to avoid the annoying situations where JAMES
has
> run out of db connections from pool. The default setting is only 2 which
is
> obviously not fit for live production purposes. I have used this tag to
> include a maximum limit of 10 connections and have come to the conclusion
> that I have not seen this error which is great news. I think communicating
> this feature to users and possibly making suggestions as to the limit of
db
> connections in the pool is in order and would definitely help people! I
have
> posted an example of this setting:
>
> In the case for oracle backed-up db repository,
>
> <data-source name="maildb"
> class="org.apache.james.util.mordred.JdbcDataSource">
>             <driver>oracle.jdbc.driver.OracleDriver</driver>
>
> <dburl>jdbc:oracle:thin:@orange.secemail.dnsalias.com:1521:mail01</dburl>
>             <user>anyuser</user>
>             <password>anypassword</password>
>     <max>10</max>
> </data-source>
>
> The above <max> tag sets a db connection pool of 10. This is configurable
by
> the client.
>
> Sam.


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>