Subject | Re: [firebird-support] embedded server, how to lock database file |
---|---|
Author | Thomas Steinmaurer |
Post date | 2009-10-10T08:33:28Z |
Hello,
SuperClassic in 2.5, which doesn't hold an exclusive lock on the
database file. This means, that several Embedded processes or regular
Classic/SuperClassic server can connect to the same database file.
--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/
>> I am using Beta 2.5 2 embedded server on MS-Windows environments.This changed in 2.5, because Embedded is based on the new architecture
>>
>> Is there an option for making the server to open the database file in
>> exclusive mode?.
>>
>> I want to be sure that no other application can edit or change database
>> file contents while I am connected to it.
>>
>> Many thanks.
>>
>> Felipe.
>
> that is the default behaviour (unless V2.5 changes things). If you connect
> using embedded, noone else can get access to the file until you disconnect.
SuperClassic in 2.5, which doesn't hold an exclusive lock on the
database file. This means, that several Embedded processes or regular
Classic/SuperClassic server can connect to the same database file.
--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/