RE: [Hibernate-devel] SQL Server 2000 questions

[Gavin_King/Cirrus%<CI...@ci...>]

For those who missed my earlier post:

> The one I have been using is JSQL from:
>
> http://www.j-netdirect.com/
>
> This particular driver seems to work beautifully.
>
> I have just verified that Weblogic jDriver also works (with one very
minor
> test failure).
>
> FreeTDS certainly does *not* work. I _think_ someone reported that
>
> http://www.inetsoftware.de/
>
> also does *not* work. (Havn't tried this myself)

> The latest version of Microsoft's driver doesn't pass all tests, but it
> does pass *some*. It might be almost possible to get it working, but I'm
> not particularly optimistic. (If you want to try, you _must_ use the
> SelectMethod=cursor JDBC connection parameter.)

Anton wrote:

> Not sure what the issues with MS driver are, but I've had good success
with
> the commercial driver JTurbo
> (http://www.newatlanta.com/products/jturbo/index.jsp).

I havn't tried this driver. Have you run the test suite against it?

The problem with the microsoft driver is not so much that hibernate's
support
for it is incomplete, so much as the fact that the driver itself does not
support some usage that _every_other_ jdbc driver I've tried _does_
support.

It wouldn't surprise me if you run into these problems even if you _don't_
use hibernate. In light of this, I would be more comfortable using JSQL or
Weblogic jDriver anyway (they cost money unfortunately).