> Hello Group,
>
> I am looking at building an n-tier system, using Embedded FB as a
> local data storage at each tier until it gets to the "real" database
> (FB as well).
>
> Each tier needs to accept multiple, simultaneous TCP connections,
> update its local data as it comes in, then pass it upstream to the
> next tier.
>
> I know that you can not have two processes accessing the same embedded
> database, but can different threads belonging to the same process
> connect to a single database using one connection per thread?
>
> Primarily I do not want to have to deal with the threadsafe nightmare
> of maintaining my own text file based local cache at each tier. I also
> would like to make use record based locking rather than effectively
> table based locking, and also atomic operations which are impossible
> to implement using the file based records.
>
> Can it be used this way?
>
> Adam

BTW - AFAIU as far as thread safety is concerned, using the embedded server
involves calls to exported methods and is therefore more thread safe than
using the client library.
This was thrashed out a while ago with Nando - maybe look up his threads.
Alan