Devart Forums

Delphi 10.4.1
Windows 10 x64
APP build winx32

After upgrade my programm ruins at all..
MultipleConnections - what i it? How does i works?
I deleted all uniconnection from all threads, but programm still says that connection exceeded O_O
Uniquery ExecSQL make an error , Again ""Unexpected server response"" ...

Downgraded to 8.3.2 .course of stable work...
P.S. lost 3 hours of life to delete\restore creation of instances in a threads...

Workable programm at 8.3.2

main thread
PostgreSQLUniProvider1: TPostgreSQLUniProvider;
UniConnection1: TUniConnection;
AliveQuery: TUniQuery;
UniTransaction1: TUniTransaction;
Q_dailynum: TUniQuery;

in all other threads

function funcname: String;
var
PG_con:TUniConnection;
PG_trans:TUniTransaction;
////PG_SQL:TPostgreSQLUniProvider;
Q_sql:TUniQuery;
temp_MS:TStringStream;
mime_enc:TIdEncoderMIME;
mime_dec:TIdDecoderMIME;
a:integer;
SQL_rest_refresh_tables,start_time,SQL_time:string;
begin
ErrorCode:=0;
ErrorDesc:='';
{ TODO : Implement method echoDouble }
////PG_SQL:=TPostgreSQLUniProvider.Create(nil);
PG_con:=TUniConnection.Create(nil);
PG_trans:=TUniTransaction.Create(nil);
Q_sql:=TUniQuery.Create(nil);
PG_con.ProviderName:='PostgreSQL';
PG_con.DefaultTransaction:=PG_trans;
Q_sql.Connection:=PG_con;
Q_sql.Transaction:=PG_trans;
mime_enc:=TIdEncoderMIME.Create(nil);
mime_dec:=TIdDecoderMIME.Create(nil);
//INFO

PG_con.Server:=SERVER;
PG_con.Port:=strtoint(PORT);
PG_con.Database:=DATABASE;
PG_con.Username:=USERNAME;
PG_con.Password:=PASSWORD;

try

except
on E:Exception do
begin
ErrorCode:=1;
ErrorDesc:=E.ClassName+' : '+E.Message;
end;
end;
PG_con.Free;
Q_sql.Free;
PG_trans.Free;
////PG_SQL.Free;
temp_MS.Free;
mime_enc.Free;
mime_dec.Free;

end;

WHAT do i need to change for working with 8.4.1 version?!!

When support doesn't answer on Email and post on a forum...

May be it's really would be better to use firedac?!

Товарищи из русской поддержки.. Обращаюсь первый раз за 4 года регистрации.. версия 8.4 для postgreSQL - реально глючная !
Нам бы , пользователям , хоть какой ответ получить....
З.Ы. Зарегистрированный пользователь с 2013 года.... (Registered user from 2013 year...)

We also have issues with MultipleConnections enabled.

- application runs very slow
- problems with accessing temporary tables

Why is such a property enabled by default? Do you have automatic tests?

I made a demo to show that at 8.3.2 programm works well except 1-2 times, when limit of users are exceeded
at 8.4.2 - it fails even to start normally...

i send same file to email...

ftp://techrk.ru/techrk/FILES/DEMO/DEVART_841.zip

We have the same problem, back to 8.32 everything is fine

Same Problem here. Major Issue for us with 8.4.1

Hello,
We implemented multithreading in PgDAC (and in the PostgreSQL provider un UniDAC ) after many requests from our users. After introducing such sigfinicant changes to the architecture of components, we run thousands of autotests, however, it's not possible to cover 100% of code with autotests, and some bugs might be found after the release.
We're investigating the issue. We'll fix it as soon as possible. We'll keep you updated on the progress.

wbr, Oleg
Devart Team

Thx...

If it's possible, add function
SavetoJSON (or SavetoCSV) to TUniQuery
and
LoadFromJSON (or LoadFromCSV) to TVirtualTable

because in XML ,when i transfer 20 mb dataset, it's size can be overloaded over 80 mb by XML additional strings...)

We will consider the possibility of implementing the functionality that interests you in the next version of our product.
You can leave your suggestions at our UserVoice page (http://devart.uservoice.com/forums/1046 ... 939-unidac), and if there are many votes for your suggestion, we will implement it.

Hello,
These issues have been fixed. We're planning to release a new build this week. If you urgently need the fix, please send us your UniDAC license number and IDE version through the form https://devart.com/company/contactform.html and we'll send you the download link for the nightly build.

wbr, Oleg
Devart Team

Great!
So that means ... today or tomorrow, right?

Cheers,
James

Thanks ! I'll wait for a global update .

Hi,
Thanks for contacting us!

Kindly note, that currently available version is 9.2, which you can download via the following link: https://www.devart.com/unidac/download.html