You should be able to enable debug logging on the JDBC driver itself. On Thu, Feb 21, 2019 at 11:35 AM fredaffini <[email protected]> wrote:
> Hello, > > I am new to Nifi and I am creating a simple Flow that reads from an CSV > file > and saves to a database table. > The flow is working depending on the input .csv for some of the testcases a > line in CSV will cause a violation on the database while trying to insert > the data. > > I would like to know the whole insert command that was attempted against > the > database, all I have from logs is: > > 2019-02-21 17:07:09,624 WARN [Timer-Driven Process Thread-2] > o.a.n.p.standard.PutDatabaseRecord > PutDatabaseRecord[id=107c7d4e-0169-1000-e2cd-5182d88357c7] Failed to > process > > StandardFlowFileRecord[uuid=ee2a63d7-5cca-4b6c-a77d-3c5a3111843c,claim=StandardContentClaim > [resourceClaim=StandardResourceClaim[id=1550765225116-1, container=default, > section=1], offset=0, > length=12484923],offset=0,name=test.csv,size=12484923] > due to java.sql.BatchUpdateException: ORA-00001: unique constraint > (SYSTEM.SYS_C007013) violated > > If I could find the line on CSV that caused the error would be good to. Any > tips on how to do that? > > Regards, > Fred > > > > > > -- > Sent from: http://apache-nifi-developer-list.39713.n7.nabble.com/ >
