<properties>

        <!-- https://mvnrepository.com/artifact/com.googlecode.log4jdbc/log4jdbc -->
        <log4jdbc.version>1.2</log4jdbc.version>

        <!-- https://mvnrepository.com/artifact/org.bgee.log4jdbc-log4j2/log4jdbc-log4j2 -->
        <!-- https://mvnrepository.com/artifact/org.bgee.log4jdbc-log4j2/log4jdbc-log4j2-jdbc4.1 -->
        <log4jdbc-log4j2.version>1.16</log4jdbc-log4j2.version>

    </properties>

    <dependencies>

        <dependency>
            <groupId>com.googlecode.log4jdbc</groupId>
            <artifactId>log4jdbc</artifactId>
            <version>${log4jdbc.version}</version>
        </dependency>

        <dependency>
            <groupId>org.bgee.log4jdbc-log4j2</groupId>
            <artifactId>log4jdbc-log4j2</artifactId>
            <version>${log4jdbc-log4j2.version}</version>
            <type>pom</type>
        </dependency>
        <dependency>
            <groupId>org.bgee.log4jdbc-log4j2</groupId>
            <artifactId>log4jdbc-log4j2-jdbc4.1</artifactId>
            <version>${log4jdbc-log4j2.version}</version>
        </dependency>

        <dependency>
            <groupId>com.h2database</groupId>
            <artifactId>h2</artifactId>
        </dependency>

        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-api</artifactId>
        </dependency>
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-core</artifactId>
        </dependency>

    </dependencies>

public class Log4jdbcInterceptorExample {

    private static final String CONNECTION_PARAMS = ";USER=sa;PASSWORD=;DB_CLOSE_ON_EXIT=FALSE";
    private static final String CONNECTION_URL = "jdbc:log4jdbc:h2:mem:log4jdbc_example" + CONNECTION_PARAMS;
    private static final String TABLE_NAME = "person";

    static {
        System.setProperty("logsDirectory", "~path_to_logs_folder~/java_temp/log4jdbc/logs");
    }

    public static void main(String[] args) {
        try {
            Log4jdbcInterceptorExample simulator = new Log4jdbcInterceptorExample();
            simulator.initializeDB();
            simulator.populateDB();
            simulator.run();
            simulator.terminateDB();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    private Connection connection;

    private void initializeDB() throws SQLException {
        try {
            // загружаем драйвер DriverSpy, который подменяет  наш jdbc драйвер
            //Class.forName("net.sf.log4jdbc.DriverSpy").newInstance();
            //Class.forName("net.sf.log4jdbc.sql.jdbcapi.DriverSpy").newInstance();
        } catch (Exception e) {
            e.printStackTrace();
        }

        connection = DriverManager.getConnection(CONNECTION_URL, "sa", "");
        connection.setAutoCommit(true);
    }

    private void populateDB() throws SQLException {
        createTable();
        insertRows();
    }

    private void createTable() throws SQLException {
        final String createTableQuery = " DROP TABLE IF EXISTS `" + TABLE_NAME + "`; " +
                " CREATE TABLE IF NOT EXISTS `" + TABLE_NAME + "` ( " +
                "   `id`        bigint(20)   NOT NULL AUTO_INCREMENT, " +
                "   `name`      varchar(255) NOT NULL, " +
                "   `gender`    varchar(255) NOT NULL, " +
                "   `interests` varchar(255) NOT NULL, " +
                "   `rating`    bigint(5)    DEFAULT 0, " +
                "   PRIMARY KEY (`id`), " +
                "   UNIQUE KEY `UK_person_name` (`name`) " +
                " ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; ";

        try (Statement stmt = connection.createStatement()) {
            stmt.executeUpdate(createTableQuery);
        }
    }

    private void insertRows() throws SQLException {
        final String insertIntoQuery = " INSERT INTO `" + TABLE_NAME + "` (`name`, `gender`, `interests`, `rating`) " +
                " VALUES (?, ?, ?, ?); ";

        try (PreparedStatement ps = connection.prepareStatement(insertIntoQuery)) {
            ps.setString(1, "Joe Javabean");
            ps.setString(2, "male");
            ps.setString(3, "none");
            ps.setInt(4, 0);
            ps.addBatch();

            ps.setString(1, "Sarah Connor");
            ps.setString(2, "female");
            ps.setString(3, "none");
            ps.setInt(4, 0);
            ps.addBatch();

            ps.setString(1, "Рarry Potеer");
            ps.setString(2, "x-male");
            ps.setString(3, "none");
            ps.setInt(4, 0);
            ps.addBatch();

            ps.executeBatch();
        }
    }

    private void run() throws SQLException {
        String personName = "Joe Javabean";
        String joe = getPersonBeanFormDB(personName);
        System.out.println("joe: " + joe);
    }

    private void terminateDB() throws SQLException {
    }

    private String getPersonBeanFormDB(final String personName) throws SQLException {
        final String selectQuery = " select name, gender, interests, rating " +
                " from " + TABLE_NAME +
                " where name = '" + personName + "'; ";

        try (Statement stmt = connection.createStatement();
             ResultSet rs = stmt.executeQuery(selectQuery) ) {
            while (rs.next()) {
                String name = rs.getString("name");
                String gender = rs.getString("gender");
                String interests = rs.getString("interests");
                int rating = rs.getInt("rating");

                return "{name=`" + name + "`, gender=`" + gender + "`, interests=`" + interests + "`, rating=" + rating + "}";
            }
        }
        return null;
    }

}

log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator

# log4jdbc.file=${logsDirectory}/log4jdbc.log

log4jdbc.request.sql.style=none|oneline|format
log4jdbc.request.sql.all=true
log4jdbc.request.sql.execute=false
log4jdbc.request.sql.batch=false
log4jdbc.request.sql.select=false
log4jdbc.request.sql.select.resultset=false
log4jdbc.request.sql.insert=false
log4jdbc.request.sql.update=false
log4jdbc.request.sql.delete=false
log4jdbc.request.sql.create=false

log4jdbc.stacktrace=false
# !log4jdbc.stacktrace.start.packages=fr.test,fr.super,fr.app