Hi,

Actually, it should work just fine. When the failover from primary to secondary occurs, the connection is dropped. Your code will have to detect this drop (syb_err_handler), reconnect and perform the query again.

One thing to note is that the cluster we are talking about here is a High Availability Cluster rather than a load balancing 'cluster'.