467,198 Members | 1,301 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,198 developers. It's quick & easy.

Advanced replication: Setting timeout for insert transactions

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 ?
Jul 19 '05 #1
  • viewed: 4544
Share:
1 Reply
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
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Rohit | last post: by
5 posts views Thread by Tony Hinkle | last post: by
15 posts views Thread by Pailloncy Jean-Gérard | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.