[HA-JDBC] wrong XML ?

[Freire <fr...@cs...>]

Hell all, I am new to ha-jdbc, and it seems to be a great tool !

My company provides manufacturing critical mission applications, and I am
looking for a database mirroring solution to use with them, so my interest
in ha-jdbc.

 

I have started up two hsqldb servers in my desktop, different TCP ports,
each of them with its own database file, very same schemas. When running my
test application to insert one register into the database, only the database
named "db" is updated. If I swap names between the two declared databases
into the XML, only the "db" named one is updated !!

 

I am quite sure the problem is in the xml file prepared by me, so could
someone give me some clues ?

 

Best regards, 

Eduardo Freire

CSI Engenharia e Sistemas

(11) 4072-9999

 

Visite nosso site em  <http://www.csi.ind.br> http://www.csi.ind.br

 

 

<ha-jdbc>

    <sync id="full" class="net.sf.hajdbc.sync.FullSynchronizationStrategy">

      <property name="fetchSize">1000</property>

      <property name="maxBatchSize">100</property>

    </sync>  

  <cluster balancer="simple" default-sync="full" dialect="hsqldb"
meta-data-cache="eager" transaction-mode="serial">

    <database id="db" weight="1">

      <driver>org.hsqldb.jdbcDriver</driver>

      <url>jdbc:hsqldb:hsql://localhost:9002/csi_database</url>

      <user>SA</user>

    </database>     

       <database id="db2" weight="2">

      <driver>org.hsqldb.jdbcDriver</driver>

      <url>jdbc:hsqldb:hsql://localhost:9001/csi_database</url>

     <user>SA</user>

    </database>     

   </cluster>

</ha-jdbc>