[sqlite] problem with journal_mode memory to wal

2013-03-14 Thread Vitor Rosa
Hello,

I'm using windows 7 (64 bits) with sqlite 3.7.15.2 and I can't change
journal_mode to WAL, it always return memory mode.
what I can do?

Many thanks,
Vitor.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] problem with journal_mode memory to wal

2013-03-14 Thread Vitor Rosa
Hello,

After reading more carefully the documentation I found that, but I want to
create a db where I'm having just one writer and multiple readers, but I
need that the readers never get db locked when they are reading so I
thought using WAL journal_mode.

But how can I create a WAL db?

Many thanks,

Vitor.

Vitor Rosa
Corporate Relations
Local BEST Group Almada
Faculdade de Ciências e Tecnologia da Universidade Nova de Lisboa
+351 965 707 240


2013/3/14 Richard Hipp d...@sqlite.org

 On Wed, Mar 13, 2013 at 12:45 PM, Vitor Rosa v.r...@campus.fct.unl.pt
 wrote:

  Hello,
 
  I'm using windows 7 (64 bits) with sqlite 3.7.15.2 and I can't change
  journal_mode to WAL, it always return memory mode.
  what I can do?
 

 For an in-memory database, the only allowed journal modes are OFF and
 MEMORY.  Are you trying to change the journal mode to WAL on an in-memory
 database?

 --
 D. Richard Hipp
 d...@sqlite.org
 ___
 sqlite-users mailing list
 sqlite-users@sqlite.org
 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users