Mailing-List: contact activemq-users-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: activemq-users@geronimo.apache.org
Received-SPF: pass (asf.osuosl.org: domain of lists@nabble.com designates
 72.21.53.35 as permitted sender)
Message-ID: <6079430.post@talk.nabble.com>
Date: Thu, 31 Aug 2006 06:31:48 -0700 (PDT)
From: grudi <grudi@gmx.net>
To: activemq-users@geronimo.apache.org
Subject: Re: Oracle Persistant Journal
In-Reply-To: <ec6e67fd0608210835u6dd0e01fxeddd06194a554147@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
References: <5908849.post@talk.nabble.com>
 <ec6e67fd0608210822r264f1590h2c18645032893e0d@mail.gmail.com>
 <5909049.post@talk.nabble.com>
 <ec6e67fd0608210835u6dd0e01fxeddd06194a554147@mail.gmail.com>


We also are running the journal on Oracle and the number of Oracle processes
(which translates into connections) getting created is very high (up to
1000, our limit). We use AMQ 3.2. We discoverd, that the processes were
created when subscribing to a Topic out of a GUI Application. Each instance
of the  Application subscribes to approx 20 Topics. When you are closing one
instance of the GUI Application, the Oracle processes (connections) are not
getting released. Is each subscription to one Topic creating one Oracle
connection? How can this be avoided and are the connections getting released
automatically when unsubsricbing to a Topic?


James.Strachan wrote:
> 
> On 8/21/06, osian <osian@osian.me.uk> wrote:
>>
>> Is the JDBC pool something that is set on the BasicDataSource?
> 
> Yes
> 
> http://jakarta.apache.org/commons/dbcp/apidocs/org/apache/commons/dbcp/BasicDataSource.html#setMaxActive(int)
> 
> 
>> Also, I'm unsure about what you mean by the nr or connections required
>> depends on the nr of connections I have.
> 
> The number of JDBC connections required when not using the journal is
> dependent on the number of connections to the broker - unless you cap
> the limit on the number of JDBC connections used which effectively
> causes contention in the broker waiting for available JDBC
> connections. i.e. it reduces the concurrency of the broker and its
> throughput.
> 
> If you use the high performance journal then you'll use less JDBC
> connections, since JDBC is mostly only used by a background checkpoint
> thread.
> 
> -- 
> 
> James
> -------
> http://radio.weblogs.com/0112098/
> 
> 

-- 
View this message in context: http://www.nabble.com/Oracle-Persistant-Journal-tf2140863.html#a6079430
Sent from the ActiveMQ - User forum at Nabble.com.