0

I'm looking for good and free SQL server driver. Currently I'm using jtds, but it's old and I have some issues with it. SQL Server is 2014.

I found a stackoverflow question but my problem that it's outdated. Tried using sqljdbc4, but we had too many problems with it.

Can you please suggest a decent driver with good performance and low bug count. I prefer a free license, but perpetual will be fine too. Thanks.

Community
  • 1
  • 1
Mark T
  • 773
  • 4
  • 10
  • 22
  • 1
    What issues do you have with Microsoft JDBC driver? Did you check for latest updates (Version 4.2) ? – Jan Feb 15 '16 at 11:37
  • Some blobs were not working well, and I saw that people report poor performance. I saw that Microsoft released 6 (previews) – Mark T Feb 17 '16 at 09:03

1 Answers1

0

sqljdbc4 is good but have a some problems, you can try with new version.

I'm using jtds (I use Sql Server 2014, with JDK 7).

This is the POM configuration

<dependency>
    <groupId>net.sourceforge.jtds</groupId>
    <artifactId>jtds</artifactId>
    <version>1.3.0</version>
</dependency>
Joe Taras
  • 15,166
  • 7
  • 42
  • 55
  • Have you had some finalizing issues with it? or any Memory leak? I tried 250 pool size and it had a memory leak. – Mark T Feb 17 '16 at 09:07
  • Hi, no problem with memory leak. Pool size to 250 is not enough to define the root of your issue. – Joe Taras Feb 17 '16 at 10:33