Re: Log Queries being executed by PutDatabaseRecord

2019-02-28 Thread Andrew Grande
Could ve a good idea to log values at TRACE level then. On Wed, Feb 27, 2019, 7:56 AM Matt Burgess wrote: > True, at a DEBUG level we could output the record values, although for > large flow files this will be quite verbose :) Also the point of the > ?s is not necessarily to not show the

Re: Log Queries being executed by PutDatabaseRecord

2019-02-27 Thread Matt Burgess
True, at a DEBUG level we could output the record values, although for large flow files this will be quite verbose :) Also the point of the ?s is not necessarily to not show the values, but that we are technically only issuing one statement (i.e. PreparedStatement), and just the values change.

Re: Log Queries being executed by PutDatabaseRecord

2019-02-27 Thread Mike Thomsen
I could be mistaken, but I think that's standard JDBC behavior to not show the values. That said, yes it would be a fairly trivial improvement to add a dump of the record to a debug logger. On Wed, Feb 27, 2019 at 4:36 AM Fred Affini wrote: > Hi Matt and Phillip, thanks a lot for the help > >

Re: Log Queries being executed by PutDatabaseRecord

2019-02-27 Thread Fred Affini
Hi Matt and Phillip, thanks a lot for the help Setting PutDatabaseRecord log level to DEBUG (changing Bulletin Level in the GUI or insert the XML line Matt sent) almost gave me what I need, the log nos show: 10:32:55 CETDEBUGadcd1a7d-1000-1169-8aa8-92d8f2e891e5

Re: Log Queries being executed by PutDatabaseRecord

2019-02-26 Thread Phillip Grenier
Fred, Sorry for the confusion, but I meant the log level on the PutDatabaseRecord processor should be set to Debug. Phillip On Tue, Feb 26, 2019 at 11:32 AM Fred Affini wrote: > Hi Phillip, thanks for the reply. > > All my relationships (success, failure, retry) from PutDatabaseRecord are >

Re: Log Queries being executed by PutDatabaseRecord

2019-02-26 Thread Matt Burgess
Fred, Try adding the following line to conf/logback.xml (somewhere around line 88 where the other special processor levels are set :P) Regards, Matt On Tue, Feb 26, 2019 at 11:32 AM Fred Affini wrote: > > Hi Phillip, thanks for the reply. > > All my relationships (success, failure, retry)

Re: Log Queries being executed by PutDatabaseRecord

2019-02-26 Thread Fred Affini
Hi Phillip, thanks for the reply. All my relationships (success, failure, retry) from PutDatabaseRecord are point to an LogAttribute processor. On the properties of LogAttribute I have: Log Level = debug Attributes to Log = statement.type What I got on bulletin board is: 17:29:31 CET WARNING

Re: Log Queries being executed by PutDatabaseRecord

2019-02-26 Thread Phillip Grenier
Fred, Set the log level to debug and it should show on the bulletin. If you are using the "Use statement.type Attribute", use the LogAttribute processor to report the sql attribute. Phillip https://nifi.rocks On Tue, Feb 26, 2019 at 8:30 AM fredaffini wrote: > Hello, > > Iam new to NiFi and