sqlite enable connection pool error

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Wilson Alex
Posts: 16
Joined: Fri 13 Dec 2019 16:39

sqlite enable connection pool error

Post by Wilson Alex » Fri 13 Dec 2019 16:54

Hello everyone, I just started to learn and use Delphi. When I use the latest UniDAC component (version 8.1.2) to access the SQLite database, as soon as I enable the connection pool, I will get an error: EAssertionFailed 1024 (D:\ProjectsClone1\Delphi\Dac\Common\Source\CRConnectionPool.pas, line 252).
I don’t know what the problem is, and someone can give me some suggestions? Or SQLite database using connection pool code? This is my code:
----------
procedure TForm1.btn1Click(Sender: TObject);
begin
LiteConn := nil;
try
LiteConn := TUniConnection.Create(nil);
try
with LiteConn do
begin
ProviderName := 'SQLite';
Database := 'dasdb.dat';
Pooling := True;
PoolingOptions.Validate := True;
PoolingOptions.MinPoolSize := 1;
PoolingOptions.MaxPoolSize := 50;
PoolingOptions.ConnectionLifetime := 20;
Options.DisconnectedMode := True;
Options.KeepDesignConnected := False;
SpecificOptions.Values['ForceCreateDatabase'] := 'False';
SpecificOptions.Values['ClientLibrary'] := '.\sqlite3.dll';
SpecificOptions.Values['BusyTimeout'] := '10';
Open;
end;
if LiteConn.Connected then
begin
mmo1.Lines.Append('Connected');
LiteConn.Close;
end;
except
on Ex: Exception do
begin
mmo1.Lines.Append(Ex.ClassName + ' ' + Ex.Message);
Exit;
end;
end;
finally
LiteConn.Free;
end;
end;

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: sqlite enable connection pool error

Post by MaximG » Tue 17 Dec 2019 15:36

We've reproduced the issue and fixed it. The fix will be included in the next build of our product. As a workaround, we can send you a night UniDAC build including the required changes. For this provide us with your license number and IDE version you are interested in For your convenience, please use the e-support form https://www.devart.com/company/contactform.html

Wilson Alex
Posts: 16
Joined: Fri 13 Dec 2019 16:39

Re: sqlite enable connection pool error

Post by Wilson Alex » Wed 18 Dec 2019 10:06

Thank you MaximG, I have submitted this question through the electronic support form, and I want to know when the next version will be officially released.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: sqlite enable connection pool error

Post by MaximG » Thu 12 Mar 2020 14:36

We've released a new build of our product, which includes the fix for that issue. See the release notes at
https://www.devart.com/unidac/revision_history.html

Post Reply