Search found 10 matches

by ribut
18.04.2017, 20:22
Forum: PostgreSQL
Topic: commands ignored until end of transaction block
Replies: 12
Views: 938

Re: commands ignored until end of transaction block

Furthermore, whether if there are two concurrent processes startransactions, when one commit command executed if both of the startransactions same time will affect the commit command of one of the execution of TZQuery or TZReadonlyQuery it I will try your suggestion, and it looks better if you use y...
by ribut
10.04.2017, 08:48
Forum: PostgreSQL
Topic: commands ignored until end of transaction block
Replies: 12
Views: 938

Re: commands ignored until end of transaction block

Hello ribut, Please don't do that: with qryIUD do begin Close; SQL.Clear; SQL.Add('BEGIN;'); ExecSQL; end; The ZConnection Object has the methods StartTransaction, Commit and Rollback. Please use them because Zeos handles some things internally through them. With best regards, Jan why i don't do th...
by ribut
06.04.2017, 17:27
Forum: PostgreSQL
Topic: commands ignored until end of transaction block
Replies: 12
Views: 938

Re: commands ignored until end of transaction block

miab3 wrote:@ribut

Could you try with autocommit disabled:

ZConnection1.AutoCommit:=False;

Michal


ok, problem solved

many thank's Michal
by ribut
06.04.2017, 10:58
Forum: PostgreSQL
Topic: commands ignored until end of transaction block
Replies: 12
Views: 938

Re: commands ignored until end of transaction block

function CheckPostgreSQLError(const Connection: IZConnection; const PlainDriver: IZPostgreSQLPlainDriver; const Handle: PZPostgreSQLConnect; const LogCategory: TZLoggingCategory; const LogMessage: RawByteString; const ResultHandle: PZPostgreSQLResult): String; var ErrorMessage: RawbyteString; //Fir...
by ribut
04.04.2017, 19:09
Forum: PostgreSQL
Topic: commands ignored until end of transaction block
Replies: 12
Views: 938

Re: commands ignored until end of transaction block

IMO : case 2 procedure TForm1.FormShow(Sender: TObject); begin //case 2 //using : zeoslib-code-0-3986-branches-testing-7.2 //create database tes1; //create database //create table tabel_2(id integer primary key,first_name varchar(50),salary numeric(8,2)); with ZConnection1 do begin Database:='tes1';...
by ribut
04.04.2017, 17:15
Forum: PostgreSQL
Topic: commands ignored until end of transaction block
Replies: 12
Views: 938

Re: commands ignored until end of transaction block

Hello ribut, i cannot debug the probelm without knowing what your code does when that exception ist thrown. Usually that exception will not be thrown at rollback but at some other place. With best regards, Jan thanks Jan for your replay this code using zeoslib-code-0-3986-branches-testing-7.2 case ...
by ribut
04.04.2017, 07:37
Forum: PostgreSQL
Topic: commands ignored until end of transaction block
Replies: 12
Views: 938

Re: commands ignored until end of transaction block

Hello ribut, the higly interesting question is what you try to do after the original exception in PostgreSQL has ben triggered and before you try to rollback the changes. Usually this bug was related to Zeos trying to unprepare statements in a transaction that had an exception beforehand. Could you...
by ribut
02.04.2017, 06:49
Forum: 6.6 - stable
Topic: Getting out of transaction if exception occurred
Replies: 5
Views: 586

Re: Getting out of transaction if exception occurred

When I use zeoslib-7.2-r3929-testing together with the PostgreSQL database when using the code block try   BEGIN except ROLLBACK   end; COMMIT rollback implemented and no problems error When I use zeoslib-7.2-r3986-testing try   BEGIN except ROLLBACK   end; COMMIT I get an error: commands ignored un...
by ribut
02.04.2017, 06:32
Forum: PostgreSQL
Topic: commands ignored until end of transaction block
Replies: 12
Views: 938

commands ignored until end of transaction block

When I use zeoslib-7.2-r3929-testing together with the PostgreSQL database when using the code block try   BEGIN except ROLLBACK   end; COMMIT rollback implemented and no problems error When I use zeoslib-7.2-r3986-testing try   BEGIN except ROLLBACK   end; COMMIT I get an error: commands ignored un...
by ribut
02.04.2017, 06:30
Forum: ZeosLib 7.2 Betatest Forum
Topic: commands ignored until end of transaction block
Replies: 1
Views: 114

commands ignored until end of transaction block

When I use zeoslib-7.2-r3929-testing together with the PostgreSQL database when using the code block try   BEGIN except ROLLBACK   end; COMMIT rollback implemented and no problems error When I use zeoslib-7.2-r3986-testing try   BEGIN except ROLLBACK   end; COMMIT I get an error: commands ignored un...

Go to advanced search