Re: HA-JDBC via tomee.xml Resource factory/cluster properties ignored

2013-11-05 Thread Howard W. Smith, Jr.
Well, they have their own implementation of Romain there though. His name is Paul. Lol On Nov 5, 2013 12:55 AM, Jean-Louis MONTEIRO jeano...@gmail.com wrote: Lol Romain isn't a committee on HA Jdbc. Le 5 nov. 2013 06:08, Howard W. Smith, Jr. smithh032...@gmail.com a écrit : FYI/followup,

Re: HA-JDBC via tomee.xml Resource factory/cluster properties ignored

2013-11-04 Thread Howard W. Smith, Jr.
FYI/followup, On Sat, Nov 2, 2013 at 9:49 AM, Howard W. Smith, Jr. smithh032...@gmail.com wrote: I'm trying to use HA-JDBC[1] with TomEE to have a cluster of at least 2 databases. I had to do the following to ensure tomee would create the ha-jdbc resource: 1. add the following java option

Re: HA-JDBC via tomee.xml Resource factory/cluster properties ignored

2013-11-04 Thread Jean-Louis MONTEIRO
Lol Romain isn't a committee on HA Jdbc. Le 5 nov. 2013 06:08, Howard W. Smith, Jr. smithh032...@gmail.com a écrit : FYI/followup, On Sat, Nov 2, 2013 at 9:49 AM, Howard W. Smith, Jr. smithh032...@gmail.com wrote: I'm trying to use HA-JDBC[1] with TomEE to have a cluster of at least 2

Re: HA-JDBC via tomee.xml Resource factory/cluster properties ignored

2013-11-03 Thread Romain Manni-Bucau
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,

Re: HA-JDBC via tomee.xml Resource factory/cluster properties ignored

2013-11-03 Thread Howard W. Smith, Jr.
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

Re: HA-JDBC via tomee.xml Resource factory/cluster properties ignored

2013-11-03 Thread Howard W. Smith, Jr.
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

HA-JDBC via tomee.xml Resource factory/cluster properties ignored

2013-11-02 Thread Howard W. Smith, Jr.
I'm trying to use HA-JDBC[1] with TomEE to have a cluster of at least 2 databases. As per documentation and forum discussion, I have the following: --- tomee.xml --- Resource id=jdbc/mcmsJta type=javax.sql.DataSource factory=net.sf.hajdbc.sql.DataSourceFactory cluster=cluster UserName

Re: HA-JDBC via tomee.xml Resource factory/cluster properties ignored

2013-11-02 Thread Howard W. Smith, Jr.
The following is the workaround: Resource id=jdbc/mcmsJta type=javax.sql.DataSource JdbcDriver net.sf.hajdbc.sql.DataSource UserName Password JtaManaged true jmxEnabled true LogSql false /Resource and had to rename filename from ha-jdbc-cluster.xml to ha-jdbc-null.xml.

Re: HA-JDBC via tomee.xml Resource factory/cluster properties ignored

2013-11-02 Thread Romain Manni-Bucau
Why workaround? That how it works Le 2 nov. 2013 15:48, Howard W. Smith, Jr. smithh032...@gmail.com a écrit : The following is the workaround: Resource id=jdbc/mcmsJta type=javax.sql.DataSource JdbcDriver net.sf.hajdbc.sql.DataSource UserName Password JtaManaged true

Re: HA-JDBC via tomee.xml Resource factory/cluster properties ignored

2013-11-02 Thread Howard W. Smith, Jr.
now, i know, thanks! :) On Sat, Nov 2, 2013 at 11:09 AM, Romain Manni-Bucau rmannibu...@gmail.comwrote: Why workaround? That how it works Le 2 nov. 2013 15:48, Howard W. Smith, Jr. smithh032...@gmail.com a écrit : The following is the workaround: Resource id=jdbc/mcmsJta

Re: HA-JDBC via tomee.xml Resource factory/cluster properties ignored

2013-11-02 Thread Howard W. Smith, Jr.
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

Re: HA-JDBC via tomee.xml Resource factory/cluster properties ignored

2013-11-02 Thread Howard W. Smith, Jr.
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.comwrote: If you use context.xml youll not get as easily jta. You can set Resource attribute class-name to the impl class and setXxx

Re: HA-JDBC via tomee.xml Resource factory/cluster properties ignored

2013-11-02 Thread Howard W. Smith, Jr.
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]