application hanging while commit a set of rows in ASA7.0, it doesn't show an error message and doesn't succeed, can anyone know how to resolve this |
How large was the set of rows? Committing a very large transaction can take time. thanks guys, thank you john, actually it happened because of too many rows(more than 6000),partially i have done commit then it worked.. so the problem was too many rows
(26 Nov '13, 07:41)
kvraman03
|
This is usually because another connection has either the data or structure locked, and your connection is waiting. Are there other connections? Look in the help file about BLOCKING. 2
The locks are taken as the rows are modified, not during the commit. The commit should not block.
(25 Nov '13, 13:11)
John Smirnios
Replies hidden
That's what comes of not reading the question! I failed to take on board the "commit" bit!
(26 Nov '13, 08:47)
Justin Willey
|
Is the database running with or without a transaction log?