> 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