Upgrade 8.3.2 >> 8.4.1

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
vampirekb
Posts: 9
Joined: Mon 20 Oct 2014 19:30

Upgrade 8.3.2 >> 8.4.1

Post by vampirekb » Tue 02 Mar 2021 23:44

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?!!

vampirekb
Posts: 9
Joined: Mon 20 Oct 2014 19:30

Re: Upgrade 8.3.2 >> 8.4.1

Post by vampirekb » Thu 04 Mar 2021 07:00

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...)

bursch
Posts: 20
Joined: Tue 25 Sep 2018 07:45

Re: Upgrade 8.3.2 >> 8.4.1

Post by bursch » Thu 04 Mar 2021 14:45

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?

vampirekb
Posts: 9
Joined: Mon 20 Oct 2014 19:30

Re: Upgrade 8.3.2 >> 8.4.1

Post by vampirekb » Fri 05 Mar 2021 08:23

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

Uli65
Posts: 12
Joined: Wed 22 Feb 2012 10:11

Re: Upgrade 8.3.2 >> 8.4.1

Post by Uli65 » Fri 05 Mar 2021 08:50

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

rtttt
Posts: 2
Joined: Fri 03 Apr 2020 15:01

Re: Upgrade 8.3.2 >> 8.4.1

Post by rtttt » Fri 05 Mar 2021 10:13

Same Problem here. Major Issue for us with 8.4.1

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: Upgrade 8.3.2 >> 8.4.1

Post by oleg0k » Tue 09 Mar 2021 09:13

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

vampirekb
Posts: 9
Joined: Mon 20 Oct 2014 19:30

Re: Upgrade 8.3.2 >> 8.4.1

Post by vampirekb » Tue 09 Mar 2021 10:37

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...)

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

Re: Upgrade 8.3.2 >> 8.4.1

Post by MaximG » Tue 16 Mar 2021 11:06

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.

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: Upgrade 8.3.2 >> 8.4.1

Post by oleg0k » Wed 24 Mar 2021 15:33

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

JamesInform
Posts: 19
Joined: Sun 11 May 2014 18:28

Re: Upgrade 8.3.2 >> 8.4.1

Post by JamesInform » Thu 25 Mar 2021 10:53

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

Cheers,
James

vampirekb
Posts: 9
Joined: Mon 20 Oct 2014 19:30

Re: Upgrade 8.3.2 >> 8.4.1

Post by vampirekb » Fri 26 Mar 2021 16:51

Thanks ! I'll wait for a global update .

evgeniym
Devart Team
Posts: 103
Joined: Thu 13 May 2021 07:08

Re: Upgrade 8.3.2 >> 8.4.1

Post by evgeniym » Tue 23 Aug 2022 05:21

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

Post Reply