You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@activemq.apache.org by James Strachan <ja...@gmail.com> on 2006/09/04 08:46:53 UTC

Re: Oracle Persistant Journal

On 8/31/06, grudi <gr...@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/