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

2018-05-20 Thread Dimitry Sibiryakov
19.05.2018 18:44, Vlad Khorsun via Firebird-devel wrote:   Nothing special was done in this area - GTT contents will be preserved. The same for context variables.   So, we have a question - should we clear session-level state when connection become unused (or when it about to be re-used) ?

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

2018-05-20 Thread Mark Rotteveel
On 19-5-2018 17:11, Vlad Khorsun via Firebird-devel wrote: 19.05.2018 13:08, Mark Rotteveel wrote: 2. Fine-grained privilege that applies only to this single option: ALTER_EXTERNAL_CONNECTIONS_POOL or if shorter is preferred: ALTER_EXT_CONN_POOL 3. In addition to option 2, maybe allow even fi

Re: [Firebird-devel] FBJava plugin issues

2018-05-20 Thread Mark Rotteveel
On 18-5-2018 20:59, Chmakov, Vladimir wrote: Hello Mark, Here it is what we did in details: 1) Install plugin into C:\Firebird_Java\fbjava-1.0.0-alpha-1. 2) Create Environment Variable FBJAVA_ROOT= C:\Firebird_Java\fbjava-1.0.0-alpha-1 3) CD to C:\Firebird_Java\fbjava-1.0.0-alpha-1\examples\fb

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

2018-05-20 Thread Vlad Khorsun via Firebird-devel
20.05.2018 12:55, Mark Rotteveel wrote: On 19-5-2018 17:11, Vlad Khorsun via Firebird-devel wrote: 19.05.2018 13:08, Mark Rotteveel wrote: 2. Fine-grained privilege that applies only to this single option: ALTER_EXTERNAL_CONNECTIONS_POOL or if shorter is preferred: ALTER_EXT_CONN_POOL 3. In a

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

2018-05-20 Thread Vlad Khorsun via Firebird-devel
20.05.2018 12:38, Dimitry Sibiryakov wrote: 19.05.2018 18:44, Vlad Khorsun via Firebird-devel wrote:    Nothing special was done in this area - GTT contents will be preserved. The same for context variables.    So, we have a question - should we clear session-level state when connection become

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

2018-05-20 Thread Mark Rotteveel
On 20-5-2018 12:47, Vlad Khorsun via Firebird-devel wrote: 20.05.2018 12:55, Mark Rotteveel wrote: On 19-5-2018 17:11, Vlad Khorsun via Firebird-devel wrote: 19.05.2018 13:08, Mark Rotteveel wrote: 2. Fine-grained privilege that applies only to this single option: ALTER_EXTERNAL_CONNECTIONS_PO

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

2018-05-20 Thread liviuslivius
Hi, can i ask why this is only for external connections? 2 databases. One user run execute statement on database 1 from 2 second on database 2 from 1. Third connect simply to database 1 why it can not benefit from pool? Regards,Karol Bieniaszewski null

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

2018-05-20 Thread Dimitry Sibiryakov
20.05.2018 13:00, Vlad Khorsun via Firebird-devel wrote:    I'd suggest to add to EDS an option to use "isolated" connection, which is guaranteed the connection to be new and after use to be deleted, not returned to pool.   Why one should need it ? If one don't want to use pool - just disable

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

2018-05-20 Thread Mark Rotteveel
On 20-5-2018 13:00, Vlad Khorsun via Firebird-devel wrote:   I plan to introduce new database object "EXTERNAL DATA SOURCE" since initial implementation of EXECUTE STATEMENT ON EXTERNAL, but I never have time\priority to implement it, unfortunately.   The question at this topic is: should we

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

2018-05-20 Thread Dimitry Sibiryakov
20.05.2018 13:11, liviuslivius wrote: can i ask why this is only for external connections? 2 databases. One user run execute statement on database 1 from 2 second on database 2 from 1. Third connect simply to database 1 why it can not benefit from pool? For achieving that the implementations

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

2018-05-20 Thread Mark Rotteveel
On 20-5-2018 13:11, liviuslivius wrote: Hi, can i ask why this is only for external connections? 2 databases. One user run execute statement on database 1 from 2 second on database 2 from 1. Third connect simply to database 1 why it can not benefit from pool? Do you mean a user establishing

Re: [Firebird-devel] Time zone feature documentation

2018-05-20 Thread Mark Rotteveel
On 11-5-2018 18:31, Adriano dos Santos Fernandes wrote: Hi! Here is the first README version for the time zone feature. https://github.com/FirebirdSQL/firebird/blob/work/time-zone-support/doc/sql.extensions/README.time_zone.md Will it be possible to set the session timezone on connect throug

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

2018-05-20 Thread Vlad Khorsun via Firebird-devel
20.05.2018 14:06, Mark Rotteveel wrote: On 20-5-2018 12:47, Vlad Khorsun via Firebird-devel wrote: 20.05.2018 12:55, Mark Rotteveel wrote: On 19-5-2018 17:11, Vlad Khorsun via Firebird-devel wrote: 19.05.2018 13:08, Mark Rotteveel wrote: 2. Fine-grained privilege that applies only to this sing

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

2018-05-20 Thread Mark Rotteveel
On 20-5-2018 14:01, Vlad Khorsun via Firebird-devel wrote:   Cause i needed a some way to manage pool at runtime, without server restart, and i saw no better\easy way to do it. If you offer some - it will be considered of course.   Pool management statements (even without persistence) allows

Re: [Firebird-devel] FBJava plugin issues

2018-05-20 Thread Adriano dos Santos Fernandes
On 18/05/2018 15:59, Chmakov, Vladimir wrote: > 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 man

Re: [Firebird-devel] Time zone feature documentation

2018-05-20 Thread Adriano dos Santos Fernandes
On 20/05/2018 08:25, Mark Rotteveel wrote: > On 11-5-2018 18:31, Adriano dos Santos Fernandes wrote: >> Hi! >> >> Here is the first README version for the time zone feature. >> >> https://github.com/FirebirdSQL/firebird/blob/work/time-zone-support/doc/sql.extensions/README.time_zone.md >> >> > > W

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

2018-05-20 Thread Adriano dos Santos Fernandes
On 20/05/2018 09:01, Vlad Khorsun via Firebird-devel wrote: > >   Cause i needed a some way to manage pool at runtime, without server > restart, Isn't (some parts of) the config file already reloaded sometimes (timeout)? Adriano -

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

2018-05-20 Thread Dimitry Sibiryakov
20.05.2018 16:25, Adriano dos Santos Fernandes wrote: Isn't (some parts of) the config file already reloaded sometimes (timeout)? Firebird.conf is reloaded when its timestamp changed. Plugins' configs are not reloaded. -- WBR, SD.

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

2018-05-20 Thread Vlad Khorsun via Firebird-devel
20.05.2018 14:13, Dimitry Sibiryakov пишет: 20.05.2018 13:00, Vlad Khorsun via Firebird-devel wrote:    I'd suggest to add to EDS an option to use "isolated" connection, which is guaranteed the connection to be new and after use to be deleted, not returned to pool.    Why one should need it ?

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

2018-05-20 Thread Vlad Khorsun via Firebird-devel
20.05.2018 14:15, Mark Rotteveel wrote: On 20-5-2018 13:00, Vlad Khorsun via Firebird-devel wrote:    I plan to introduce new database object "EXTERNAL DATA SOURCE" since initial implementation of EXECUTE STATEMENT ON EXTERNAL, but I never have time\priority to implement it, unfortunately.    T

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

2018-05-20 Thread Vlad Khorsun via Firebird-devel
20.05.2018 17:53, Dimitry Sibiryakov wrote: 20.05.2018 16:25, Adriano dos Santos Fernandes wrote: Isn't (some parts of) the config file already reloaded sometimes (timeout)?   Firebird.conf is reloaded when its timestamp changed. Plugins' configs are not reloaded. Where do you see it ? I

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

2018-05-20 Thread Vlad Khorsun via Firebird-devel
20.05.2018 14:11, liviuslivius wrote: Hi, can i ask why this is only for external connections? 2 databases. One user run execute statement on database 1 from 2 second on database 2 from 1. Third connect simply to database 1 why it can not benefit from pool? Explain, please. The statement ab

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

2018-05-20 Thread Dimitry Sibiryakov
20.05.2018 17:29, Vlad Khorsun via Firebird-devel wrote:   Where do you see it ? You are right, it is nowhere in main tree. Sorry, I missed it up with one of my branches. In any case it is easy to add cache object to ConfigImpl constructor. ConfigFile is ready for that. -- WBR, SD.

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

2018-05-20 Thread Vlad Khorsun via Firebird-devel
20.05.2018 19:14, Dimitry Sibiryakov wrote: 20.05.2018 17:29, Vlad Khorsun via Firebird-devel wrote:    Where do you see it ?   You are right, it is nowhere in main tree. Sorry, I missed it up with one of my branches.   In any case it is easy to add cache object to ConfigImpl constructor.

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

2018-05-20 Thread liviuslivius
>>Explain, please. The statement above >>could be understood in many different ways. >>Regards, >>Vlad  if pool contain connection to database 1and user try to connect to also database 1 he can use pool instead normal connection.Now i see that you are talking only when user use execute srat