Re: ActiveMQ multiple JDBC data sources in same configuration

2021-06-01 Thread Vince Cox
JB, I am investigating this as well. Have you made any other discoveries? Thank you. I appreciate your time. Vince On 5/25/21, 4:08 PM, "Jean-Baptiste Onofre" wrote: Hmm, Which ActiveMQ version ? It might inherit the main ds from the persistence adapter. I will check tomorrow

Re: ActiveMQ multiple JDBC data sources in same configuration

2021-05-25 Thread Vince Cox
They are using version 5.14.5 Get Outlook for iOS<https://aka.ms/o0ukef> From: Jean-Baptiste Onofre Sent: Tuesday, May 25, 2021 4:07:23 PM To: users@activemq.apache.org Subject: Re: ActiveMQ multiple JDBC data sources in same configuration Hmm, Which Ac

Re: ActiveMQ multiple JDBC data sources in same configuration

2021-05-25 Thread Jean-Baptiste Onofre
Hmm, Which ActiveMQ version ? It might inherit the main ds from the persistence adapter. I will check tomorrow my time. Regards JB > Le 25 mai 2021 à 18:03, Vince Cox a écrit : > > JB, > > My customer has gone this route and ActiveMQ started, however only the first > data source listed (ds

Re: ActiveMQ multiple JDBC data sources in same configuration

2021-05-25 Thread Matt Pavlovich
___ > From: Matt Pavlovich > Sent: Monday, May 24, 2021 9:20:41 PM > To: users@activemq.apache.org > Subject: Re: ActiveMQ multiple JDBC data sources in same configuration > > Hey Vince, > > Most likely DB tuning and/or connection lifecycle coordination b/w the >

Re: ActiveMQ multiple JDBC data sources in same configuration

2021-05-24 Thread Vince Cox
Thank you JB, I will definitely take a look at that. Vince Get Outlook for iOS<https://aka.ms/o0ukef> From: Jean-Baptiste Onofre Sent: Tuesday, May 25, 2021 12:12:51 AM To: users@activemq.apache.org Subject: Re: ActiveMQ multiple JDBC data sources i

Re: ActiveMQ multiple JDBC data sources in same configuration

2021-05-24 Thread Jean-Baptiste Onofre
Hi Vince, It’s possible to have different datasource: one for the main message store, one for the lease locker. As JDBC leaser locker extends persistent adapter, you can pass a datasource. Something like this should work: You can take a look on http://blog

Re: ActiveMQ multiple JDBC data sources in same configuration

2021-05-24 Thread Vince Cox
kef> From: Matt Pavlovich Sent: Monday, May 24, 2021 9:20:41 PM To: users@activemq.apache.org Subject: Re: ActiveMQ multiple JDBC data sources in same configuration Hey Vince, Most likely DB tuning and/or connection lifecycle coordination b/w the connection factory u

Re: ActiveMQ multiple JDBC data sources in same configuration

2021-05-24 Thread Matt Pavlovich
To: users@activemq.apache.org > Subject: Re: ActiveMQ multiple JDBC data sources in same configuration > > Hello Vince- > > Are you able to detail out the use case and rationale for separating the data > store from the locker? On the surface that sounds like creating an extr

Re: ActiveMQ multiple JDBC data sources in same configuration

2021-05-24 Thread Vince Cox
pair fails over. Vince Get Outlook for iOS<https://aka.ms/o0ukef> From: Matt Pavlovich Sent: Monday, May 24, 2021 7:43:54 PM To: users@activemq.apache.org Subject: Re: ActiveMQ multiple JDBC data sources in same configuration Hello Vince- Are you able to

Re: ActiveMQ multiple JDBC data sources in same configuration

2021-05-24 Thread Matt Pavlovich
Hello Vince- Are you able to detail out the use case and rationale for separating the data store from the locker? On the surface that sounds like creating an extra runtime coupling with a distributed system— generally that approach creates more aggregate downtime. Thanks, Matt Pavlovich > On