OracleQueue problem
Posted: Wed 08 Aug 2012 13:13
Hello,
I found a problem while having this scenario:
- make sure that your queue table is empty
- execute the method OracleQueue.Dequeue(OracleQueueDequeueOptions) while a ThreadAbortException occurs.
- in the Catch block call OracleQueue.Connection.Rollback()
Result: the execution will stay blocked forever while trying to execute the Rollback operation.
DotConnect for Oracle version 7.0.6
My Oracle: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
I send you a test project that will reproduce the problem.
I found a problem while having this scenario:
- make sure that your queue table is empty
- execute the method OracleQueue.Dequeue(OracleQueueDequeueOptions) while a ThreadAbortException occurs.
- in the Catch block call OracleQueue.Connection.Rollback()
Result: the execution will stay blocked forever while trying to execute the Rollback operation.
DotConnect for Oracle version 7.0.6
My Oracle: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
I send you a test project that will reproduce the problem.