Re: Advanced replication: Setting timeout for insert transactions

From: <sybrandb_at_yahoo.com>
Date: 25 Feb 2004 00:39:03 -0800
Message-ID: <a1d154f4.0402250039.5756d7eb@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 - 02:39:03 CST