Re: [sqlite] Locking under various Windows versions
Robert, Makes sense. Some background ... I'm again looking into how to handle locking under Silverlight, and was looking into the WINCE method for ideas. The isolatedstoragefilestream under NET.4 claims to support the Lock method, (see http://msdn.microsoft.com/en-us/library/system.io.isolatedstorage.isolat edstoragefilestream_methods%28v=VS.100%29.aspx) but doesn't actually seem to be there under VS2010 and Silverlight 4 Might need to go the mutex route Noah -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Robert Simpson Sent: Friday, April 16, 2010 3:57 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Locking under various Windows versions WinCE has no lockfile support, so it's fudged on the device by means of a shared memory block to handle the locking. If you open a SQLite database on a network share from a CE device, then it will not be able to use the network share's locking mechanisms. In short, don't do it. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Noah Hart Sent: Friday, April 16, 2010 3:48 PM To: General Discussion of SQLite Database Subject: [sqlite] Locking under various Windows versions I am trying to determine if SQLite holds an exclusive lock on a database opened under Windows-CE, will that lock be honored by a connection opened under another version of Windows? What about the opposite case? When the database is first opened under Windows 7, an exclusive lock is acquired, then a connection to the database is made under WindowsCE. I've read the os_win.c code and am not clear how it is handled in this type of mixed mode Regards Noah Hart CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Locking under various Windows versions
WinCE has no lockfile support, so it's fudged on the device by means of a shared memory block to handle the locking. If you open a SQLite database on a network share from a CE device, then it will not be able to use the network share's locking mechanisms. In short, don't do it. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Noah Hart Sent: Friday, April 16, 2010 3:48 PM To: General Discussion of SQLite Database Subject: [sqlite] Locking under various Windows versions I am trying to determine if SQLite holds an exclusive lock on a database opened under Windows-CE, will that lock be honored by a connection opened under another version of Windows? What about the opposite case? When the database is first opened under Windows 7, an exclusive lock is acquired, then a connection to the database is made under WindowsCE. I've read the os_win.c code and am not clear how it is handled in this type of mixed mode Regards Noah Hart CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Locking under various Windows versions
I am trying to determine if SQLite holds an exclusive lock on a database opened under Windows-CE, will that lock be honored by a connection opened under another version of Windows? What about the opposite case? When the database is first opened under Windows 7, an exclusive lock is acquired, then a connection to the database is made under WindowsCE. I've read the os_win.c code and am not clear how it is handled in this type of mixed mode Regards Noah Hart CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users