Advanced replication: Setting timeout for insert transactions

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Andras Kovacs
    #1

    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 ?
    Tags: None
    • sybrandb@yahoo.com
      #2
      Re: Advanced replication: Setting timeout for insert transactions

      andkovacs@yahoo .com (Andras Kovacs) wrote in message news:<412ebb69. 0402241025.1717 ba91@posting.go ogle.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

        Comment

        Previous template Next
        Working...