The sample jConnect connection string for the Cluster Edition included in the What’s New in ESD #12 document for Open Client, Open Server, ODBC, jConnect, and ADO.NET for Adaptive Server version 15.0 is incorrect.
The sample connection string in the document is:
URL="jdbc:sybase:Tds:server1:port1,server2:port2,...,serverN:portN/mydb?JCONNECT_VERSION=6&PACKETSIZE=1024&DYNAMIC_PREPARE=true&REQUEST_HA_SESSION=true"
This string fails because the JCONNECT_VERSION=6 parameter
emulates the high availability companion server functionality. The
JDBC driver causes a client Java exception when the client tries
to use the jConnect driver’s Failover property but does
not have a hafailover server specified in the connection string.
This is the correct connection string:
URL="jdbc:sybase:Tds:server1:port1,server2:port2,...,serverN:portN/mydb?&PACKETSIZE=1024&DYNAMIC_PREPARE=true&REQUEST_HA_SESSION=true"
