Search found 18 matches

by DPStano
11.04.2018, 13:42
Forum: ZeosLib 7.3 Forum
Topic: [Request] FB auto commit
Replies: 4
Views: 96

Re: [Request] FB auto commit

thx for response, i'll recheck it ... probably we are still on 7.1, sorry for bothering :)
by DPStano
05.04.2018, 08:02
Forum: ZeosLib 7.3 Forum
Topic: [Request] FB auto commit
Replies: 4
Views: 96

[Request] FB auto commit

pls could you consider to change implementation of FB's auto commit to use isc_tpb_autocommit in 7.3
by DPStano
31.08.2017, 10:06
Forum: Firebird
Topic: Users list of server
Replies: 2
Views: 237

Re: Users list of server

use isc_info_svc_get_users look at https://github.com/graemeg/firebird-lib ... ervice.pas procedure ViewUser AGroupId
by DPStano
12.08.2017, 14:07
Forum: ZeosLib 7.2 Forum
Topic: Zeos with Firebird 3 does not receive the updates of the records.
Replies: 2
Views: 198

Re: Zeos with Firebird 3 does not receive the updates of the records.

There i no such feature in Firebird and similar DBs (Mysql, Postgres) if you need auto updated records in real time you should look at googles firebase or RethinkDB or implement some callback mechaninsm by yourself like Trigered Events or periodically chcecking for changes in some loop
by DPStano
26.07.2017, 13:49
Forum: ZeosLib 7.2 Forum
Topic: [Q] how to find out if IZResultSet is empty
Replies: 1
Views: 116

[Q] how to find out if IZResultSet is empty

i'm really sorry but cant find proper forum to post that question, is there any way how to find out if IZResultSet is empty without trying to itterate it?
by DPStano
26.07.2017, 09:26
Forum: ZeosLib 7.2 Forum
Topic: EStringListError inside ConstructURL
Replies: 6
Views: 289

Re: EStringListError inside ConstructURL

i'll let my implementation here, really do not know if it's absolutely correct but i do not have reported errors so far

https://gist.github.com/Sorien/fda8c65c ... e4dc7fd7b4

TLock just encapsulate TRTLCriticalSection
by DPStano
16.06.2017, 12:42
Forum: ZeosLib 7.2 Forum
Topic: EStringListError inside ConstructURL
Replies: 6
Views: 289

Re: EStringListError inside ConstructURL

TZDriverManager as global object has to be threadsafe so all access to its private members has to be locked by some Lock TCriticalSection or some Mutex i'd remove private FURL and add it as var in ConstructURL, ResolveDatabaseUrl, ResolveDatabaseUrl FDrivers should not change during program runtime ...
by DPStano
16.05.2017, 11:20
Forum: ZeosLib 7.2 Forum
Topic: EStringListError inside ConstructURL
Replies: 6
Views: 289

Re: EStringListError inside ConstructURL

it caused by calling Connect in thread maybe DriverManager should be protected by mutex or FURL should be method var or something like that
by DPStano
16.05.2017, 07:28
Forum: ZeosLib 7.2 Forum
Topic: Wrong logging statements order, missing unprepare
Replies: 5
Views: 207

Re: Wrong logging statements order, missing unprepare

commit logged before execute prepared statement commit is logged at https://github.com/svn2github/ZeosLib/blob/6955acfe78e46bc0b7752b602fdcf7b6560750f7/trunk/src/dbc/ZDbcInterbase6Statement.pas#L367 but execute prepared is logged two lines after https://github.com/svn2github/ZeosLib/blob/6955acfe78e...
by DPStano
16.05.2017, 07:24
Forum: ZeosLib 7.2 Forum
Topic: Wrong logging statements order, missing unprepare
Replies: 5
Views: 207

Re: Wrong logging statements order, missing unprepare

when it comes unprepare statement prepare statement is loged as https://github.com/svn2github/ZeosLib/blob/6955acfe78e46bc0b7752b602fdcf7b6560750f7/trunk/src/dbc/ZDbcStatement.pas#L2243 but when you look at unprepare its not loged at all https://github.com/svn2github/ZeosLib/blob/6955acfe78e46bc0b77...
by DPStano
16.05.2017, 07:17
Forum: ZeosLib 7.2 Forum
Topic: Wrong logging statements order, missing unprepare
Replies: 5
Views: 207

Re: Wrong logging statements order, missing unprepare

i forgot DB is firebird with 10+ active connections so i have 10 active transactions with 100 query/min, error queries are logged but is't a bit problematic to find out transactions when some db deadlock/error happen or even filter queries by connection when multiple similar queries are logged at sa...
by DPStano
10.05.2017, 08:54
Forum: ZeosLib 7.2 Forum
Topic: Wrong logging statements order, missing unprepare
Replies: 5
Views: 207

Wrong logging statements order, missing unprepare

Transaction Commit is logged before Execute Statement and Unprepare Statement is not logged at all and there should be transaction handle/id for each statements ... its really weird when i have 10 connections and can't identify which transaction run which query
by DPStano
10.05.2017, 08:02
Forum: ZeosLib 7.2 Forum
Topic: EStringListError inside ConstructURL
Replies: 6
Views: 289

EStringListError inside ConstructURL

I'm getting this error callstack from multiple users anyone have idea whats wrong, connect is called in thread, each thread has own connection Delphi 2009 EStringListError: List index out of bounds (1) Classes: 0 TStringList.Get Classes: 0 TStrings.Error Classes: 0 TStringList.Get Classes: 0 TString...
by DPStano
09.11.2016, 11:28
Forum: Off Topic
Topic: GitHub
Replies: 1
Views: 690

GitHub

Any plans move project to GitHub ppl could more easily report bugs and contribute
by DPStano
18.10.2016, 13:05
Forum: ZeosLib 7.2 Forum
Topic: [Q] Connection lost during post
Replies: 1
Views: 176

[Q] Connection lost during post

just want to to know how to properly handle that situation when there is connection error during applyupdates call, I thought that i can catch error reconnect and apply updates again but reconnect will close all datasets Edit: I can create helper to prevent dataset closing procedure TZConnectionHelp...

Go to advanced search