Original Message:
Sent: 05-03-2023 02:29
From: Daniel Iseli
Subject: Sql Lite Locking
The described behavior is as documented. For details see:
Enabling the "Write-Ahead Log" (WAL) option in the database should solve the mentioned locking problem.
I hope this clarifies this matter.
------------------------------
Daniel Iseli
Principal Technical Support Engineer
Uniface Services
Rocket Software, Switzerland
Original Message:
Sent: 04-28-2023 03:28
From: Osman Shariff
Subject: Sql Lite Locking
Hi Gianni
Sqllite does work with multi ide sessions and a gui like sqlite studio. So, it can open multi sessions. Soliddb had no problems either.
It just seems that the uniface connector has a problem if one wants to open a path to the sqlite database. If i read data from an sqlite connection, the ide is blocked.
@Daniel is there a hidden option or can we add it to the wish list.
------------------------------
Osman Shariff
Original Message:
Sent: 04-25-2023 06:34
From: Gianni Sandigliano
Subject: Sql Lite Locking
Hi Osman,
from locking perspective 2 sessions on same node/machine are acting like 2 users.
Regards,
Gianni
------------------------------
Gianni Sandigliano
IT
Original Message:
Sent: 04-25-2023 03:26
From: Osman Shariff
Subject: Sql Lite Locking
Hi Gianni,
I am using it as a single user but with 2 sessions (1 ide, 1 runtime that accesses the sqlite DICT).
For now, this seems to solve it, but I doubt 2 ide sessions would work without locking.
sql/data sSql, "DEF"
nList = $result
sql "commit", "DEF"
------------------------------
Osman Shariff
Original Message:
Sent: 04-25-2023 02:55
From: Gianni Sandigliano
Subject: Sql Lite Locking
Hi Osman,
AFAIK SQLLite is one of those "black box" database aiming to WriteOneReadMany scenarios; it is NOT a valid choice for a multiuser environment.
Best Regards,
Gianni
------------------------------
Gianni Sandigliano
IT
Original Message:
Sent: 04-13-2023 05:46
From: Osman Shariff
Subject: Sql Lite Locking
I am having the issue that SQLite puts a lock on the table if I do a select statement and then the lock is not released.
I can release the lock by doing an sql "commit", or leaving the application.
USYS$SLE_PARAMS options for wal and locking are not set
Is this normal behaviour?
Example
sql "select 1 from uform", "def"
;;; wait 30 minutes
;;;; table is locked
sql "commit", "def"
;;; lock is removed
------------------------------
Osman Shariff
------------------------------