Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


As you can see, we appended the second SQL server after the original one "localhost" separated with a comma. Don't forget to also , e.g. "localhost,"

In addition, you also need to set the failover property:


(its default value was true), otherwise you will get an error "connection is read-only. Queries leading to data modification are not allowed". MS SQL and ORACLE have similar failover settings in their JDBC connection strings. In MS SQL, it is called "failoverPartner"