Zeoslib doesn't release the Database file after disconnect.

Forum related to SQLite

Moderators: gto, cipto_kh, EgonHugeist

zeoslibuser
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 10.11.2014, 20:44

Zeoslib doesn't release the Database file after disconnect.

Postby zeoslibuser » 10.11.2014, 21:04

I don't understand what is going on. I thought that when you connected to the database dummy.db file through TZConnection tool, you always stayed connected until you disconnected from it. However, no matter what I do once I connect to a database file, it remains connected even though I call disconnect procedure of TZConnection. Thus, it never releases the database file dummy.db until I shutdown the program. Am I missing something? :nurse: :doc:

ZConnection1.Database := 'dummy.db';
ZConnection1.Protocol := 'SQLite-3';
ZConnection1.Connect;

Query1.SQL.TEXT := 'SELECT * FROM test'; (Query1 connection is ZConnection1)
Query1.ExeSQL;

ZConnection1.Disconnect;

But disconnect never releases the dummy.db file. I need to be able to do that for my program... Any hints or clues will be greatly appreciated. Thanks.

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Re: Zeoslib doesn't release the Database file after disconne

Postby EgonHugeist » 11.11.2014, 12:39

Hi,

yes this WAS true. Which version of Zeos are you using for?

Note this issue should be fixed in 7.1.4 or better 7.2-Beta
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

zeoslibuser
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 10.11.2014, 20:44

Re: Zeoslib doesn't release the Database file after disconne

Postby zeoslibuser » 11.11.2014, 14:37

Hello, Thank you for your reply.

I am using 7.1.2 STABLE release.

Is there a latest version that works?

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Re: Zeoslib doesn't release the Database file after disconne

Postby EgonHugeist » 18.11.2014, 22:20

Of yourse! As i wrote: 7.1.4-stable and (prefered) 7.2-Beta
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image


Return to “SQLite”

Who is online

Users browsing this forum: No registered users and 1 guest