aspose file tools*
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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "log4j JDBCAppender with Oracle problem" Watch "log4j JDBCAppender with Oracle problem" New topic
Author

log4j JDBCAppender with Oracle problem

Sagar Kale
Ranch Hand

Joined: May 02, 2008
Posts: 188
Hi

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(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:796)
at org.apache.log4j.jdbc.JDBCAppender.execute(JDBCAppender.java:178)
at org.apache.log4j.jdbc.JDBCAppender.flushBuffer(JDBCAppender.java:250)
at org.apache.log4j.jdbc.JDBCAppender.append(JDBCAppender.java:146)
at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:230)
at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:65)
at org.apache.log4j.Category.callAppenders(Category.java:203)
at org.apache.log4j.Category.forcedLog(Category.java:388)
at org.apache.log4j.Category.debug(Category.java:257)
at com.test.test.Test1.testLogging(Test1.java:16)
at com.test.test.Test1.<init>(Test1.java:13)
at com.test.test.Test1.main(Test1.java:25)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: log4j JDBCAppender with Oracle problem