We use jtds in production for some critical systems. I wish it had better connection pooling support though. The windows authentication works fine so we're pretty OK.
I just haven't had enough experience with the MSFT driver to make a good comparison. I remember trying some tests with it and it seemed OK but they were far from exhaustive.
Do you have a good solution for pooling with JTDS?
Good Luck,
David
On Apr 13, 2010, at 1:47 PM, Dov Rosenberg wrote:
> We were looking to move to the Microsoft driver, thinking that MSFT will be
> more motivated to keeping it current. We have been using the JTDS driver but
> up until a couple of months ago it had rarely been updated.
>
> Any thoughts regarding JTDS versus MSFT driver?
>
> Thanks
>
> Dov
>
>
> On 4/13/10 1:43 PM, "David Brusowankin" <skidance..mail.com> wrote:
>
>> Can't you use the jtds driver rather than the microsoft driver? Jtds works
>> fine with Java 6.
>>
>> Good Luck,
>> David
>>
>> On Apr 13, 2010, at 11:14 AM, Dov Rosenberg wrote:
>>
>>> Has anyone run into any issues with using the latest Microsoft JDBC 2.0
>>> driver for SQL Server? We are running under Java 6 which requires the
>>> sqljdbc4.jar driver which incorporates JDBC4 spec. We are running into
>>> strange behavior where the EOF framework is using NSData types for nvarchar
>>> or nchar because it seems that the JDBCInfo is returning –9 and –16 instead
>>> of the expected data types.
>>>
>>> Any help or ideas would be appreciated
>>>
>>> Thanks in advance
>>>
>>> Dov
>>
>
This archive was generated by hypermail 2.0.0 : Tue Apr 13 2010 - 14:04:22 EDT