Dear all,
I'm facing a problem working with transactions. I made a simple program that have 2 threads, 1 thread to read and 1 thread to write data into database. These threads works with an infinite loop to read and write data at the same time.
Sometimes the program generates an access violation exception.
Each thread has an internal transaction and the isolation level is ReadCommited.
For each write action I create a new transaction and release when the operation is finished.
For the read operations I start a transaction to read all data, and it is released only when the thread is released.
I made this test program to try to find the problem, because my real application have the same problem, 1 thread to read and 1 thread to write at the same time.
I'm using the embbeded firebird 2.5 and the IBDAC components version 3.10.0.16.
How can I send you my test program?
Best regards.