Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Advanced replication: Setting timeout for insert transactions

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@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 - 12:25:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US