couldn't set up logback to log to database

[K Makeev]

Hi all

Using Nifi 1.5
I want my certain processors Erorrs to be logged to Oracle database

So i set up separate dbaappender in logback.xml.
I also created tables in database where logs should go with these scripts
https://github.com/qos-ch/logback/blob/master/logback-classic/src/main/resources/ch/qos/logback/classic/db/script/oracle.sql

Those are my additional entries to logback.xml

<appender name="ora-pd" class="ch.qos.logback.classic.db.DBAppender">
<appender name="DB" class="ch.qos.logback.classic.db.DBAppender">
        <connectionSource
class="ch.qos.logback.core.db.DriverManagerConnectionSource">
            <driverClass>oracle.jdbc.driver.OracleDriver</driverClass>
            <url>jdbc:oracle:thin:@myhost:1521/myservice_name</url>
            <user>myuser</user>
            <password>mypassword</password>
        </connectionSource>
    </appender>

 <logger name="org.apache.nifi.processors.standard.ExecuteSQL"
level="ERROR"/>
        <appender-ref ref="ora-pd" />
    </logger>

I've restarted NIFI. But it still logs ExecuteSQL errors to nifi-app.log.

May be i should check some logback errors in its own log. But i don't know
where it is.
May be it doesn't see Oracle driver or smth. Nifi itself connects to these
database properly.

How should i set up database logging properly?

Kirill