It's not a secret anymore!
The moose likes Other Open Source Projects and the fly likes log4j JDBCAppender with Oracle problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "log4j JDBCAppender with Oracle problem" Watch "log4j JDBCAppender with Oracle problem" New topic

log4j JDBCAppender with Oracle problem

Sagar Kale
Ranch Hand

Joined: May 02, 2008
Posts: 188

I am trying to configure log4j JdbcAppender with Oracle Database. My properties file is

My Java class is

but after getting logger and trying log error, I get following

log4j:ERROR Failed to excute sql
java.sql.SQLException: ORA-01009: missing mandatory parameter

at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.ttc7.TTIoer.processError(
at oracle.jdbc.ttc7.Oall7.receive(
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(
at oracle.jdbc.driver.OracleStatement.executeNonQuery(
at oracle.jdbc.driver.OracleStatement.doExecuteOther(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OracleStatement.executeUpdate(
at org.apache.log4j.jdbc.JDBCAppender.execute(
at org.apache.log4j.jdbc.JDBCAppender.flushBuffer(
at org.apache.log4j.jdbc.JDBCAppender.append(
at org.apache.log4j.AppenderSkeleton.doAppend(
at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(
at org.apache.log4j.Category.callAppenders(
at org.apache.log4j.Category.forcedLog(
at org.apache.log4j.Category.debug(
at com.test.test.Test1.testLogging(
at com.test.test.Test1.<init>(
at com.test.test.Test1.main(
I agree. Here's the link:
subject: log4j JDBCAppender with Oracle problem
jQuery in Action, 3rd edition