Christian,
Thanks for your reply. I have been side-tracked for a few days. But
thanks for your suggestions.
You are correct. My changes are confined to os.c:
1.- Use file descriptors instead of inodes in file lock hash keys (We're
using DOS).
2.- access() function changed to either a nop or stat. (Use stat when
access() is being used to ascertain the existence of a file).
3.- fsync(): Use ioctl (FIOSYNC).
4.- unlink(): I have tried 2 approaches:
a) use remove on sqliteOsDelete() and nop the rest.
b) keep track of unlink calls and remove the files on close() if
they've been unlinked and their link count is 1 or less.
Both of these seem to work. I see no related errors and the temporary
files seem to be created and deleted correctly (Of course my
understanding on what files should be deleted and when may be totally
off).
Thanks again,
Juan//
-----Original Message-----
From: Christian Smith [mailto:[EMAIL PROTECTED]
Sent: Friday, April 23, 2004 4:04 AM
To: Juan Romano
Cc: [EMAIL PROTECTED]
Subject: Re: [sqlite] FW: Help with Porting Problem
On Tue, 20 Apr 2004, Juan Romano wrote:
>Hi, I am porting sqlite to vxworks. I use the shell to issue some
>simple SQL commands. I can create a table and then I can issue insert
>SQL statements, but when I try to display the data I inserted (by using
>select) I always get the first record and only the first record I
>inserted. I can create a second table and try the same thing and the
>same thing happens. It seems that all inserts after the first one are
>getting lost.
>
>I have had to change a number of things because of the file systems
>differences. It took some work to get the files management working
>(???), but obviously there is still some work there.
Try compiling your changes on a regular UNIX machine, and see if you get
the same results.
I thought VxWorks would be UNIX like enough to work simply with the
existing UNIX code. Is that not the case?
>
>
>
>I am sure it is my doing but I am looking for some pointers as to what
>area of the code I should be looking at. I have a bunch of debug
>statements but I don't see any error or anything suspicious. It appears
>that the data is being written to the files, but somehow it gets lost.
>May be it is the record retrieval where the problem is.
The only code you should need to update is os.c, as the other code
should
be sufficiently platform independant not to require updates.
Maybe if you posted your changes, someone else could try them.
Christian
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
