Enabling fail-over for MS SQL Server databases in JBoss

Solution Verified - Updated -

Issue

Our production SQL Server is set up with Database mirroring (in high safety mode) with automatic failover to mirror database server if principal database server becomes unavailable.
I would like to configure JBoss AS to automatically change database connections to mirror server (prdsql2), when principal database server (prdsql1) goes down.

Is this automatic failover recommended with JBoss AS, if so; please provide info what parameters should be set?
My current datasource file is as below:

<local-tx-datasource>
    <jndi-name>myDS</jndi-name>
    <connection-url>jdbc:sqlserver://prdsql1.example.com:1433</connection-url>
    <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
    ...
</local-tx-datasource>
  • A-MQ Master/Slave with SQL Server Mirroring?
    We're looking into setting up A-MQ on two servers as Master/Slave with SQL Server as the message store. Most of what I've read talks about having a single database. However, to give us "high-
    availability", we'd like to use SQL Server Mirroring so it's replicated across two database servers - that way, if one of the database servers goes down, everything will carry on working from the other
    server.

    I think what we're wanting to do is basically the "clustered JDBC database" as described on "http://activemq.apache.org/replicated-message-store.html". I haven't found much other documentation
    on this, so please can you confirm I've understood it correctly? Are you able to confirm that SQL Server Mirroring is supported for this?

Environment

  • JBoss Enterprise Application Platform (EAP) 4.3
  • MS SQL Server

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.