support getGeneratedKeys method *and* without a specific SQL dialect sqlite

10:38:47,746 |-ERROR in ch.qos.logback.core.joran.spi.Interpreter@42:16 - RuntimeException in Action for tag [appender] java.lang.IllegalStateException: DBAppender cannot function if the JDBC driver does not support getGeneratedKeys method *and* without a specific SQL dialect
at java.lang.IllegalStateException: DBAppender cannot function if the JDBC driver does not support getGeneratedKeys method *and* without a specific SQL dialect

报如上错误，

查找如下代码，我的是在logback-admin.xml

复制代码
<appender name="db-classic-oracle" class="ch.qos.logback.classic.db.DBAppender">  
        <connectionSource class="ch.qos.logback.core.db.DriverManagerConnectionSource">  
            <dataSource class="org.apache.commons.dbcp.BasicDataSource">  
                <driverClassName>oracle.jdbc.driver.OracleDriver</driverClassName>  
                <url>jdbc:oracle:thin:@localhost:1521:ZYD</url>  
                <user>scott</user>  
                <password>tiger</password>  
            </dataSource>  
        </connectionSource>  
    </appender>
    <appender-ref ref="db-classic-oracle" />

改为：

<!-- 将日志存储到oracle数据库中 -->
    <appender name="db-classic-oracle" class="ch.qos.logback.classic.db.DBAppender">  
        <connectionSource class="ch.qos.logback.core.db.DriverManagerConnectionSource">  
            <dataSource class="com.mchange.v2.c3p0.ComboPooledDataSource">                 
                <driverClass>oracle.jdbc.driver.OracleDriver</driverClass>  
                <url>jdbc:oracle:thin:@localhost:1521:ZYD</url>  
                <user>scott</user>  
                <password>tiger</password>
                <sqlDialect class="ch.qos.logback.core.db.dialect.OracleDialect" />   
            </dataSource>  
        </connectionSource>
        <sqlDialect class="ch.qos.logback.core.db.dialect.OracleDialect" />  
    </appender> 

 

或者如果日志不需要存在数据库一份的话，可以把这部分去掉