Spectrum Technology Platform

 View Only
Back to discussions
Expand all | Collapse all

How to connect oracle databse with JDBC where hosts are multiole due to failover

  • 1.  How to connect oracle databse with JDBC where hosts are multiole due to failover

    Posted 08-10-2020 05:57
    Hi Everyone, 

    I just want to know the drivers / datasource setting which helpful to connect oracle database where host's are more than one, in Spectrum.  I am able to connect the DB when host is single. Please Suggest.

    DB configuration in TNS lookslike:-

    db_abc =
    (Description =(failover=on)
    (Address  = (protocol=tcp)(host=a1)(port=p1))
    (Address  = (protocol=tcp)(host=a2)(port=p2))
    (Connect_data=(service_name=testdb)))

    ------------------------------
    Mukul Pandey
    Knowledge Community Shared Account
    ------------------------------