okay, i just found this on tomee examples page, http://tomee.apache.org/examples-trunk/dynamic-datasource-routing/README.html
On Sun, Nov 3, 2013 at 5:46 AM, Howard W. Smith, Jr. <smithh032...@gmail.com > wrote: > I believe that is exactly what I want. I wish I knew about that earlier, > so I could have tried that earlier, and my preference is to do /use the > tomee easy way, always, and as much as possible. Thanks Romain. I like the > dynamic datasources too. Is there a test case (on trunk) available for both > the fail over and dynamic datasources, separately, so I can evaluate both? > Please reply with URL of those test cases, if available. Thanks. > > If I may ask, was this added to tomee after seeing tomee users mentioning > or interested in something like this. Definitely a great idea and feature > to add to the great tomee. :-) > On Nov 3, 2013 3:15 AM, "Romain Manni-Bucau" <rmannibu...@gmail.com> > wrote: > >> No idea why you have a NPE but do you know >> >> http://rmannibucau.wordpress.com/2013/04/26/tomeeopenejb-and-failover-of-datasources/ >> ? >> Isnt it what you desire more or less? >> Le 3 nov. 2013 05:11, "Howard W. Smith, Jr." <smithh032...@gmail.com> a >> écrit : >> >> > trying to get it done via tomee.xml, ha-jdbc-cluster.xml, and java >> option >> > -Dha-jdbc... seems to help, but i definitely need help...i been >> reporting >> > my progress with this on ha-jdbc forum[1]... i hope to get some help >> with >> > this, soon. >> > >> > [1] >> https://sourceforge.net/p/ha-jdbc/discussion/383396/thread/5f4dc302/ >> > >> > >> > >> > On Sat, Nov 2, 2013 at 3:44 PM, Howard W. Smith, Jr. < >> > smithh032...@gmail.com >> > > wrote: >> > >> > > okay, I'm seeing what you said (not get jta as easily, when using >> > > context.xml). thanks. >> > > >> > > >> > > On Sat, Nov 2, 2013 at 3:39 PM, Romain Manni-Bucau < >> > rmannibu...@gmail.com>wrote: >> > > >> > >> If you use context.xml youll not get as easily jta. >> > >> >> > >> You can set Resource attribute class-name to the impl class and >> setXxx >> > >> using xxx as property attribute (factory for instance) >> > >> Le 2 nov. 2013 18:10, "Howard W. Smith, Jr." <smithh032...@gmail.com> >> a >> > >> écrit : >> > >> >> > >> > Per [Avoid properties conflict when configuring TomEE >> DataSource][1], >> > I >> > >> > added ignoreDefaultValues=true to <Resource> in tomee.xml, >> > >> > >> > >> > <Resource id="jdbc/mcmsJta" type="javax.sql.DataSource"> >> > >> > JdbcDriver net.sf.hajdbc.sql.DataSource >> > >> > IgnoreDefaultValues true >> > >> > JtaManaged true >> > >> > jmxEnabled true >> > >> > LogSql false >> > >> > </Resource> >> > >> > >> > >> > and the result are the [exceptions in the log file][2]. >> > >> > >> > >> > the exceptions seem to prove that I need to add the following to >> > >> <Resource >> > >> > .../> >> > >> > >> > >> > cluster="..." >> > >> > factory="..." >> > >> > >> > >> > can you please advise how I can add these two parameters to >> <Resource >> > >> .../> >> > >> > in tomee.xml, or should I revert to META-INF/context.xml? >> > >> > >> > >> > >> > >> > [1]: >> > >> > >> > >> > >> > >> >> > >> http://rmannibucau.wordpress.com/2012/11/08/avoid-properties-conflict-when-configuring-tomee-datasource/ >> > >> > [2]: https://gist.github.com/smithh032772/7279765#file-log3-txt >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > On Sat, Nov 2, 2013 at 11:09 AM, Romain Manni-Bucau >> > >> > <rmannibu...@gmail.com>wrote: >> > >> > >> > >> > > Why workaround? That how it works >> > >> > >> > >> >> > > >> > > >> > >> >