FreeTDS Development Group

[Stefan Bodewig <bodewig AT bost.de>]

>>>>> "VT" == Valentin Todorov writes:

 VT> When I start a transaction with setAutoCommit(false), create a
 VT> Statement, use it to modify data with executeUpdate(), close the
 VT> statement and then commit the transaction, NO changes will be
 VT> written to the database. 

Yes, I've stumbled across this myself. The trick is to close the
Statement _after_ the commit - as Statement causes an implicit
rollback in close.

 VT> I could not figure it out how is it in the specification, but all
 VT> other drivers I tested do it properly.

Yes, the way freetds_jdbc works felt counterintuitive at first but
seems the right way on second thought. You remind me that I wanted to
read up on this in the specs myself - if I find the time to so.

Stefan