hi, Andy Ling:
The error disk I / o error I have resolved ;
but when I used the following code:
rc = sqlite3_open("D:\\WindRiver\\SqliteOne.db",&db);
it tell me can not find the data base;
when I used the following code:
rc = sqlite3_open("SqliteOne.db",&db);
It is OK
How could I resolve the prolblem?
At 2014-08-25 11:29:57, "Andy Ling" <[email protected]> wrote:
That file name in the first error doesn't look like a vxWorks file. What
devices have you got mounted. You need to specify a file path that points to
one of the vxWorks file IO devices. By just specifying the file name in your
second example it is being created in the current directory.
The second disk I / O error is what I had before applying the patch to
unixUnlink. The error returned by vxWorks when deleting a file that doesn't
exist depends on the underlying file system. If it is a POSIX file system it
should return ENOENT. For dosFS it returns S_dosFsLib_FILE_NOT_FOUND, which in
vxWorks 6.9 is 0x380003
So if you are using yet another file system, maybe you are getting a different
error code being set. start by adding a printf to unixUnlink to find out if
that is your problem.
Regards
Andy Ling
From: 王庆刚 [[email protected]]
Sent: 25 August 2014 13:13
To:[email protected]; Andy Ling; Jan Nijtmans
Subject: Re:Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？
hi
I modified the code sqlite3.c according to you method, as follow
<http://fossil-scm.org/index.html/vpatch?from=dd5743a8239d1ce9&to=b68f65bb69a098a1>
or <http://fossil-scm.org/index.html/info/c2d4bd7365>
I test you method in workbench3.2(vxworks6.8) , the build macros which I used
in build properties is : -DOS_VXWORKS=1 -DSQLITE_THREADSAFE=0
-DSQLITE_OMIT_LOAD_EXTENSION -DHAVE_UTIME
but it still have some problems.
1. if I do as follows:
rc = sqlite3_open("D:\\WindRiver\\SqliteOne.db",&db);
it tell me the error can not open the database.
2. if I do as follows:
rc = sqlite3_open("SqliteOne.db",&db); this will be ok .
but when I do the following thing
sql = " create table stu(i int, name text);";
rc = sqlite3_exec(db,sql,NULL,NULL,&err);
it tell me the error : disk I / O error.
在 2014-08-12 08:10:13，"Jan Nijtmans" <[email protected]> 写道：
2014-08-03 9:56 GMT+02:00 Jan Nijtmans <[email protected]>:
2014-08-02 16:00 GMT+02:00 王庆刚 <[email protected]>:
> hi ， Can Sqlite3.c and sqlite.h be compiled in Workbench3.2 for
> Vxworks6.8 ?
> When I compile them , there have so many problems .
You can find the necessary changes here:
<http://fossil-scm.org/index.html/vpatch?from=dd5743a8239d1ce9&to=b68f65bb69a098a1>
thanks to Andy Ling.
Still has to be reviewed by the SQLite developers for inclusion in 3.8.6
(not tested yet on other platforms than vxworks, win32/64 and Linux,
there it works fine)
New attempt here, base on current SQLite trunk:
<http://fossil-scm.org/index.html/info/c2d4bd7365>
Regards,
Jan Nijtmans
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
