Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Driver for SQL server  RSS feed

 
Cindy Jones
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is the best driver to use for SQL server?

My requirement is to have a type 4 open source driver. I am using jtds - is this a good choice?

Thanks!
 
Amit M Tank
Ranch Hand
Posts: 257
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Why don't you get the Java Drivers(type4) from the Microsoft website?
 
Paul Clapham
Sheriff
Posts: 22199
38
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The Microsoft driver worked fine for me until it had a problem with the SSL implementation on my iSeries. Then I switched to the JTDS driver which is also working fine for me.

Why do you need an open-source driver? Do you expect you will need to look at the source code to debug problems?
 
Cindy Jones
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I meant open source as being free. I was able to get it working with jtds and I wanted to confirm that it is dependable for production.

I will also check out the Microsoft drivers.

Thanks for your responses.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!