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 > > databases. > > > I had to do the following to ensure tomee would create the ha-jdbc > resource: > > 1. add the following java option > > > -Dha-jdbc.configuration=file:/apache-tomee-plus-1.6.0-SNAPSHOT/lib/ha-jdbc-cluster.xml > > > 2. tomee.xml contains the following > > <!-- > # create/reference embedded derby driver at startup, > # so the driver can be referenced when ha-jdbc resource is created > --> > <Resource id="jdbc/startup" type="javax.sql.DataSource"> > JdbcDriver org.apache.derby.jdbc.EmbeddedDriver > JdbcUrl jdbc:derby:C:/javadb/databases/startup;create=true > UserName .... > Password .... > JtaManaged false > jmxEnabled false > LogSql false > ignoreDefaultValues true > </Resource> > > > <Resource id="jdbc/mcmsJta" type="javax.sql.DataSource"> > JdbcDriver net.sf.hajdbc.sql.Driver > JdbcUrl jdbc:ha-jdbc:cluster > UserName .... > Password .... > JtaManaged true > jmxEnabled false > LogSql false > InitialSize 10 > MaxActive 100 > MaxIdle 30 > MaxWait 10000 > minIdle 10 > suspectTimeout 60 > removeAbandoned true > removeAbandonedTimeout 180 > timeBetweenEvictionRunsMillis 30000 > jdbcInterceptors=StatementCache(max=128) > </Resource> > > > 3. ha-jdbc-cluster.xml (located in tomee/lib) > > <?xml version="1.0" encoding="UTF-8"?> > <ha-jdbc xmlns="urn:ha-jdbc:cluster:2.1" > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > xsi:schemaLocation=" > http://ha-jdbc.github.io/xsd/ha-jdbc-2.1.0-beta-4.xsd"> > <sync id="full"> > <property name="fetchSize">1000</property> > </sync> > <sync id="diff"> > <property name="fetchSize">1000</property> > <property name="versionPattern">version</property> > </sync> > <state id="simple"/> > <cluster dialect="derby" balancer="simple" default-sync="full" > meta-data-cache="lazy" transaction-mode="parallel"> > <database id="db1" weight="1" > location="jdbc:derby:c:/javadb/databases/mcms;create=true"> > <user>....</user> > <password>....</password> > <property name="databaseName">mcms</property> > <property > name="driver">org.apache.derby.jdbc.EmbeddedDriver</property> > </database> > <database id="db2" weight="2" > location="jdbc:derby:c:/javadb/databases/mcmsdev;create=true"> > <user>....</user> > <password>....</password> > <property name="databaseName">mcms</property> > <property > name="driver">org.apache.derby.jdbc.EmbeddedDriver</property> > </database> > </cluster> > </ha-jdbc> > > > 4. drop ha-jdbc-2.1.0-beta-4.jar (and ha-jdbc-2.1.0-beta-4.xsd) in > tomee/lib > > SQL SELECTs are working as expected, but i'm seeking advice (in the ha-jdbc > forum) on how to configure ha-jdbc for multiple table-and-row INSERTs. :) >