Re: [sqlite] Database locking issue

2008-09-28 Thread Lothar Behrens 
Hi,

now I have tried the actual version 3.6.3 as of sqlite- 
amalgamation-3.6.3.tgz, but still get database locks I cannot explain.

Brief information:

I use two database files. One (lbDMF.db3) for system informations such  
as what my application should show in forms
of a database (Template Designer.db3).

The system database therefore is required to store sql queries of the  
application database (Template Designer.db3).

Looking at the files after I have the lock situation (after a  
successfull close I also get a lock when reopened) I have determined
content in Template Designer.db3-journal that shows words (of columns  
or tables from lbDMF.db3.

How could it be, that there is content in that file that fas nothing  
to do with that database ?

Here is the content:

Ÿ’˘ °c◊öÃts/CPP/Test/GUI/wxWrapper/Template  
Designer 
.db3 
 
 
ö 
 
Ö 
 
V 
 
8 
 
 
 
¸ 
 
› 
æ 
 
ü 
 
Å 
 
c 
 
E 
 
. 
 
 
 
 
‡ 
¿ 
†åxdJ0ÚŒ™ãlM"3IdAnwendungsparameter! 
3idAnwendungsparameter  
 
 
 
3 
 
 
 
IDAnwendungsparameter 
 
" 
 
 
 
= 
 
 
 
IdFormularaktionenzuordnen 
 
" 
 
 
 
= 
 
 
 
idFormularaktionenzuordnen 
 
" 
 
 
 
= 
 
 
 
IDFormularaktionenzuordnen 
 
 
 
 
 
 
) 
 
 
IdUebersetzungen 
 
 
 
 
 
 
) 
 
 
idUebersetzungen 
 
 
 
 
 
 
) 
 
 
IDUebersetzungen 
 
 
 
 
 
 
 
 
 
 
IdAktionen 
 
 
 
 
 
 
 
 
 
idAktionenIDAktionen5IdAnwendungenFormulare
úÏÿƒ∞ú 
LiliLiliLiliLuluLuluLuluLoloLoloLoloLalaLalaLalaTestTestTestöÃ

The words Anwendungsparameter, Formularaktionenzuordnen,  
Uebersetzungen, Aktionen and AnwendungenFormulare are columns or  
tables from lbDMF.

I am confused !!

Also I could rename these files while the application claims they are  
locked.
(This happens while an update attempt I'll give a retry with a shortly  
closed database to get rid of the lock, but the lock remains)

Any hints are welcome.

Thanks,

Lothar

Am 19.09.2008 um 17:37 schrieb Lothar Behrens:

>
> Am 19.09.2008 um 17:03 schrieb Ken:
>
>> Try it with the latest full build say version 3.6.2 and see what
>> happens instead of a "patched"
>>
>
> I'll give that a try. Could the current code be compiled with Open
> Watcom as A DLL ?
> (I haven't seen these __declspec(dllexport) and the opposite stuff in
> the actual code)
>
> Lothar
>
>>
>
> -- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de
> Lothar Behrens
> Heinrich-Scheufelen-Platz 2
> 73252 Lenningen
>
>
>
>
>
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>

-- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de
Lothar Behrens
Heinrich-Scheufelen-Platz 2
73252 Lenningen








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

Re: [sqlite] Database locking issue

2008-09-19 Thread Lothar Behrens 

Am 19.09.2008 um 17:03 schrieb Ken:

> Try it with the latest full build say version 3.6.2 and see what  
> happens instead of a "patched"
>

I'll give that a try. Could the current code be compiled with Open  
Watcom as A DLL ?
(I haven't seen these __declspec(dllexport) and the opposite stuff in  
the actual code)

Lothar

>

-- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de
Lothar Behrens
Heinrich-Scheufelen-Platz 2
73252 Lenningen








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

Re: [sqlite] Database locking issue

2008-09-19 Thread Ken 
Try it with the latest full build say version 3.6.2 and see what happens 
instead of a "patched" 



--- On Fri, 9/19/08, Lothar Behrens <[EMAIL PROTECTED]> wrote:
From: Lothar Behrens <[EMAIL PROTECTED]>
Subject: [sqlite] Database locking issue
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Date: Friday, September 19, 2008, 9:02 AM

Hi,

I am using  Version 3.5.2 of Sqlite with the changes of the following  
CVS checkin numbers: 4543 and 5243 to get the sqlite3_sql and  
sqlite3_next_stmt functions
into my API.

I have patched my files due to the need to figuring out what  
statements were unfinalized. But now I get 'database is locked' errors 

right after reopening the
database (the closing of the database works as I try to keep my  
statements open as short as possible thus closing now works).

Due to this new error ('database is locked') I added reporting  
statemens in use. The result of this is a report of the insert  
statement itself that causes the error for
this report.

So I am a little confused.

If a database is locked, is there always a statement that causes this  
lock, or is the lock keeping even the statement gets finalized ?

Or did I have to apply other patches related to them above ?

Thanks

Lothar

-- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de
Lothar Behrens
Heinrich-Scheufelen-Platz 2
73252 Lenningen








___
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

[sqlite] Database locking issue

2008-09-19 Thread Lothar Behrens 
Hi,

I am using  Version 3.5.2 of Sqlite with the changes of the following  
CVS checkin numbers: 4543 and 5243 to get the sqlite3_sql and  
sqlite3_next_stmt functions
into my API.

I have patched my files due to the need to figuring out what  
statements were unfinalized. But now I get 'database is locked' errors  
right after reopening the
database (the closing of the database works as I try to keep my  
statements open as short as possible thus closing now works).

Due to this new error ('database is locked') I added reporting  
statemens in use. The result of this is a report of the insert  
statement itself that causes the error for
this report.

So I am a little confused.

If a database is locked, is there always a statement that causes this  
lock, or is the lock keeping even the statement gets finalized ?

Or did I have to apply other patches related to them above ?

Thanks

Lothar

-- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de
Lothar Behrens
Heinrich-Scheufelen-Platz 2
73252 Lenningen








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