>
> Try FreeTDS (www.freetds.org, I think). I've used their straight TDS
> driver with excellent results. They also have a Type 4 JDBC
> driver as
> well. I haven't had occasion to use it, but if it performs as well as
> the straight TDS driver, I'm sure you'll be pleased.
Unfortunately it looks like their straight TDS driver and the JDBC TDS driver are
developed by two separate teams. The JDBC driver
is ok for queries and simple updates but from what I recall their idea about what is a
connection and when to automatically close
connections and commit transactions was quite non-standard.
I'd provide more detail but it was almost a year ago that I used it (and the code to
break it is on another machine). If you try it
I think the following will show the problem:
Get a connection:
Call conn.setAutoCommit(false);
get a prepared statement and update the database
close the statement
get another prepared statement and update the database
close the statement
commit the transaction
close the connection.
I think I remember their driver will either throw an exception somewhere along the way
or not show one of the updates.
HTH
