Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

Firebird users and connection pool

 Post Reply Post Reply
Author
Caliari Arnaldo View Drop Down
New Member
New Member
Avatar

Joined: 25 Jul 2015
Posts: 23
Post Options Post Options   Quote Caliari Arnaldo Quote  Post ReplyReply Direct Link To This Post Topic: Firebird users and connection pool
    Posted: 25 Oct 2018 at 11:10am
Hi,

i'm trying to get evidence of what i think could be true, but i don't achieve my goal.

Suppose i have 100 different users registrated for a Firebird server / db. I don't want to use SYSDBA for the connection via TRemoteDb (i use Firedac adapter), so i connect via the registrated Firebird USERS.

The question is: the TRemoteDb pool acts in a way that User XXXX can reuse the connection already established by User YYYY ?

I'm trying to make tests to have evidence that the answer is "YES" (as i suppose), but until now i can't reproduce that reuse of a db connection. But, i'm not sure that this can signify that there is NO reuse for different Firebird Users, maybe i'm only making the wrong tests.

So... someone already has a definitive answer ?

Thank, Ciao !

Arnaldo


Back to Top
Wagner R. Landgraf View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 2429
Post Options Post Options   Quote Wagner R. Landgraf Quote  Post ReplyReply Direct Link To This Post Posted: 25 Oct 2018 at 2:53pm
Answer is NO. But there are plans to make it a YES in future (probably with an option to turn it on/off).
What can happen is that user XXXX can use different connections, but those connections would not be shared with different clients.
Back to Top
Caliari Arnaldo View Drop Down
New Member
New Member
Avatar

Joined: 25 Jul 2015
Posts: 23
Post Options Post Options   Quote Caliari Arnaldo Quote  Post ReplyReply Direct Link To This Post Posted: 25 Oct 2018 at 3:10pm
Thank you Wagner, you have made my day !!

We had built an internal utility that create triggers in db. These triggers logs every insert/update/delete for every field of every record. Because of your "NO", in log table we can store also the CURRENT_USER value of Firebird database, that is the user that made the insert / update / delete operation. Also the GDPR guys are now happy !

Thanks, ciao !

Arnaldo

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down