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. This usually gives much better performance, and also when we execute them as a batch, we get more of a transactional capability (one flow file = one batch = one transaction).
Please feel free to file a Jira to add record output to PutDatabaseRecord at a DEBUG level. Regards, Matt On Wed, Feb 27, 2019 at 7:05 AM Mike Thomsen <mikerthom...@gmail.com> wrote: > > 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 <frederico.aff...@gmail.com> > wrote: >> >> 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 >> PutDatabaseRecord[id=adcd1a7d-1000-1169-8aa8-92d8f2e891e5] Executing query >> INSERT INTO SYSTEM.NIFI_INPUT_TEST (ID_BB_GLOBAL, BLOOMBERG_CODE, ID_ISIN, >> ID_CUSIP, ID_SEDOL, TICKER, ID_BB_COMPANY, ID_GRID, CRNCY, INSTYP, ISSUE_DT, >> CPN_TYP, CPN, MTY_TYP, MATURITY, WORKOUT_DT_BID) VALUES >> (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); fieldIndexes: [0, 1, 2, 3, 4, 5, 6, 7, 8, >> 9, 10, 11, 12, 13, 14, 15]; batch index: 1; batch size: 1499 >> >> I think the log should put the values in the parameters, looks like it is >> being logged before preparing the statement. I still have a way to figure it >> out, since it gives me the field index and I suppose that: *batch index: 1; >> batch size: 1499* means the first line of my file (that has 1499 lines) >> >> Should this be a request for improvement in the processor? >> >> Regards, >> Fred >> >> >> >> -- >> Sent from: http://apache-nifi-users-list.2361937.n4.nabble.com/
