Re: Using TomEE/OpenEJB and failover of datasources

2013-11-04 Thread Romain Manni-Bucau
this doesn't replicate by default bu tif your databases are replicated it would work Romain Manni-Bucau Twitter: @rmannibucau Blog: http://rmannibucau.wordpress.com/ LinkedIn: http://fr.linkedin.com/in/rmannibucau Github: https://github.com/rmannibucau 2013/11/4 Howard W. Smith, Jr.

Re: Using TomEE/OpenEJB and failover of datasources

2013-11-04 Thread Howard W. Smith, Jr.
hmmm okay. can/should tomee/openejb 'dynamic datasources' be used to replicate data across all databases via some custom JPA persist method that I would code in routed datasource? i'm asking this question after yesterday's review of the (tomee and openejb) dynamic datasources documentation and

Re: Using TomEE/OpenEJB and failover of datasources

2013-11-04 Thread Romain Manni-Bucau
can - yes (just return a datasource proxy which does the same on all datasources for each invocation) should - no (databases have hard times implementing it so just use it, it will be better regarding all aspects - excepted $$ maybe) Romain Manni-Bucau Twitter: @rmannibucau Blog:

Using TomEE/OpenEJB and failover of datasources

2013-11-03 Thread Howard W. Smith, Jr.
First of all, thanks Romain for recommending the following, and for that I will gladly start a new thread. :) TomEE/OpenEJB and failover of datasources[1] which references [OpenEJB] Dynamic Datasource[2] but I found the following TomEE example: [TomEE] Dynamic Datasource Routing[3] So,

Re: Using TomEE/OpenEJB and failover of datasources

2013-11-03 Thread Romain Manni-Bucau
Hi Failover is native but to customiee the algo you can code anything you want Tomee.xml is openejb.xml Service-jar.xml is today useless (see my post) Le 3 nov. 2013 14:55, Howard W. Smith, Jr. smithh032...@gmail.com a écrit : First of all, thanks Romain for recommending the following, and

Re: Using TomEE/OpenEJB and failover of datasources

2013-11-03 Thread Howard W. Smith, Jr.
So, the following replaces service-jar.xml (as per your post)? Resource id=jdbc/ds type=DataSource provider=RoutedDataSource router = failover-router /Resource and if I wanted to use the 'strategy' parameter, I would add to Resource as demonstrated below? Resource id=jdbc/ds type=DataSource

Re: Using TomEE/OpenEJB and failover of datasources

2013-11-03 Thread Howard W. Smith, Jr.
okay, i set it up as your post demonstrated, I tested already, and I see no issues. it's time to test this in production. :) thanks romain! like i said in the other thread, I wish I knew about this earlier. On Sun, Nov 3, 2013 at 9:16 AM, Howard W. Smith, Jr. smithh032...@gmail.com wrote:

Re: Using TomEE/OpenEJB and failover of datasources

2013-11-03 Thread Jean-Louis MONTEIRO
just as next time. If not already there, no issue to add a feature or to propose it by yourself ;-) New committers always welcome. 2013/11/3 Howard W. Smith, Jr. smithh032...@gmail.com okay, i set it up as your post demonstrated, I tested already, and I see no issues. it's time to test this

Re: Using TomEE/OpenEJB and failover of datasources

2013-11-03 Thread Howard W. Smith, Jr.
thanks Jean-Louis... i'm still learning via tomee (committers). :) On Sun, Nov 3, 2013 at 10:00 AM, Jean-Louis MONTEIRO jeano...@gmail.comwrote: just as next time. If not already there, no issue to add a feature or to propose it by yourself ;-) New committers always welcome. 2013/11/3

Re: Using TomEE/OpenEJB and failover of datasources

2013-11-03 Thread Jean-Louis MONTEIRO
That's great but I'm pretty sure, you know much more than a lot of people. 2013/11/3 Howard W. Smith, Jr. smithh032...@gmail.com thanks Jean-Louis... i'm still learning via tomee (committers). :) On Sun, Nov 3, 2013 at 10:00 AM, Jean-Louis MONTEIRO jeano...@gmail.com wrote: just as next

Re: Using TomEE/OpenEJB and failover of datasources

2013-11-03 Thread Howard W. Smith, Jr.
thanks Jean-Louis... it remains to be seen. :) On Sun, Nov 3, 2013 at 10:14 AM, Jean-Louis MONTEIRO jeano...@gmail.comwrote: That's great but I'm pretty sure, you know much more than a lot of people. 2013/11/3 Howard W. Smith, Jr. smithh032...@gmail.com thanks Jean-Louis... i'm still

Re: Using TomEE/OpenEJB and failover of datasources

2013-11-03 Thread Howard W. Smith, Jr.
FYI, I just stopped my local tomee, and recognized that my @Application @PreDestroy has my code that stops Apache Derby prior to main and fallback datasources are closed. is this okay? Nov 03, 2013 10:12:48 AM org.apache.catalina.core.StandardServer await INFO: A valid shutdown command was

Re: Using TomEE/OpenEJB and failover of datasources

2013-11-03 Thread Howard W. Smith, Jr.
i guess my question really is... since I stop derby before main fallback datasources are closed, is it likely that this might interrupt data integrity? is it possible that I will lose data since my app stops derby prior to tomee/openejb failover stops datasources...at tomee shutdown/stop? On

Re: Using TomEE/OpenEJB and failover of datasources

2013-11-03 Thread Romain Manni-Bucau
lookhttp://svn.apache.org/repos/asf/tomee/tomee/trunk/container/openejb-core/src/main/java/org/apache/openejb/resource/jdbc/router/FailOverRouter.java last method it can still be enhanced a lot Romain Manni-Bucau Twitter: @rmannibucau Blog: http://rmannibucau.wordpress.com/ LinkedIn:

Re: Using TomEE/OpenEJB and failover of datasources

2013-11-03 Thread Howard W. Smith, Jr.
Interesting. thanks Jean-Louis. Let me share some things. When I saw Romain's response on the other thread that informed me about tomee/openejb failover via dynamic datasource(s), I saw his post/blog mention load-balancing, and that is what attracted me the most to this feature. So, after I

Re: Using TomEE/OpenEJB and failover of datasources

2013-11-03 Thread Howard W. Smith, Jr.
interesting. I can definitely use this as a reference if (ever) necessary, thanks. which brings me to my next question, // // take care next strategies can break multiple calls on the facade // it is only intended to be used for connection selection // I

Re: Using TomEE/OpenEJB and failover of datasources

2013-11-03 Thread Romain Manni-Bucau
Failover is a facase over normal resources. Only these resource can/should be pooled Le 3 nov. 2013 21:51, Howard W. Smith, Jr. smithh032...@gmail.com a écrit : interesting. I can definitely use this as a reference if (ever) necessary, thanks. which brings me to my next question, //

Re: Using TomEE/OpenEJB and failover of datasources

2013-11-03 Thread Howard W. Smith, Jr.
okay, good. that shows that I understood your blog/post, correctly, and add this to my app, accordingly. thanks! On Sun, Nov 3, 2013 at 4:20 PM, Romain Manni-Bucau rmannibu...@gmail.comwrote: Failover is a facase over normal resources. Only these resource can/should be pooled Le 3 nov. 2013