Hi: There is concern that the current version of JTDS is not being updated to support the most current versions of Sql Server (2014 thru 2019). Can someone tell me when the last stable version of the JTDS driver and whether anyone is using this version for production work with more current SQL Server versions (2014, 2016, 2017, 2019)? Appreciate timely response.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have used JTDS on SQL Server 2014 (in the year 2015). This version was
used in Production on a few very busy, mission critical, servers with no
issues.
By the way, more recently (maybe in 2018/2019) I've used the MS drivers and
actually had issues with them in a non-production environment.
Unfortunately I don't remember the details of the issues.
Hi: There is concern that the current version of JTDS is not being updated
to support the most current versions of Sql Server (2014 thru 2019). Can
someone tell me when the last stable version of the JTDS driver and whether
anyone is using this version for production work with more current SQL
Server versions (2014, 2016, 2017, 2019)? Appreciate timely response.
I don't know that I've actually used it on anything later than 2016, but, IIRC, it does work there. I don't know that there've been any substantial changes to the TDS protocol with more recent versions of SQL Server, but I'm not up on the details of that any more.
I think most people use Microsoft's own JDBC driver nowadays. That's what we use in production at my day job. I still use jTDS 1.3 with my own side business, but much of that is with older versions of SQL Server. I'm not sure there's terribly compelling reasons to use jTDS over MS's JDBC driver at this point.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi: When was the last time the JTDS driver was updated and has anyone used the most current version with Sql Server 2020?
Hi William.
Don't know when it was last updated and no I have not used this version
with the latest SQL Server.
Regards
Brennan
On Tue, Oct 20, 2020 at 3:34 PM William Williford wwilliford@users.sourceforge.net wrote:
Hi: There is concern that the current version of JTDS is not being updated to support the most current versions of Sql Server (2014 thru 2019). Can someone tell me when the last stable version of the JTDS driver and whether anyone is using this version for production work with more current SQL Server versions (2014, 2016, 2017, 2019)? Appreciate timely response.
Hi William.
I have used JTDS on SQL Server 2014 (in the year 2015). This version was
used in Production on a few very busy, mission critical, servers with no
issues.
By the way, more recently (maybe in 2018/2019) I've used the MS drivers and
actually had issues with them in a non-production environment.
Unfortunately I don't remember the details of the issues.
On Tue, Oct 20, 2020 at 4:15 PM William Williford wwilliford@users.sourceforge.net wrote:
I don't know that I've actually used it on anything later than 2016, but, IIRC, it does work there. I don't know that there've been any substantial changes to the TDS protocol with more recent versions of SQL Server, but I'm not up on the details of that any more.
I think most people use Microsoft's own JDBC driver nowadays. That's what we use in production at my day job. I still use jTDS 1.3 with my own side business, but much of that is with older versions of SQL Server. I'm not sure there's terribly compelling reasons to use jTDS over MS's JDBC driver at this point.