Community

Problem of jboss server starting on connection failover

created by Priyanka Sharma in Datasource Configuration - View the full discussion

Hi

 

I am working on failover condition of a datasource.

 

When a request comes, if primary datasource is not available then the request should go to the secondary datasource without restarting the jboss server.

 

I have added ha-local-tx-datasource in *-ds.xml

 

<ha-local-tx-datasource>        

  •   <jndi-name>HADefaultDS</jndi-name>        
  •    <!-- list of connection URLs -->        
  •    <connection-url>jdbc:oracle:thin:@oraclehost:1521:SID|jdbc:oracle:thin:@oraclehost:1521:SID2         
  •    </connection-url>         
  •    <url-delimiter>|</url-delimiter>
  • </ha-local-tx-datasource>

  • Problem m facing is, i have to restart the jboss server in case of 1st datasource connection fails. I want to rid of manual server startup.
  • Please suggest me how to send the request on secondary datasource transparently.         

 

 

Thanks in advance.

Reply to this message by going to Community

Start a new discussion in Datasource Configuration at Community