Advanced replication: Setting timeout for insert transactions

From: Andras Kovacs <andkovacs_at_yahoo.com>
Date: 24 Feb 2004 10:25:11 -0800
Message-ID: <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 ? Received on Tue Feb 24 2004 - 19:25:11 CET

This message: [ Message body ]
Next message: Miran Kopmajer: "Looking for a file"
Previous message: bdj: "Re: newbie? SQL question"
Next in thread: sybrandb_at_yahoo.com: "Re: Advanced replication: Setting timeout for insert transactions"
Reply: sybrandb_at_yahoo.com: "Re: Advanced replication: Setting timeout for insert transactions"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message