FreeTDS Development Group

["Bob Kline" <bkline AT rksystems.com>]

These issues have been raised before on this list.  Craig is still weighing
his response.  :->}

----- Original Message -----
From: "Schörk, Andreas" <andreas.schoerk AT infor.de>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Sent: Monday, October 16, 2000 11:14 AM
Subject: [freetds] JDBC, Transaction


> Hello,
> I am thinking of using freetds_jdbc in our client-server environment.
> I already made some changes to support BigDecimal-Parameters.
> Now I am a little bit confused because it seems to me that Transactions
> are statement-oriented not connection-oriented.
> Worse, for each statement I create which means for each cursor to the
> database
> a new connection is created. So if I do changes on more than one cursors I
> suspect the following situations:
>
> - Can run into deadlocks, because the locks are maintened on separate
> connections
> - can get inconsistent commits because eventually on of the connections
can
> fail to
>   commit the changes.
>
> Why are not more than one cursors created per connection ?
> It would make the handling of the procedure-cache more effective as well.
> I know about the problem with the only single existence of forward-only
> cursors in
> sql-server, but normaly it is overcome another way.
>
> Is already anybody working at this issue, is this the right mailing list,
> hope anybody hears it
>
> Andreas
>
>
>
>
> ---
> You are currently subscribed to freetds as: [bkline AT rksystems.com]
> To unsubscribe, forward this message to
$subst('Email.Unsub')