Jump to content
Changes to the Jaspersoft community edition download ×

Does Jasper Server supports database failover using TNS


er.navneetverma

Recommended Posts

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

To my knowledge, JasperReports Server is just using vendor provided jdbc connections.

I haven't tested this but Oracle jdbc driver supports specifying several addresses in address_list to support failover.

The JDBC client must set the oracle.net.ns.SQLnetDef.TCP_CONNTIMEOUT_STR property. This property enables the JDBC client to quickly traverse an ADDRESS_LIST in the event of a failure. For example, if the client attempts to connect to a host that is unavailable, the connection attempt will be bounded to the time specified by the SQLnetDef.TCP_CONNTIMEOUT_STR property after which the client attempts to connect to the next host in the ADDRESS_LIST. The behavior continues for each host in the ADDRESS_LIST until a connection is made.[/code]

https://docs.oracle.com/database/121/HABPT/config_fcf.htm#HABPT4967

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...