Page 1 of 1

sqlite enable connection pool error

Posted: Fri 13 Dec 2019 16:54
by Wilson Alex
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;

Re: sqlite enable connection pool error

Posted: Tue 17 Dec 2019 15:36
by MaximG
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

Re: sqlite enable connection pool error

Posted: Wed 18 Dec 2019 10:06
by Wilson Alex
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.

Re: sqlite enable connection pool error

Posted: Thu 12 Mar 2020 14:36
by MaximG
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