[tinysql] [Fwd: tinySQL and locking?]

Taq taquera@sherito.org
Fri, 19 Mar 2004 22:58:01 +0100


Hi,

the DBF-type field is a combined field:

bit 0-2 describe the DBase-Version used
bit 3 indicates whether the memo-field is used
bit 4-6 are reserved for SQL (no clue what that part of the specs
really means)
bit 7 also indicates that the file is a dBaseIII with memos

Source:
http://www.dbase.com/KnowledgeBase/int/db7_file_fmt.htm

And our driver does not support any kind of locking
(as java 1.2 has no way to request a lock for a file region -
only complete files are locked). And the whole driver is
not synchronized, all Database actions should occur on
a single thread.

Have mo' fun,
said Thomas

Brian Jepson wrote:
> Hi--unfortunately, tinySQL is neither thread-safe, nor does it support
> these kind of locks.
> 
> I'm not sure about the version numbers, though...
> 
> On Wed, 17 Mar 2004, Thomas Siedschlag wrote:
> 
> 
>>Hi,
>>
>>I have some questions about tinySQL.
>>
>>Does tinySQL support dbase table or record locks? If yes, how can I
>>switch on? Is tinySQL thread-safe?
>>
>>We need to write data to a simply DBase IV file without memos. I wrote a
>>little test program to create a new dbase file and set as tabletype
>>property values 'db4sql' and 'db4sqlsys'. I expected a 0x04 as version
>>byte in the dbase file, but I got a 0x43 and 0x63 as version?
>>
>>Best regards
>>--
>>Thomas Siedschlag
>>x-cellent technologies GmbH
>>Rosenkavalierplatz 5
>>81925 Muenchen
>>Germany
>>e-mail thomas.siedschlag@x-cellent.com
>>http://www.x-cellent.com
>>
>>_______________________________________________
>>tinysql mailing list
>>tinysql@as220.org
>>http://as220.org/mailman/listinfo/tinysql
>>
> 
> 
> 
> _______________________________________________
> tinysql mailing list
> tinysql@as220.org
> http://as220.org/mailman/listinfo/tinysql


-- 
Hi! I'm a evil cooperative .signature virus! Copy me into your 
~/.signature to help me spread and delete 10 random files from your 
system. Thank you!