Hello,
I'm trying to configure a JDBC data source to a Vertica database with the ability to use BackupServerNode. that means that if one node from the node that I'm pointing to in the data source definintion is down Cognos can use the other ones that are in the Backup server node configuration I supply. I've succeeded doing so in ODBC data source but it fails with JDBC. Here are 2 of the connection strings I've tested for this issue:
1.;LOCAL;JDBC;URL=jdbc:vertica://VERTICA:5433/vdb?BackupServerNode=10.20.4.128,10.20.4.126&ConnectionLoadBalance=1;DRIVER_NAME=com.vertica.jdbc.Driver;
2. ;LOCAL;JDBC;URL=jdbc:vertica://VERTICA:5433/vdb;DRIVER_NAME=com.vertica.jdbc.Driver;BackupServerNode=10.20.4.128,10.20.4.126&ConnectionLoadBalance=1;
note that I am able to use the data source if the main node is up.
OS - Centos 6.5
DB - Vertica 7.2.1-5
Cognos 10.2.2 FP4
Thanks for the help,
borco