I see what I hijacked now... I honestly thought I deleted the whole body :|

Sorry about that.

Jason

Helen Borrie wrote:

> At 10:09 AM 3/10/2005 -0400, you wrote:
>
>>Would there be ill effects if I were to create several symlinks to the same
>>file, and super server connect to each of them x times? I would imagine it
>>would
>>be ok if locking was done completely within the fdb file, but fail if it was
>>done in memory/in a file.
>>
>>For all of those BEGGING to ask, aside from having several "main" databases, I
>>want to write a nightly script that will create symlinks like 'yesterday.fdb',
>>'amonthago.fdb', etc.
>
>
> I think it will corrupt the database. It seems to be the equivalent of the
> path string gotcha/bug that seriously corrupts InterBase databases on
> Windows and for which the exclusive lock was imposed on Superserver during
> the Fb 1.0.x beta to prevent the problem with Superserver at least. AFAIK,
> the risk is still there for Classic on Windows.
>
> The problem is, the server depends on the file path and name to distinguish
> one database from another. Since it is the OS that resolves symlinks, the
> db engine cannot tell that it is not connecting to multiple databases. So,
> for example, the entire integrity of transaction isolation goes to the
> wind; and there would be multiple uncommitted record versions all over the
> place.
>
> Why not just use different aliases for the same concrete file path? Those
> *are* resolved by the engine.
>
> Please don't hijack other people's threads.
>
> ^ heLen
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net 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
>
>
>
>
>
>
>
>