an*******@yahoo.com (Andras Kovacs) wrote in message news:<41**************************@posting.google. com>...
I have a "insert into" transaction that hangs because there is a lock
on the table and one of its rows. (Advanced syncron replication causes
this locking problem.) Unfortunately adv replication is not perfectly
aware of locks.
The transaction hangs for 60 seconds thant stops with an ORA-02949
error. Is there a way to change the default timeout for an "insert
into" transaction.
What would be the setting in Oracle ?
What would be the setting in Java ?
In 8i and below there isn't.
The only solution would be to issue a lock .. nowait
prior to the insert.
Sybrand Bakker
Senior Oracle DBA