Re: Advanced replication: Setting timeout for insert transactions
Date: 25 Feb 2004 00:39:03 -0800
Message-ID: <a1d154f4.0402250039.5756d7eb_at_posting.google.com>
andkovacs_at_yahoo.com (Andras Kovacs) wrote in message news:<412ebb69.0402241025.1717ba91_at_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
Received on Wed Feb 25 2004 - 09:39:03 CET