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 > > >> > > > >> > > > > > > > > >