activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Strachan" <james.strac...@gmail.com>
Subject Re: Oracle Persistant Journal
Date Mon, 04 Sep 2006 06:46:53 GMT
On 8/31/06, grudi <grudi@gmx.net> wrote:
>
> We also are running the journal on Oracle

FWIW the journal is used for short term persistence and is a text
file, its not a database.


> 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?

AFAIK this is resolved in 4.0.1. You can use a DataSource to limit the
number of JDBC connections

-- 

James
-------
http://radio.weblogs.com/0112098/

Mime
View raw message