Skip to Content.
Sympa Menu

freetds - Re: Problem with JDBC commit()

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Stefan Bodewig <bodewig AT bost.de>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Problem with JDBC commit()
  • Date: 25 Apr 2000 09:32:59 +0200


>>>>> "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



  • Problem with JDBC commit(), Valentin Todorov (SEA), 04/20/2000
    • <Possible follow-up(s)>
    • Re: Problem with JDBC commit(), Stefan Bodewig, 04/25/2000

Archive powered by MHonArc 2.6.24.

Top of Page