freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: jdbc 2.0 driver + sqlserver 7.0 + begin + commit transaction

From: Bob Kline <bkline AT rksystems.com>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Subject: Re: jdbc 2.0 driver + sqlserver 7.0 + begin + commit transaction
Date: Mon, 4 Jun 2001 08:33:42 -0400 (EDT)

On Mon, 4 Jun 2001 ismo.tuononen AT solenovo.fi wrote:

> I get exception:
>
> Exception in thread "main" java.sql.SQLException: The COMMIT
> TRANSACTION request has no corresponding BEGIN TRANSACTION.

I'm guessing that this has to do with the fact that the driver opens
multiple connections when multiple statements are submitted, which
introduces a number of anomalies, including breaking the transaction
model. As far as I am aware, there have never been any responses to the
questions posted here as to why this behavior is present in the driver,
or what would be broken if we tried to correct it.

--
Bob Kline
mailto:bkline AT rksystems.com
http://www.rksystems.com

jdbc 2.0 driver + sqlserver 7.0 + begin + commit transaction, ismo . tuononen, 06/04/2001
- <Possible follow-up(s)>
- Re: jdbc 2.0 driver + sqlserver 7.0 + begin + commit transaction, Bob Kline, 06/04/2001