Re: [sqlite] Problem with savepoints

2016-07-06 Thread Eduardo Morras
On Wed, 6 Jul 2016 18:10:34 +0200 Chris Brody wrote: > > > > Just for my information, what is the purpose of this temporary > > file? I see > >> that -journal file is always stored to disk. > >> > > > > It's a statement journal: > > > >

Re: [sqlite] Problem with savepoints

2016-07-06 Thread Dan Kennedy
On 07/06/2016 11:10 PM, Chris Brody wrote: Just for my information, what is the purpose of this temporary file? I see that -journal file is always stored to disk. It's a statement journal: https://www.sqlite.org/tempfiles.html#stmtjrnl Recent changes mean that the first 64KiB of a

Re: [sqlite] Problem with savepoints

2016-07-06 Thread Chris Brody
> > Just for my information, what is the purpose of this temporary file? I see >> that -journal file is always stored to disk. >> > > It's a statement journal: > > https://www.sqlite.org/tempfiles.html#stmtjrnl > > Recent changes mean that the first 64KiB of a statement journal are always >

Re: [sqlite] Problem with savepoints

2016-07-06 Thread Dan Kennedy
On 07/06/2016 10:52 PM, Jeff Archer wrote: On Wed, Jul 6, 2016 at 10:46 AM, Dan Kennedy wrote: On 07/06/2016 09:09 PM, Jeff Archer wrote: Hi All, I am a long time SQLite user but have generally used it from C++ in the past. In this project however, I am attempting to

Re: [sqlite] Problem with savepoints

2016-07-06 Thread Jeff Archer
On Wed, Jul 6, 2016 at 10:46 AM, Dan Kennedy wrote: > On 07/06/2016 09:09 PM, Jeff Archer wrote: > >> Hi All, >> I am a long time SQLite user but have generally used it from C++ in the >> past. In this project however, I am attempting to make a JDBC wrapper and >> use

Re: [sqlite] Problem with savepoints

2016-07-06 Thread Dan Kennedy
On 07/06/2016 09:09 PM, Jeff Archer wrote: Hi All, I am a long time SQLite user but have generally used it from C++ in the past. In this project however, I am attempting to make a JDBC wrapper and use from Android a newer version of SQLite (3.12.2) than that provided by Android 4.2.2 (3.7.11).

Re: [sqlite] Problem with savepoints

2016-07-06 Thread Quan Yong Zhai
@mailinglists.sqlite.org> Subject: [sqlite] Problem with savepoints Hi All, I am a long time SQLite user but have generally used it from C++ in the past. In this project however, I am attempting to make a JDBC wrapper and use from Android a newer version of SQLite (3.12.2) than that provided b

Re: [sqlite] Problem with savepoints

2016-07-06 Thread Quan Yong Zhai
PRAGMA JOURNAL_MODE=MEMORY Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 From: Jeff Archer<mailto:jeffarch...@gmail.com> Sent: 2016年7月6日 22:10 To: sqlite-users@mailinglists.sqlite.org<mailto:sqlite-users@mailinglists.sqlite.org> Subject

[sqlite] Problem with savepoints

2016-07-06 Thread Jeff Archer
Hi All, I am a long time SQLite user but have generally used it from C++ in the past. In this project however, I am attempting to make a JDBC wrapper and use from Android a newer version of SQLite (3.12.2) than that provided by Android 4.2.2 (3.7.11). Basically, what I have is SQLite compiled