Change Hostname in JDBC Datasource Programaticly

[AThompson_1]

Hello,

   Is it possible to update the hostname in the JDBC string of a saved datasource?  Our DWH has a failover node.  But it does not failover sessions and has a different IP.  Given I have the IP, can I update the datasource definition directly in the Postgres repository? Or some config file in the web app?  Essentially, pointing to the new active node WITHOUT going thru the UI.  If possible, would the app have to be restarted?  Or, would it just use the new connection string on the next access of that datasource?

TIA,

Andrew

[hozawa]

You may be able to do what you want using attributes in datasource.

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-administration-guide/v62/attributes-data-source-definitions