File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Java Interview Guide this week in the Jobs Discussion 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
It's not a secret anymore!