client failover connection settings for odbc and jdbc

[greggeorge]

If using a clustered Teiid configuration, how do you specify alternate host/ports to the ODBC and JDBC connections? 

I've looked at both the Teiid JDBC manual and the PostgreSQL ODBC manual and can't find anything in the connection settings to provide alternate hosts.  The closest I've found is an 'autoFailover' boolean on the JDBC connection, but this doesn't seem to be enough. 

Any help is appreciated.

Thanks.

[rareddy]

Have you seen this? Using Multiple Hosts · Teiid Documentation

[greggeorge]

I hadn't seen that.  Thanks.  Do you know the equivalent for an ODBC connection? 

And for what it's worth, I did a fair amount of searching for this documentation before posting here, but never came upon that client develop guide.  I even went to the main Teiid doc page at http://teiid.jboss.org/docs/ and looked at the same 'Client Developer Guide' for 9.x but it doesn't have that same page/info. 

[rareddy]

Another one of interest to you probably is Load balancing JBoss Data Virtualization cluster with HAProxy – Everything JBoss

As per the ODBC, I believe you provide the comma separated host names. I will try to find this out. HAProxy is nice in this regard, to centralize these concerns.