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" <andy.l...@quantel.com> 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: 王庆刚 [2004wqg2...@163.com] Sent: 25 August 2014 13:13 To:sqlite-users@sqlite.org; 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" <jan.nijtm...@gmail.com> 写道: 2014-08-03 9:56 GMT+02:00 Jan Nijtmans <jan.nijtm...@gmail.com>: 2014-08-02 16:00 GMT+02:00 王庆刚 <2004wqg2...@163.com>: > 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users