Hi All,
1. prepare, step, then finalize: Attach DATABASE '/full/path' as
'my_in_memory_db';
2. prepare, step, then finalize: Delete from my_in_memory_db.table_1
where primary_key = 'value';
3. prepare, step, then finalize: DETACH my_in_memory_db;
Executed above three queries in loop for 1
Please turn on error logging (http://www.sqlite.org/errlog.html) and report
back what error messages you are seeing.
On Thu, Apr 17, 2014 at 6:47 AM, dd wrote:
> Hi All,
>
> 1. prepare, step, then finalize: Attach DATABASE '/full/path' as
> 'my_in_memory_db';
> 2. prepare, step, then finali
Dear Richard,
This is great api.
output:
(1) statement aborts at 5: [DETACH my_in_memory_db;] database
my_in_memory_db is locked
(1) statement aborts at 5: [ATTACH DATABASE '/full/path/info.db' AS
my_in_memory_db;] database my_in_memory_db is
already in use
(1) statement aborts at 5: [
On Thu, Apr 17, 2014 at 9:08 AM, dd wrote:
> Dear Richard,
>
> This is great api.
>
> output:
>
> (1) statement aborts at 5: [DETACH my_in_memory_db;] database
> my_in_memory_db is locked
>
The DETACH failed because you have unfinalized statements using the
attached database and you cannot
Given different database name for in-memory database for every
iteration(looped for 1000 times). Still, it's throwing Database Locked at
least once on Windows, not on Mac/Linux. Is there any way to track this
issue? I am using 3.7.11. Any ideas?
On Thu, Apr 17, 2014 at 5:11 PM, Richard Hipp wrot
On 20 Apr 2014, at 12:58pm, dd wrote:
> Given different database name for in-memory database for every
> iteration(looped for 1000 times). Still, it's throwing Database Locked at
> least once on Windows, not on Mac/Linux. Is there any way to track this
> issue? I am using 3.7.11. Any ideas?
Tec
I have set busy time out for 5 seconds and given different names for every
attach and detaching database. still, this error is not getting fixed.
prepare, step and finalize are not throwing any errors.
What is the alternative solution for attach and detaching database? Thanks
in advance.
On Sun,
7 matches
Mail list logo