Is there any problem with RAC?
Posted: Thu 24 Jun 2010 10:48
Hi, We are using dotConnect for Oracle 5.25.39.0 to connect with Oracle 10g (10.2.0.2). When DB is normal one, every thing is OK. But when our customer upgrade to RAC (10.2.0.4), very serious problem happend. Our program is following very simple logic:
step 1: query UNSENT records
step 2: sent a record to other system
step 3: trans = conn.BeginTransaction()
step 3: mark this record with SENT status using update command
step 4: trans.Commit();
step 5: return to step 1
Usually, we select several row sent from previous loop. We think dotConnect has serious bug with trans.Commit(); If previous loop we sent 60 records, our program will resent 10 to 20 last sent record.
It bring us serious problems.
Please help.
step 1: query UNSENT records
step 2: sent a record to other system
step 3: trans = conn.BeginTransaction()
step 3: mark this record with SENT status using update command
step 4: trans.Commit();
step 5: return to step 1
Usually, we select several row sent from previous loop. We think dotConnect has serious bug with trans.Commit(); If previous loop we sent 60 records, our program will resent 10 to 20 last sent record.
It bring us serious problems.
Please help.