as far as I know, this issue was specific to UniData - as it was an SQL
engine problem - not common client-side software.
When you say 'it', to you mean that you are running a SQL update statetment
with a WHERE clause and you see the records that were excluded from the
query by the WHERE clause being locked?
Or is it a less defined instance?
Do you have an open support case on this, Charles?
Regards.
Wally Terhune
SWG Client Support -
Information Management Software
U2 Support Architect b IBM U2
Client Support Team
4700 S. Syracuse St., Denver,
CO 80237
Tel: (303) 773-7969 T/L
656-7969
Mobile: (303) 807-6222
[EMAIL PROTECTED]
Register today for the premier
U2 technical event!
"Stevenson,
Charles"
<Charles.Stevenso To
[EMAIL PROTECTED]> <u2-users@listserver.u2ug.org>
Sent by: cc
[EMAIL PROTECTED]
stserver.u2ug.org Subject
RE: [U2] SQL query locks
08/27/2007 07:10
PM
Please respond to
[EMAIL PROTECTED]
er.u2ug.org
Excellent.
What about UniVerse?
I've hit it...No: It's hit me there, too.
cds
-----Original Message-----
From: Wally Terhune
Sent: Monday, August 27, 2007 10:48 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SQL query locks
If this is UniData, we fixed a problem in this area at 6.1.7 (released
3/18/05):
Issue 6917 - Problem Description
UniData -- A lock release in SQL UPDATE failed, causing SQL to hold the
locks for records that were excluded from the query with a WHERE clause.
A fix to the lock checking utility corrected this issue.
________________________
Hi,
We have a Cold Fusion app that is using SQL queries. It's locking
records, unfortunately as many as 100 at a time. Is there a way to do
the query without locking records? We're not updating anything.
Pam
--
Pamela J Robbins New Bolton Center
Senior Programmer Analyst School of Veterinary Medicine
[EMAIL PROTECTED] University of Pennsylvania
610-925-6438
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[demime 1.01d removed an attachment of type image/jpeg which had a name of
2A005220.jpg]
[demime 1.01d removed an attachment of type image/jpeg which had a name of
2A877667.jpg]
[demime 1.01d removed an attachment of type image/gif which had a name of
graycol.gif]
[demime 1.01d removed an attachment of type image/gif which had a name of
pic16518.gif]
[demime 1.01d removed an attachment of type image/gif which had a name of
ecblank.gif]
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
