Multi thread with FB embbeded

flzanini · Post by **flzanini** » Tue 04 Aug 2009 13:50

Hi,

I'm working with Interbase 2.1.2 embedded using the Interbase Data Access Components, VCL.

In some tests, I realized that the database file cannot be modified in an multi thread architeture. Based on that I created a TMultiReadExclusiveWriteSynchronizer to syncronize the threads, not allowing write on the file while reading.

This is necessary using the Devart components? There is a form to control this with transactions?

Plash · Post by **Plash** » Wed 05 Aug 2009 07:49

Please specify whether you are using different connections in each thread.

Probably this limitation is related to Firebird embedded server. If you are using different connections and still get the error, I think you need your synchronizer.

flzanini · Post by **flzanini** » Tue 18 Aug 2009 23:10

I'm solved the problem using transactions.

Basically, for each operation, I create a new transaction object to the StoredProcedure object.