Re: [Firebird-devel] FBJava plugin issues

2018-05-21 Thread Leyne, Sean
> > Hello Mark, > > > > Here it is what we did in details: > > > > 1) Install plugin into C:\Firebird_Java\fbjava-1.0.0-alpha-1. > > I advice to prefer use the version of master instead of alpha-1. > > Yes, it's not released as binary yet, but important fixes and many changes has > done since

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-21 Thread Vlad Khorsun via Firebird-devel
21.05.2018 14:58, Rashid Abzalov wrote: 21.05.2018 14:42, Vlad Khorsun via Firebird-devel wrote:    I don't see how persistent connections in Postgres could be reused by different user sessions. No, in Postgres you can reuse only your own connections. You see - all approaches have its

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-21 Thread Rashid Abzalov
21.05.2018 14:42, Vlad Khorsun via Firebird-devel пишет:   I don't see how persistent connections in Postgres could be reused by different user sessions. No, in Postgres you can reuse only your own connections. Nevertheless, it seems to me that this approach also solves the original task

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-21 Thread Vlad Khorsun via Firebird-devel
21.05.2018 14:25, Rashid Abzalov wrote: Instead of implementing a pool of connections that the system implicitly manages, it might be better to implement named connections as it is done in Postgres (https://www.postgresql.org/docs/current/static/contrib-dblink-function.html)? Which the user

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-21 Thread Rashid Abzalov
Instead of implementing a pool of connections that the system implicitly manages, it might be better to implement named connections as it is done in Postgres (https://www.postgresql.org/docs/current/static/contrib-dblink-function.html)? Which the user manages and re-uses as he needs - he knows

[Firebird-devel] [FB-Tracker] Created: (CORE-5832) Implement way to reset user session environment to its initial (default) state

2018-05-21 Thread Vlad Khorsun (JIRA)
Implement way to reset user session environment to its initial (default) state -- Key: CORE-5832 URL: http://tracker.firebirdsql.org/browse/CORE-5832 Project: Firebird Core

[Firebird-devel] [FB-Tracker] Created: (CORE-5831) Not user friendly output of gstat at encrypted database

2018-05-21 Thread Vlad Khorsun (JIRA)
Not user friendly output of gstat at encrypted database --- Key: CORE-5831 URL: http://tracker.firebirdsql.org/browse/CORE-5831 Project: Firebird Core Issue Type: Bug Components:

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-21 Thread Vlad Khorsun via Firebird-devel
21.05.2018 11:47, Dimitry Sibiryakov wrote: 21.05.2018 10:13, Mark Rotteveel wrote:   if pool contain connection to database 1 and user try to connect to also database 1 he can use pool instead normal connection. That wouldn't really work   Yes, that wouldn't work. But generally speaking

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-21 Thread Dimitry Sibiryakov
21.05.2018 10:13, Mark Rotteveel wrote:   if pool contain connection to database 1 and user try to connect to also database 1 he can use pool instead normal connection. That wouldn't really work Yes, that wouldn't work. But generally speaking pools in Y-valve could be potentially a

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-21 Thread Mark Rotteveel
On 20-5-2018 17:24, Vlad Khorsun via Firebird-devel wrote: 20.05.2018 14:15, Mark Rotteveel wrote: I would expect such a feature to reset all session state to the initial state on connect, including things like * Clear context USER_SESSION * Reset role to the initial role specified on attach