freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Problem with JDBC commit()

From: "Valentin Todorov (SEA)" <Valentin.Todorov AT sea.ericsson.se>
To: "'freetds AT franklin.oit.unc.edu'" <freetds AT franklin.oit.unc.edu>
Subject: Problem with JDBC commit()
Date: Thu, 20 Apr 2000 13:28:17 +0200

Hello,

I observed the following problem with the freetds_jdbc driver (snapshot
31.03.00, JDK 1.2.2, MSSQL 7.0):

When I start a transaction with setAutoCommit(false), create a Statement, use
it to modify data with executeUpdate(), close the statement and then commit
the transaction, NO changes will be written to the database. The commit will
be done properly ONLY if I leave the statement open - as in test t0010.

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

A test example is attached - similar to t0010.

Regards,
Valentin

-------------------------------------------------------------------
Valentin Todorov
Ericsson Austria AG
Pottendorferstrasse 25-27
A-1121 Vienna
email: mailto:valentin.todorov AT sea.ericsson.se
Telefon: +43 1 811 00 5569
Telefax: +43 1 81100 11 5569
-------------------------------------------------------------------

Attachment: mt002.java
Description: Binary data

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