Does AMQ reconnects to the Backend Relational Database after temp Database outage

["Dhawan, Vikram (LNG-DAY)" <vi...@lexisnexis.com>]

Hi,

 

I am trying to configure AMQ 4.1.0 with a MySql database as backend, I
want to make sure if there is temporary outage of MySql database, AMQ
will not die and will try to reconnect on some regular time interval. In
my testing it does not appear that way. I am using standard
configuration comes with AMQ download. 

 

Do I have to change something in my data source settings in activemq.xml
to tell it to try to reconnect? 

 

Thanks!

 

Vik

 

Re: Does AMQ reconnects to the Backend Relational Database after temp Database outage

[James Strachan <ja...@gmail.com>]

On 4/4/07, Dhawan, Vikram (LNG-DAY) <vi...@lexisnexis.com> wrote:
> Hi,
>
>
>
> I am trying to configure AMQ 4.1.0 with a MySql database as backend, I
> want to make sure if there is temporary outage of MySql database, AMQ
> will not die and will try to reconnect on some regular time interval. In
> my testing it does not appear that way. I am using standard
> configuration comes with AMQ download.

JDBC reconnection is the responsibility of the DataSource; use a
DataSource which does connection testing & reconnection. e.g. try c3po
or commons-dbcp.

-- 

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