no connections available - does james really need more than 500?

["Labib Iskander, Marcus" <ml...@cm4all.com>]

Hi,
after raising the max number of connections to 500 I am wondering how high
it should be.
I have got 13 ToRepository Mailets and 2 RemoteDelivery Mailets configured
connecting to a db.
but after upgrading to james 2.1.2 from 2.0a3. It doesn't start properly
anymore.
could it be connected to that I configured 2 smtpserver blocks?
How high should the max number really be for this configuration?

java.sql.SQLException: Giving up... no connections available.
        at
org.apache.james.util.mordred.JdbcDataSource.getConnection(JdbcDataSource.ja
va:208)
        at
org.apache.james.mailrepository.JDBCMailRepository.initialize(JDBCMailReposi
tory.java:307)
        at
org.apache.james.core.AvalonMailStore.select(AvalonMailStore.java:292)
        at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at
org.apache.avalon.phoenix.components.application.BlockInvocationHandler.invo
ke(BlockInvocationHandler.java:92)
        at $Proxy3.select(Unknown Source)
        at
org.apache.james.transport.mailets.ToRepository.init(ToRepository.java:65)
	...

Cheers,
  Marcus

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

RE: no connections available - does james really need more than 500?

["Noel J. Bergman" <no...@devtech.com>]

> after raising the max number of connections to 500 I am wondering how high
> it should be.

> java.sql.SQLException: Giving up... no connections available.

You do realize that this refers to DATABASE connections, and ONLY DATABASE
connections?  It has nothing to do with the connection manager.  I doubt
that your database server is even configured to permit 500 connections.

This error is generally indicative of other problems, such as a bad
password, incorrect URL, or restarting the database server without
restarting James.

Which database are you using?

	--- Noel


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