i am using type 4 driver with fp3 on windows 64bit server, auto commit
is true, cursor is CS type.
i have a sensitive , updatable cursor open and bring back a one row
resultset, i get this locklist
Lock Name = 0x020027011C0000000000000052
Lock Attributes = 0x00000000
Release Flags = 0x00000002
Lock Count = 1
Hold Count = 0
Lock Object Name = 28
Object Type = Row
Tablespace Name = USERSPACE1
Table Schema = xx
Table Name = xx
Mode = U
Lock Name = 0x02002701000000000000000054
Lock Attributes = 0x00000000
Release Flags = 0x00000003
Lock Count = 2
Hold Count = 2
Lock Object Name = 295
Object Type = Table
Tablespace Name = USERSPACE1
Table Schema = xx
Table Name = xx
Mode = IX
after that i will do update on this row, once the update statement
execute. statement.execute(sql), i still have a table IX lock there,
why the commit part not working? i have tried to explicitly call
conn.commit() still not help. but this will cause us problem since we
don't want to have IX lock stay after commit. Does this is the way
work on DB2?
Lock Name = 0x02002701000000000000000054
Lock Attributes = 0x00000000
Release Flags = 0x00000003
Lock Count = 2
Hold Count = 2
Lock Object Name = 295
Object Type = Table
Tablespace Name = USERSPACE1
Table Schema = xx
Table Name = xxx
Mode = IX 2 4449
I don't use JDBC 2 feature.
Where can I find the definition of a sensitive cursor? Is it a scroll
cursor?
AFAIK, when using updatable cursor, you need turn off the autocommit,
otherwise you may lose the cursor handle.
xixi wrote: i am using type 4 driver with fp3 on windows 64bit server, auto commit is true, cursor is CS type.
i have a sensitive , updatable cursor open and bring back a one row resultset, i get this locklist
Lock Name = 0x020027011C0000000000000052 Lock Attributes = 0x00000000 Release Flags = 0x00000002 Lock Count = 1 Hold Count = 0 Lock Object Name = 28 Object Type = Row Tablespace Name = USERSPACE1 Table Schema = xx Table Name = xx Mode = U
Lock Name = 0x02002701000000000000000054 Lock Attributes = 0x00000000 Release Flags = 0x00000003 Lock Count = 2 Hold Count = 2 Lock Object Name = 295 Object Type = Table Tablespace Name = USERSPACE1 Table Schema = xx Table Name = xx Mode = IX
after that i will do update on this row, once the update statement execute. statement.execute(sql), i still have a table IX lock there, why the commit part not working? i have tried to explicitly call conn.commit() still not help. but this will cause us problem since we don't want to have IX lock stay after commit. Does this is the way work on DB2?
Lock Name = 0x02002701000000000000000054 Lock Attributes = 0x00000000 Release Flags = 0x00000003 Lock Count = 2 Hold Count = 2 Lock Object Name = 295 Object Type = Table Tablespace Name = USERSPACE1 Table Schema = xx Table Name = xxx Mode = IX
WITH HOLD... WITH HOLD... WITH HOLD...
xixi wrote: i am using type 4 driver with fp3 on windows 64bit server, auto commit is true, cursor is CS type.
i have a sensitive , updatable cursor open and bring back a one row resultset, i get this locklist
Lock Name = 0x020027011C0000000000000052 Lock Attributes = 0x00000000 Release Flags = 0x00000002 Lock Count = 1 Hold Count = 0 Lock Object Name = 28 Object Type = Row Tablespace Name = USERSPACE1 Table Schema = xx Table Name = xx Mode = U
Lock Name = 0x02002701000000000000000054 Lock Attributes = 0x00000000 Release Flags = 0x00000003 Lock Count = 2 Hold Count = 2 Lock Object Name = 295 Object Type = Table Tablespace Name = USERSPACE1 Table Schema = xx Table Name = xx Mode = IX
after that i will do update on this row, once the update statement execute. statement.execute(sql), i still have a table IX lock there, why the commit part not working? i have tried to explicitly call conn.commit() still not help. but this will cause us problem since we don't want to have IX lock stay after commit. Does this is the way work on DB2?
Lock Name = 0x02002701000000000000000054 Lock Attributes = 0x00000000 Release Flags = 0x00000003 Lock Count = 2 Hold Count = 2 Lock Object Name = 295 Object Type = Table Tablespace Name = USERSPACE1 Table Schema = xx Table Name = xxx Mode = IX This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Marco Bubke |
last post by:
Hi
There is the Lock object in the threading module.
But there is no medode there I could aquire a scoped
lock like:
mutex = threading.Lock()
my_lock = mutex.scoped_acquire() # maybe...
|
by: Christoph Zeltner |
last post by:
hi,
i am writing a thesis on the concurrency control in db2 udb and oracle. I
found in the documentary of db2, that
a resource holding a (U)pdate-Lock can still be requested by a read-lock...
|
by: Sunny |
last post by:
Hi,
I can not understend completely the lock statement.
Actally what is locked:
1. the part of the code between {...}
or
2. the object in lock()
In the docs is written:
for 1: The lock...
|
by: Andrew Morton |
last post by:
I am caching some data in VB.NET using System.Web.Caching, is it possible to
lock the cache so that other sessions attempting to access the same cache
wait when it is being updated? I have the...
|
by: Duncan Grisby |
last post by:
Hi,
I have encountered a problem with the re module. I have a
multi-threaded program that does lots of regular expression searching,
with some relatively complex regular expressions....
|
by: adri4n |
last post by:
as wat ive mentioned in the title.. im would like to know whether the a
particular record/table is being locked in my program. some of the
methods which i would like to develop are as below:
...
|
by: Ron M. Newman |
last post by:
Hi. Quick question:
- I have a class with fields. There is one method that modifies them.
in this method I have something like
lock (this.lockObject)
{
/// throwing exception here...
}
|
by: Roopesh |
last post by:
Hi,
In my mod_python project I am using mysql as the database. There is
table card in which unique cards are stored. When a user request comes
he has to get a unique card. In this situation I want...
|
by: Samuel R. Neff |
last post by:
When is it appropriate to use "volatile" keyword? The docs simply
state:
"
The volatile modifier is usually used for a field that is accessed by
multiple threads without using the lock...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
| |