Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Mon, Sep 1, 2014 at 7:04 AM, Andy Ling wrote: > > This can be fixed by changing the patch to something like... > > #if OS_VXWORKS > }else if( errno==0x380003 || errno == 13){ /* == > S_dosFsLib_FILE_NOT_FOUND */ > rc = SQLITE_IOERR_DELETE_NOENT; > #endif > >

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

2014-09-01 13:04 GMT+02:00 Andy Ling : > Although this doesn't feel right having to keep extending the list of error > codes that are checked. > I'm not sure what else can be done though. Maybe some compile options that > let you choose. Here is a list of possible

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

> -Original Message- > From: Andy Ling > Sent: 29 August 2014 16:15 > To: '???'; sqlite-users@sqlite.org > Subject: RE: Re:RE: [sqlite] HELP sqlite3 used in vxworks has someproblem？ > > I would add a printf statement in unixDelete rather than rely on a break po

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

Cc: sqlite-users@sqlite.org; Jan Nijtmans Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？   i find it not enter the unixdelete. 发自我的 iPhone 在 2014年8月28日，22:42，Andy Ling <andy.l...@quantel.com> 写道： Sorry, I meant unixDelete   My guess is that because you are using the host

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

se). Regards Andy Ling From: 163 [mailto:2004wqg2...@163.com] Sent: 29 August 2014 03:34 To: Andy Ling Cc:sqlite-users@sqlite.org; Jan Nijtmans Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ i find it not enter the unixdelete. 发自我的 iPhone 在 2014年8月28日

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

OS your host system is running (Windows I assume in your case). Regards Andy Ling From: 163 [mailto:2004wqg2...@163.com] Sent: 29 August 2014 03:34 To: Andy Ling Cc: sqlite-users@sqlite.org; Jan Nijtmans Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ i find it not enter

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

i find it not enter the unixdelete. 发自我的 iPhone > 在 2014年8月28日，22:42，Andy Ling 写道： > > Sorry, I meant unixDelete > > My guess is that because you are using the host filing system vxWorks will be > setting yet another error code for a file that doesn’t exist. So it

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

Sorry, I meant unixDelete My guess is that because you are using the host filing system vxWorks will be setting yet another error code for a file that doesn’t exist. So it will need another check adding to unixDelete Regards Andy Ling From: 王庆刚 [mailto:2004wqg2...@163.com] Sent: 28 August

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

Is unixUnlink an function? If it is , but I can not find the funtion in sqlite3.c. Regards Wang Qinggang At 2014-08-28 00:03:23, "Andy Ling" wrote: So you are using a host file system. You should be able to make the open work by using rc =

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

Sorry, I meant unixDelete My guess is that because you are using the host filing system vxWorks will be setting yet another error code for a file that doesn’t exist. So it will need another check adding to unixDelete Regards Andy Ling From: 王庆刚 [mailto:2004wqg2...@163.com] Sent: 28 August

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

So you are using a host file system. You should be able to make the open work by using rc = sqlite3_open("host:D:/WindRiver/SqliteOne.db",); You have to use a path and file name that works in the vxWorks domain. It shouldn’t be necessary to use �CDSQLITE_ENABLE_LOCKING_STYLE=1. In fact it has

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

Firstly: I fixed the disk I/O error by adding -DSQLITE_ENABLE_LOCKING_STYLE=1 to the build macro. Secondly: rc = sqlite3_open("D:\\WindRiver\\SqliteOne.db",); I change it to the following cd("host:D:/WindRiver"); rc = sqlite3_open("SqliteOne.db",); can fix the problem : unable to open

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 26, 2014 at 8:44 AM, 王庆刚 <2004wqg2...@163.com> wrote: > 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",); > it tell me can not find the data base; > Have you tried instead:

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

As I said before, that doesn’t look like a vxWorks path to a file. Are you sure D:\\WindRiver really exists? In general vxWorks uses the forward slash (/) as a path separator. Is this a remote mounted host file system you are trying to use? What is your current directory when it works the

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

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",); it tell me can not find the data base; when I used the following code: rc = sqlite3_open("SqliteOne.db",); It is OK How could I resolve the

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

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

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

hi I modified the code sqlite3.c according to you method, as follow or I test you method in workbench3.2(vxworks6.8) , the build macros which I used

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

sqlite.org] on behalf of Jan Nijtmans [jan.nijtm...@gmail.com] Sent: 14 August 2014 08:19 To: General Discussion of SQLite Database Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ 2014-08-13 14:31 GMT+02:00 Andy Ling <andy.l...@quantel.com>: > > From: drhsql...@gm

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

2014-08-13 14:31 GMT+02:00 Andy Ling : > > From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of > Richard Hipp > > OK, I did find some cases where unlink() is called on files that do not > exist. > > > Anyway, a patch has now been checked in. > > Great,

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

> From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of Richard > Hipp > Sent: 13 August 2014 12:40 > To: Andy Ling > Cc: General Discussion of SQLite Database > Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ > OK, I did find so

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem ？

There's a class of errors that affect lots of programs, where backup and/or antivirus software have a file open "unexpectedly", which causes routine operations such as delete and rename to fail unexpectedly. I once promoted a fix for sqlite that combatted these problems by retrying such

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem ？

There's a class of errors that affect lots of programs, where backup and/or antivirus software have a file open "unexpectedly", which causes routine operations such as delete and rename to fail unexpectedly. I once promoted a fix for sqlite that combatted these problems by retrying such

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

--Original Message- > > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > > boun...@sqlite.org] On Behalf Of Andy Ling > > Sent: 13 August 2014 10:06 > > To: 'Richard Hipp' > > Cc: General Discussion of SQLite Database > > Subject: Re: [sqlite] HELP sqlit

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Andy Ling > Sent: 13 August 2014 10:06 > To: 'Richard Hipp' > Cc: General Discussion of SQLite Database > Subject: Re: [sqlite] HELP sqlite

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

> If your build is frequently trying to unlink a file that does not exist, > then something is wrong.  We need to figure out what that is and fix it. I have added some debug. First I create a brand new database called /ata0:3/testdb.sql Then I try and create a table and get an error from

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

...@sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: 12 August 2014 20:59 To: General Discussion of SQLite Database Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ On Tue, Aug 12, 2014 at 3:54 PM, Andy Ling <andy.l...@quantel.com> wrote: > > I did wond

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 3:54 PM, Andy Ling wrote: > > I did wonder if SQLite was making any assumptions about current > directories or the makeup of a file name. > No. Any filename will do. You have to specify -DSQLITE_ENABLE_8_3_NAMES if your filesystem is limited to

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Simon Slavin [slav...@bigfraud.org] Sent: 12 August 2014 20:16 To: General Discussion of SQLite Database Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ On 12 Aug 2014

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On 12 Aug 2014, at 7:46pm, Andy Ling wrote: > I can tell you the name of the database file is /ata0:3/testdb.sql and it > gets created. Can you add some commands to one of your apps using the library which create and delete a file in '/ata0:3/' and see they work ? In

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

n behalf of Richard > Hipp [d...@sqlite.org] > *Sent:* 12 August 2014 19:15 > > *To:* Andy Ling > *Cc:* General Discussion of SQLite Database; 王庆刚 > *Subject:* Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ > > What is the name of the file that SQLite is tr

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

Andy Ling From: drhsql...@gmail.com [drhsql...@gmail.com] on behalf of Richard Hipp [d...@sqlite.org] Sent: 12 August 2014 19:15 To: Andy Ling Cc: General Discussion of SQLite Database; 王庆刚 Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ What

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

What is the name of the file that SQLite is trying to delete but which does not exist? And what is the name of the corresponding database file? The name of the file that fails unlink() will give us a big clue about what is going wrong. On Tue, Aug 12, 2014 at 2:13 PM, Richard Hipp

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 2:00 PM, Andy Ling wrote: > Because the file doesn't exist. I assume because this is a brand new > database the file hasn't been created yet. > > I did debug this originally, but I don't remember the file it is trying to > delete. It definitely

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

] Sent: 12 August 2014 18:01 To: Andy Ling Cc: General Discussion of SQLite Database; 王庆刚 Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ On Tue, Aug 12, 2014 at 12:45 PM, Andy Ling <andy.l...@quantel.com<mailto:andy.l...@quantel.com>> wrote: Doing a create table gene

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 12:45 PM, Andy Ling wrote: > Doing a create table generates a disk I/O error > > > > I open / create a new database with sqlite3_open_v2 > > > > *int* err = sqlite3_open_v2 (file, , SQLITE_OPEN_READWRITE | > SQLITE_OPEN_CREATE, "unix-namedsem") ;

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

generates a disk I/O error. I assume it is trying to remove a temporary file. Regards Andy Ling From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of Richard Hipp Sent: 12 August 2014 17:24 To: Andy Ling Cc: General Discussion of SQLite Database; 王庆刚 Subject: Re: [sqlite] HELP sq

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 11:40 AM, Andy Ling wrote: > > From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of > Richard Hipp > > Sent: 12 August 2014 15:46 > > > I put a new snapshot on the download page. Please try it, *without* > SQLITE_ENABLE_LOCKING_MODE.

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

> From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of Richard > Hipp > Sent: 12 August 2014 15:46 > I put a new snapshot on the download page.  Please try it, *without* > SQLITE_ENABLE_LOCKING_MODE. OK, it builds, but doesn't run. It is missing the patch to unixDelete. Whilst

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 10:38 AM, Andy Ling wrote: > 've just downloaded the latest pre-release > sqlite-amalgamation-201408081749.zip > a > I put a new snapshot on the download page. Please try it, *without* SQLITE_ENABLE_LOCKING_MODE. -- D. Richard Hipp

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

> From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of Richard > Hipp > Sent: 12 August 2014 14:28 > To: Andy Ling > On Tue, Aug 12, 2014 at 9:23 AM, Andy Ling wrote: >> I have been testing >> the changes Jan has made and at the moment I am happy. > But

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 9:37 AM, Jan Nijtmans wrote: > 2014-08-12 15:27 GMT+02:00 Richard Hipp : > > > But we cannot use Jan's changes directly because he lives in a > jurisdiction > > that does not recognize the ability of an author to contribute their

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

2014-08-12 15:27 GMT+02:00 Richard Hipp : > But we cannot use Jan's changes directly because he lives in a jurisdiction > that does not recognize the ability of an author to contribute their work > into the public domain. We can only use Jan's changes as a guideline for >

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 9:23 AM, Andy Ling wrote: > > > I have been testing > the changes Jan has made and at the moment I am happy. > But we cannot use Jan's changes directly because he lives in a jurisdiction that does not recognize the ability of an author to

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of Richard Hipp Sent: 12 August 2014 13:27 > This is very awkward working through a proxy.  If Mr. Ling (or anybody else > with access > to a VxWorks development system) wants VxWorks support in SQLite, he can > come to > this

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

2014-08-12 14:26 GMT+02:00 Richard Hipp : > This is very awkward working through a proxy. If Mr. Ling (or anybody else > with access to a VxWorks development system) wants VxWorks support in > SQLite, he can come to this mailing list himself and submit suggestions > here, where

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 8:10 AM, Jan Nijtmans wrote: > New attempt here, base on current SQLite trunk: > > I fixed the obvious errors in the fileHasMoved() routine. But as for the other patches, I don't understand

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

2014-08-03 9:56 GMT+02:00 Jan Nijtmans : > 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

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

> -Original Message- > > 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 . > > ___ > >

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

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 . > ___ > sqlite-users mailing list >