Multi Subnet Failover using the JTDS driver for MS SQL Server

[jTDSuser]

MSSQL server driver has a property called MultiSubnetFailover to when an availability group fail-over occurs, existing persistent connections to the availability group are terminated and the client must establish a new connection in order to continue working.

I would like to know if such property exists for jTDS driver. If not is there any way to acheive the same.

Appreciate your help.

Thanks in advance.

[Virgilio Felonia]

I also have the same question? Need new jTDS-SQL Server driver with MultiSubnetFailover option

Ver Felonia

[John Craig]

I'm quite sure there's no such feature. The jTDS project has been quite static for a relatively long time and I don't think it's being actively maintained. Note that the latest file versions are from June of 2013.

Many of the features in MS's JDBC driver have never been implemented (or not rolled into the project--such as Bulk Loading, which you should find a mention of in the discussions somewhere--it's been done by a jTDS user, but never incorporated into the jTDS project). My guess (I'm not familiar with the MultiSubnetFailover feature), if you need the MultiSubnetFailover option, your simplest option is to use MS's driver--I'd definitely go for sqljdbc42.jar (or later). If you're working with a Sybase DB host, rather than MS SQL Server, about the best you could do would be to check out the latest Sybase driver.