Subject RE: [firebird-support] Multiple Embedded Connections
Author Alan McDonald
> Hi Alan,
>
> > I notice that it is now possible to connect to a database via the
> > embedded server and simultaneously connect via other embedded
> > processes to the same database file. This was not possible in previous
> > version - the second process would be locked out.
> >
> > Can someone lead me to an explanation of how these multiple
> > connections are managed? Which embedded server will coordinate
> updates
> > and modifications to the database?
> >
> > It appears that updates from one process are visible to the other(s)
> > but I'm not sure how the second would know if a transaction is being
> > managedin the first - is there a lock file being written to somewhere
that I
> can't find?
> >
> > (WIN32) V2.5
>
> From the 2.5 Quick Start Guide:
>
> "Windows Embedded now contains a SuperClassic instead of a SuperServer
> engine.
> File locks are shared, so a database can be accessed by one or more
> Embedded servers and a regular Classic or SuperClassic server at the same
> time.
> Consult the Firebird 2.5 Release Notes for full details."

Yes - but where is this global lock table? It doesn't tell me if it's a file
somewhere or in the memory of the first server loaded?
Alan

>
> Cheers,
> Paul Vinkenoog
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ++++++++
>
> 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
>
>
>