Subject RE: Re[2]: [firebird-support] Multiple Embedded Connections
Author Alan McDonald
> Hello, Paul, Alan!
>
> PV> "Windows Embedded now contains a SuperClassic instead of a
> SuperServer engine.
> PV> File locks are shared, so a database can be accessed by one or more
> PV> Embedded servers and a regular Classic or SuperClassic server at the
> same time.
> PV> Consult the Firebird 2.5 Release Notes for full details."
>
> Yes, but this provocates some people to use embedded for multi-tier
> middleware, where definitely server (not embedded) must be used.
>
> AM> It appears that updates from one process are visible to the other(s)
> AM> but I'm not sure how the second would know if a transaction is being
> AM> managedin the first - is there a lock file being written to somewhere
> that I can't find?
>
> I need to note that Embedded Firebird is a dll that works in an address
space
> of it's caller (exe). Thus EXE itself becomes "server".
> And if that "server" have bugs, chances to get broken database are much
> higher, especially if you want to use multiple exe+embedded on one DB.

I don't want to use it like this - I just want to know how it's working.
As far as corruption is concerned, I've used the embedded version for years
and this possibility seems moot to me - I've never experienced corruption -
escpeialy not in the single user/embedded databasesetup.
Alan

>
> --
> Dmitry Kuzmenko, www.ib-aid.com
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ++++++++
> Yahoo Groups Links
>
>
>