Network broker - huge connection consumption

[Olivier OTTAVI <ol...@gmail.com>]

Hi there,  I have a question concerning the best practice in the setup of a
broker network with Oracle and ActiveMQ.

I am actually facing a case where during consumption of messages, the number
of connection open by the brokers to the database, is huge, and eventually
will block the listener from accepting more session. It seems to me that
this is part of the synchronisation process of the  different nodes in the
broker network.

The configuration is the following :

* The two brokers use persistance based on journaledJDBC with each connected
to a separate datasource on the same database, with a different schema.

* broker1 has a transport connector openwire open on port 61616, and a
networkConnectors of  type static://(tcp://localhost:62626) failover=true
* broker2 has a transport connector openwire open on port 62626, and a
networkConnectors of  type static://(tcp://localhost:61616) failover=true

The datasources are using BasicDataSource from the DBCP api, with
Oracledriver, poolPreparedStatements=true, and I added the parameter
maxActive=2, which anyway does not seem to modify the number of opening
connexion.

I am using ActiveMQ v4.1.1 - it seems that this version is quite slow and
not so stable during the failover process. Any information regarding this
configuration will be greatly appreciated.

Thanks in advance,

Olivier