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;
			
									
									
						sqlite enable connection pool error
Re: sqlite enable connection pool error
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
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
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
			
									
									
						https://www.devart.com/unidac/revision_history.html