By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,055 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

Advanced replication: Setting timeout for insert transactions

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.