JAVA EXAMPLE PROGRAMS

JAVA EXAMPLE PROGRAMS
Publish Your Article Here

How to configure database failover and high availability in JBoss 7 Datasource?


If we are configuring our application for high availability and disaster recover, it is mandatory to have failover configurations at DB datasource level as well. In this page, we described how to configure database failover in JBoss 7. Close watch below JBoss datasource configurations. The "connection-url" tag contains two connection urls with a delimiter "|". The delimiter character also required to mention with "url-delimiter" tag.

With this failover configuration, JBoss connects to the first specified DB. On any failure, JBoss tries to connect to second DB url.

<datasource jndi-name="java:jboss/jdbc/HADatasource" pool-name="HADatasource" 
												enabled="true" use-java-context="true">
	<connection-url>
		jdbc:oracle:thin:@db-host:db-port/service|jdbc:oracle:thin:@db-host:db-port/service
	</connection-url>
	<url-delimiter>|</url-delimiter>
	<driver>oracle</driver>
	<security>
		<user-name>user-name</user-name>
		<password>password</password>
	</security>
</datasource>
<< Previous Program 

JBoss configuration examples

  1. How to start/stop JBoss AS 7 in standalone mode?
  2. How to load external property file in JBoss 7 classpath?
  3. How to configure Data Source (JDBC Connection Pool) in JBoss AS 7 standalone mode?
  4. How to configure database failover and high availability in JBoss 7 Datasource?
Java2Novice - YouTube Channel
  1. Java Interview Programs
  2. Data Structure Programs in Java
  3. Linked List Programs in Java
  4. Python Tutorial for Beginners
Java2Novice
Knowledge Centre
true and false are keywords?
true, false, and null might seem like keywords, but they are actually literals. You cannot use them as identifiers in your programs.
Famous Quotations
Before you go and criticize the younger generation, just remember who raised them.
-- Unknown Author
Few Random Java Examples
  1. Find longest substring without repeating characters.
  2. Write a program to find maximum repeated words from a file.
  3. Spring Dependency Injection via Constructor
  4. How to get spring application context object reference?
  5. Evaluation of an infix expression that is fully parenthesized using stack in java.
  6. Spring bean java based configuration using @Configuration and @Bean
  7. Double-ended queue (Decue) implementation using Doubly linked list.
  8. How implement bounded types (implements an interface) with generics?
  9. Spring java based configuration @Import example

About Author

I'm Nataraja Gootooru, programmer by profession and passionate about technologies. All examples given here are as simple as possible to help beginners. The source code is compiled and tested in my dev environment.

If you come across any mistakes or bugs, please email me to [email protected].

Most Visited Pages

  1. Java Interview Questions
  2. How to Create Java Custom Exception
  3. Java Interview Programs
  4. Spring-Boot Tutorial with Examples
  5. Java Constructor Chaining Examples
  6. Spring Framework Examples
  7. Write a program to find maximum repeated words from a file.
  8. Java Data Structures
  9. Java 8 new features
  10. Write a program to find common integers between two sorted arrays.

Other Interesting Sites

  1. Wikipedia
  2. ShortNews247
  3. Health Shots
Reference: Java™ Platform Standard Ed. 7 - API Specification | Java™ Platform Standard Ed. 8 - API Specification | Java is registered trademark of Oracle.
Privacy Policy | Copyright © 2022 by Nataraja Gootooru. All Rights Reserved.