How we can failover node while creating datasource in VApp as we have below information from DB team .
Also can we add the load balance url when we create.
Release : 14.x
Component : CA IDENTITY SUITE (VIRTUAL APPLIANCE)
1. DB_URL entry would accept multiple hosts as an entry. The right syntax is slightly different than the one shared by your DBA (an example can be found here http://www.mastertheboss.com/jbossas/jboss-datasource/how-do-you-connect-a-datasource-to-a-cluster/ )
<connection-url>jdbc:oracle:thin:@(description=(address_list=(load_balance=on)(failover=on) (address=(protocol=tcp)(host=host1)(port=1521))(address=(protocol=tcp)(host=host2)(port=1521)))(connect_data=(service_name=xxxxsid)(failover_mode=(type=select)(method=basic)))) </connection-url>
2. Multiple hosts functionality was never tested by QA during certification. Therefore we would advise thorough testing to be made on a lower environment before applying such configuration in Production
3. From our experience, most sites will use a proxy host in the DB_URL, letting the backend application (database) to handle the load balancing, as it is bound to have a better control than an external application server.