Page 1 of 1

Multi thread with FB embbeded

Posted: Tue 04 Aug 2009 13:50
by flzanini
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?

Posted: Wed 05 Aug 2009 07:49
by Plash
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.

Posted: Tue 18 Aug 2009 23:10
by flzanini
I'm solved the problem using transactions.

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