Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

is JTDS driver outdated?

Tags:

java

sql-server

jdbc

jtds

I'm now trying to decide which driver to use to create a DataSource from my JavaEE application to MS SqlServer.

A couple of years ago I had good experience with JTDS, and SO answers suggest that JTDS was a preference back then.

But now I can see that its latest version 1.2.5 is two years old (2009-12-30).

Is it a good enough reason to choose MS proprietary driver, or is JTDS so good that it doesn't require any development anymore? :)

like image 563
Oleg Mikheev Avatar asked Dec 27 '11 08:12

Oleg Mikheev

People also ask

What is the difference between JTDS and JDBC?

One relevant difference is, that the JDBC 4.0 Implementation of the JTDS-Driver (v1. 3.1) requires at least Java 7, whereas the JDBC 4.0 Implementation of the Microsoft driver is available in Java 6. This is important if you want to use Hibernate 4.3 (relying on JDBC 4.0 API) and support Java 6.

What is use of JTDS?

jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000, 2005, 2008 and 2012) and Sybase Adaptive Server Enterprise (10, 11, 12 and 15). jTDS is based on FreeTDS and is currently the fastest production-ready JDBC driver for SQL Server and Sybase ASE.

What is jTDS?

jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000, 2005, 2008 and 2012) and Sybase Adaptive Server Enterprise (10, 11, 12 and 15). jTDS is based on FreeTDS and is currently the fastest production-ready JDBC driver for SQL Server and Sybase ASE.

Why doesn't jTDS work with MS SQL Server?

Because MS SQL Server protocol has many proprietary parts, MS can perform changes that break jTDS when you apply maintenance updates on the server. Not as up-to-date as the MS driver. When MS launches a new SQL Server version, the JDBC drivers are usually released together. jTDS must work to catch up and that may take months.

What is the difference between Microsoft JDBC driver and jTDS driver?

Microsoft's driver is actively maintained, where jTDS hasn't been updated since 2014 (and prior to the small round of updates done in 2014 it hadn't been updated for multiple years). Microsoft offers a full JDBC4.2 (Java 8) driver and supports all the features of SQL Server, including SQL Server 2016.

How do I install the jTDS driver?

The JTDS driver provides connections for MSSQL databases. To install the JDBC driver: Download the JTDS.zip archive. For other drivers, see the list of supported drivers.

1 Answers

Microsoft JDBC driver is JDBC 4.0 compliant while jTDS is JDBC 3.0.

Here are some new features and improvements introduced in version 4.0 of JDBC.

like image 136
Funky coder Avatar answered Oct 08 '22 20:10

Funky coder
Sign in to Comment

Related questions

How to get Date pattern from Timezone of Locale in Java
How to Modify DateFormatSymbols month values
Is there a implementation of retainAll() with custom Comparators?
How to change workspace JRE in Eclipse
How do I strip subdirectories when using maven dependency plugin
What does BufferBlob::Interpreter in JVM crash log mean?
Keeping secret key SECRET - within Android app.. any ideas
Java ExecutorService invokeAll() interrupting
How to use default-servlet-handler
Having some issues with making pacman?
Java. local classes is there any reason not to make it final?
Does anyone know of code that wraps JOptionPane using the builder pattern?
Play's continuations holding http threads
How to simulate clothes changes in 2D image?
How to set base url in Flying-Saucer, while rendering HTML to PDF?
Can Java EE 7's core interfaces (EntityManager, ...) extend AutoClosable?
How do I know that my message was sent successfully with spring amqp?
Jersey Client KeepAlive
velocity directives add whitespace too?
Store, convert to video an stream Android screen

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!