Jaikiran Pai wrote:See if these help:
Log4j JDBCAppender
JDBCAppender Example
Hi I have used the following set of statements. However this doesnot execute the sql and DB insertions are not successful.
JDBCAppender jDBCAppender = new JDBCAppender();
jDBCAppender.setDriver("oracle.jdbc.driver.OracleDriver");
jDBCAppender.setURL("jdbc:oracle:thin:@I.P:instance");
jDBCAppender.setUser("username");
jDBCAppender.setPassword("pwd");
jDBCAppender.setSql(sql);
logger.addAppender(jDBCAppender);
jDBCAppender.close();
Please suggest if there are any additions required to the above set.