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/ >
