If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

JDBC failover with BackupServerNode

Started by borco, 15 Aug 2016 05:16:20 AM

Previous topic - Next topic

borco

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