Re: [Firebird-devel] FBJava plugin issues

2018-05-16 Thread Adriano dos Santos Fernandes
On 16/05/2018 16:44, Chmakov, Vladimir wrote: > Hello, > > "Stops working" means that the trigger doesn't produce any logs. > Should be a classloading issue. You need to debug slf4j/logback config loading. Adriano

Re: [Firebird-devel] FBJava plugin issues

2018-05-16 Thread Adriano dos Santos Fernandes
On 16/05/2018 16:48, Leyne, Sean wrote: > > We are testing FBJava plugin to see how well it suits our purposes. For the testing we use example provided with the package. It works well when deployed directly into the DB. However, when JAR is placed externally,

[Firebird-devel] [FB-Tracker] Created: (CORE-5828) udr pascal returning char(x) cannot be converted to bigint

2018-05-16 Thread Karol Bieniaszewski (JIRA)
udr pascal returning char(x) cannot be converted to bigint -- Key: CORE-5828 URL: http://tracker.firebirdsql.org/browse/CORE-5828 Project: Firebird Core Issue Type: Bug

Re: [Firebird-devel] FBJava plugin issues

2018-05-16 Thread Chmakov, Vladimir
Hello Mark, Thank you for your reply! Yes, the documentation recommends placing JARs inside the DB, but the "external" deployment better suits our software deployment policies. My expectation would be that regardless of the JAR deployment model all JAR components exposed onto the class path

Re: [Firebird-devel] FBJava plugin issues

2018-05-16 Thread Leyne, Sean
> > > We are testing FBJava plugin to see how well it suits our purposes. > > > For the testing we use example provided with the package. It works > > > well when deployed directly into the DB. However, when JAR is placed > > > externally, org.firebirdsql.fbjava.examples.fbjava_example example.

Re: [Firebird-devel] FBJava plugin issues

2018-05-16 Thread Leyne, Sean
> > We are testing FBJava plugin to see how well it suits our purposes. > > For the testing we use example provided with the package. It works > > well when deployed directly into the DB. However, when JAR is placed > > externally, org.firebirdsql.fbjava.examples.fbjava_example example. > >

Re: [Firebird-devel] FBJava plugin issues

2018-05-16 Thread Adriano dos Santos Fernandes
On 16/05/2018 16:26, Adriano dos Santos Fernandes wrote: > On 14/05/2018 09:21, Chmakov, Vladimir wrote: >> Hello, >> >>   >> >> We are testing FBJava plugin to see how well it suits our purposes. >> For the testing we use example provided with the package. It works >> well when deployed directly

Re: [Firebird-devel] FBJava plugin issues

2018-05-16 Thread Adriano dos Santos Fernandes
On 16/05/2018 15:39, Leyne, Sean wrote: > >> The fbjava documentation specifically says not to put more jar files there: >> >> """ >> The internal classes necessary for FB/Java are in >> /jar/*.jar >> and is not recommended to put more jar files there. >> """ > "Not recommended" does

Re: [Firebird-devel] FBJava plugin issues

2018-05-16 Thread Adriano dos Santos Fernandes
On 14/05/2018 09:21, Chmakov, Vladimir wrote: > > Hello, > >   > > We are testing FBJava plugin to see how well it suits our purposes. > For the testing we use example provided with the package. It works > well when deployed directly into the DB. However, when JAR is placed > externally,

Re: [Firebird-devel] FBJava plugin issues

2018-05-16 Thread Leyne, Sean
> The fbjava documentation specifically says not to put more jar files there: > > """ > The internal classes necessary for FB/Java are in > /jar/*.jar > and is not recommended to put more jar files there. > """ "Not recommended" does not mean "must not" or "is not supported" >

Re: [Firebird-devel] CORE-5343 and CORE-2557

2018-05-16 Thread Dmitry Yemanov
16.05.2018 21:24, livius wrote: by the same i mean ALTER ROLE EXISTING SET SYSTEM PRIVILEGES TO MONITOR_ANY_STATMENTS? or granting MONITOR_ANY_ATTACHMENT affect any MON$ tables? I need to have possibility to grant select on all attachemnts but i do not want that such user see all statements

Re: [Firebird-devel] CORE-5343 and CORE-2557

2018-05-16 Thread livius
Hi, by the same i mean ALTER ROLE EXISTING SET SYSTEM PRIVILEGES TO MONITOR_ANY_STATMENTS? or granting MONITOR_ANY_ATTACHMENT affect any MON$ tables? I need to have possibility to grant select on all attachemnts but i do not want that such user see all statements content. regards, Karol

Re: [Firebird-devel] CORE-5343 and CORE-2557

2018-05-16 Thread ALİ ÇEKER
thank you 2018-05-16 19:06 GMT+03:00 Mark Rotteveel : > On 16-5-2018 17:55, ALİ ÇEKER wrote: > >> >> I need to create and install the user but I can not do the error I added >> in the picture >> > > Please don't hijack threads on other subjects. If you want to post a >

Re: [Firebird-devel] CORE-5343 and CORE-2557

2018-05-16 Thread Mark Rotteveel
On 16-5-2018 17:55, ALİ ÇEKER wrote: I need to create and install the user but I can not do the error I added in the picture Please don't hijack threads on other subjects. If you want to post a question, start a new thread (post a new message instead of replying to an existing one).

Re: [Firebird-devel] CORE-5343 and CORE-2557

2018-05-16 Thread ALİ ÇEKER
I need to create and install the user but I can not do the error I added in the picture 2018-05-16 18:50 GMT+03:00 ALİ ÇEKER : > YES > > > 2018-05-16 17:40 GMT+03:00 liviuslivius : > >> Hi, >> >> Is the same for mon$statements and other mon

Re: [Firebird-devel] CORE-5343 and CORE-2557

2018-05-16 Thread ALİ ÇEKER
YES 2018-05-16 17:40 GMT+03:00 liviuslivius : > Hi, > > Is the same for mon$statements and other mon tables? > > > Regards, > Karol Bieniaszewski > > > -- > Check out the vibrant tech

Re: [Firebird-devel] CORE-5343 and CORE-2557

2018-05-16 Thread liviuslivius
Hi, Is the same for mon$statements and other mon tables? Regards,Karol Bieniaszewski null-- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org!

Re: [Firebird-devel] FBJava plugin issues

2018-05-16 Thread Mark Rotteveel
On 14-5-2018 17:53, Chmakov, Vladimir wrote: Hello, We are placing them into %FBJAVA_ROOT%\jar folder. The fbjava documentation specifically says not to put more jar files there: """ The internal classes necessary for FB/Java are in /jar/*.jar and is not recommended to put more

Re: [Firebird-devel] Virtual table for time zones

2018-05-16 Thread Adriano dos Santos Fernandes
On 16/05/2018 11:11, Mark Rotteveel wrote: > > If you look at PostgreSQL, they release a new point release with > updated time zone data. I don't see why we need to make this more > complicated than that. > > However that does mean, that we need to have a quick turn-around time > for new releases

Re: [Firebird-devel] Virtual table for time zones

2018-05-16 Thread Mark Rotteveel
On 14-5-2018 09:13, Simonov Denis via Firebird-devel wrote: Adriano dos Santos Fernandes wrote Thu, 10 May 2018 18:21:49 +0300: Hi! I want to create a virtual table that lists available time zones. For now there is RDB$ (non-virtual), MON$ (virtual, but all about

Re: [Firebird-devel] CORE-5343 and CORE-2557

2018-05-16 Thread ALİ ÇEKER
hello Can not create user for IoQ program and send it to me http://www.loqsoft.net/tr/urun/loq-basic 2018-05-16 10:22 GMT+03:00 Alex Peshkoff via Firebird-devel < firebird-devel@lists.sourceforge.net>: > On 05/16/18 09:26, liviuslivius wrote: > >> Hi, >> can you point me if i understand

Re: [Firebird-devel] CORE-5343 and CORE-2557

2018-05-16 Thread Alex Peshkoff via Firebird-devel
On 05/16/18 09:26, liviuslivius wrote: Hi, can you point me if i understand correctly that if user need to see all data in e.g. mon$attachement i cannot grant he/se privilege or add this privilege to currently existed role You can add this privilege to existing role: SQL> SHOW ROLE EXISTING;

[Firebird-devel] CORE-5343 and CORE-2557

2018-05-16 Thread liviuslivius
Hi,   can you point me if i understand correctly that if user need to see all data in e.g. mon$attachement i cannot grant he/se privilege or add this privilege to currently existed role instead i must create separate role for this and grant this role to user or grant that role to other role?   If