Skip to Content.
Sympa Menu

freetds - Re: SQL Server 7.0 Locking

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Alex Amies" <alexamies AT e-tara.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: SQL Server 7.0 Locking
  • Date: Fri, 7 Jan 2000 18:56:00 -0800


Craig,

It turned out that the problem was a Statement that I was not closing
until the object destructor was called. Now that I do the closing
explicitly the problem went away. The driver that I was previously
using (Asha demo version) seemed to be less sensitive than FreeTDS
to my abuse of the Statement object.

Alex Amies

----- Original Message -----
From: Craig Spannring <Craig.Spannring AT kampong.aedinc.net>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Sent: Friday, January 07, 2000 10:33 AM
Subject: [freetds] Re: SQL Server 7.0 Locking


>
>
> What does the 'blk' column show in response to an 'sp_who' in the query
> analyzer?
>
>
> Alex Amies writes:
> >
> > I am experiencing a problem with locking of MS SQL Server 7.0.
> > The problem may be arising from a jdbc call with FreeTDS to
> > a stored procedure in SQL Server. The statement does not return
> > and then the entire database becomes locked. The current activity
> > area in Enterprise Manager is blank. I initially used a
> > PreparedStatement but am now using a regular Statement with the
> > same result.
> >
> > Does anyone have any ideas?
> >
> > Thanks
> >
> > Alex Amies
> >
> >
> >
> > ---
> > You are currently subscribed to freetds as: cts AT internetcds.com
> > To unsubscribe, forward this message to
$subst('Email.Unsub')
> >
> >
> >
> --
> =======================================================================
> Life is short. | Craig Spannring
> Bike hard, ski fast. | Craig.Spannring AT aedinc.net
> --------------------------------+------------------------------------
> Any sufficiently horrible technology is indistinguishable from Perl.
> =======================================================================
>
>
> ---
> You are currently subscribed to freetds as: alexamies AT e-tara.com
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>
>





Archive powered by MHonArc 2.6.24.

Top of Page