On 8/31/06, grudi <[EMAIL PROTECTED]> 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/
