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: > 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" provider="RoutedDataSource"> > router = failover-router > strategy = random > </Resource> > > > > > On Sun, Nov 3, 2013 at 8:58 AM, Romain Manni-Bucau > <rmannibu...@gmail.com>wrote: > >> 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 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, before I begin, my questions are as follows: >> > >> > 1. I recognized that failover[1] says that the idea is to 'reuse' >> dynamic >> > datasource. Does this mean that we should code openejb[2] or tomee[3] >> > dynamic datasource, first, and then reference accordingly via >> failover[1]? >> > >> > 2. or failover[1] requires no coding on our part? only developer needs >> to >> > setup the failover 'config'? >> > >> > 3. also, tomee[3] dynamic datasource routing recommends openejb.xml >> > (instead of tomee.xml). can openejb.xml cofiguration be placed in >> > tomee.xml, too, or not? >> > >> > 4. okay, never mind, I was abouto ask for some clarification about >> > META-INF/org.router/service-jar.xml, but I 'found' service-jar.xml on >> > trunk[4]. :) >> > >> > >> > >> > [1] >> > >> > >> http://rmannibucau.wordpress.com/2013/04/26/tomeeopenejb-and-failover-of-datasources/ >> > >> > [2] http://tomee.apache.org/dynamic-datasource.html >> > >> > [3] >> > >> > >> http://tomee.apache.org/examples-trunk/dynamic-datasource-routing/README.html >> > >> > [4] >> > >> > >> http://svn.apache.org/repos/asf/tomee/tomee/trunk/examples/dynamic-datasource-routing/src/main/resources/META-INF/org.router/service-jar.xml >> > >> > >