#20 how to find active database while execution

[Naren]

Hi All,

I have two parts in my project one is publish(in this case we are publishing the same data to multiple servers) and second one is Execution(in this case we use the published data for execution), I am using HA-JDBC with SQL, In publish am able to access ha-jdbc-dcf.xml from server classpath and published data to multiple servers. But in execution i am not able to find which database is active for getting data.

here is my ha-jdbc-dcf.xml

<ha-jdbc xmlns="urn:ha-jdbc:cluster:3.0">

<sync id="full">
    <property name="fetchSize">1000</property>
</sync>

<sync id="diff">
    <property name="fetchSize">1000</property>
    <property name="versionPattern">version</property>
</sync>

<cluster default-sync="diff" balancer="load" dialect="hsqldb">

    <database id="db1"
        location="jdbc:hsqldb:hsql://192.168.103.25:8765/PricingDatabase">
        <user>sa</user>
        <password></password>
    </database>

    <database id="db2"
        location="jdbc:hsqldb:hsql://192.168.103.52:9944/PricingDatabase">
        <user>sa</user>
        <password></password>
    </database>

     <database id="db3"
        location="jdbc:hsqldb:hsql://192.168.103.15:9933/PricingDatabase">
        <user>sa</user>
        <password></password>
    </database>

    <database id="db4"
        location="jdbc:hsqldb:hsql://192.168.103.35:9922/pricingdatabase">
        <user>sa</user>
        <password></password>
    </database>

</cluster>

</ha-jdbc>

while execution am getting connection refused error.
plz help on this.

[Anonymous]

Can you post the stack trace containing the exception?