java - log4j with oracle gives exception- invalid sql statement -

i try implement log4j logging in database example page, http://www.tutorialspoint.com/log4j/log4j_logging_database.htm

i edit xml like

<appender name="db" class="org.apache.log4j.jdbc.jdbcappender">     <param name="url" value="jdbc:oracle:thin:@ip:port:dbname"/>     <param name="driver" value="oracle.jdbc.oracledriver"/>     <param name="user" value="user"/>     <param name="password" value="pass"/>     <param name="sql" value="insert flow_path_logs values('%x',                          '%d','%c','%p','%m')"/>     <layout class="org.apache.log4j.patternlayout">     </layout> </appender> 

but gives sql exception, invalid sql statement. try replace statement select 1 dual gives same exception.

stack trace:

log4j:error failed excute sql java.sql.sqlsyntaxerrorexception: ora-00900: invalid sql statement  @ oracle.jdbc.driver.sqlstatemapping.newsqlexception(sqlstatemapping.java:91) @ oracle.jdbc.driver.databaseerror.newsqlexception(databaseerror.java:133) @ oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:206) @ oracle.jdbc.driver.t4cttioer.processerror(t4cttioer.java:455) @ oracle.jdbc.driver.t4cttioer.processerror(t4cttioer.java:413) @ oracle.jdbc.driver.t4c8oall.receive(t4c8oall.java:1035) @ oracle.jdbc.driver.t4cstatement.dooall8(t4cstatement.java:183) @ oracle.jdbc.driver.t4cstatement.executeforrows(t4cstatement.java:942) @ oracle.jdbc.driver.oraclestatement.doexecutewithtimeout(oraclestatement.java:1224) @ oracle.jdbc.driver.oraclestatement.executeupdateinternal(oraclestatement.java:1717) @ oracle.jdbc.driver.oraclestatement.executeupdate(oraclestatement.java:1685) @ oracle.jdbc.driver.oraclestatementwrapper.executeupdate(oraclestatementwrapper.java:275) @ org.apache.log4j.jdbc.jdbcappender.execute(jdbcappender.java:178) @ org.apache.log4j.jdbc.jdbcappender.flushbuffer(jdbcappender.java:250) @ org.apache.log4j.jdbc.jdbcappender.append(jdbcappender.java:146) @ org.apache.log4j.appenderskeleton.doappend(appenderskeleton.java:230) @ org.apache.log4j.helpers.appenderattachableimpl.appendlooponappenders(appenderattachableimpl.java:65) @ org.apache.log4j.category.callappenders(category.java:203) @ org.apache.log4j.category.forcedlog(category.java:388) @ org.apache.log4j.category.info(category.java:663) @ tr.com.innova.hukuk.ortak.controllers.ortakcontroller.logflowpath(ortakcontroller.java:751) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:39) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25) @ java.lang.reflect.method.invoke(method.java:597) @ org.jboss.el.util.reflectionutil.invokemethod(reflectionutil.java:328) @ org.jboss.el.util.reflectionutil.invokemethod(reflectionutil.java:273) @ org.jboss.el.parser.astmethodsuffix.getvalue(astmethodsuffix.java:59) @ org.jboss.el.parser.astvalue.getvalue(astvalue.java:67) @ org.jboss.el.valueexpressionimpl.getvalue(valueexpressionimpl.java:186) @ com.sun.facelets.el.eltext$eltextvariable.writetext(eltext.java:184) @ com.sun.facelets.compiler.textinstruction.write(textinstruction.java:45) @ com.sun.facelets.compiler.uiinstructions.encodebegin(uiinstructions.java:39) @ com.sun.facelets.compiler.uileaf.encodeall(uileaf.java:149) @ javax.faces.component.uicomponent.encodeall(uicomponent.java:257) @ com.sun.facelets.faceletviewhandler.renderview(faceletviewhandler.java:592) @ org.ajax4jsf.application.viewhandlerwrapper.renderview(viewhandlerwrapper.java:100) @ org.ajax4jsf.application.ajaxviewhandler.renderview(ajaxviewhandler.java:176) @ org.springframework.faces.webflow.jsfview.render(jsfview.java:89) @ org.springframework.webflow.engine.viewstate.render(viewstate.java:282) @ org.springframework.webflow.engine.viewstate.refresh(viewstate.java:241) @ org.springframework.webflow.engine.viewstate.resume(viewstate.java:219) @ org.springframework.webflow.engine.flow.resume(flow.java:545) @ org.springframework.webflow.engine.impl.flowexecutionimpl.resume(flowexecutionimpl.java:259) @ org.springframework.webflow.executor.flowexecutorimpl.resumeexecution(flowexecutorimpl.java:169) @ org.springframework.webflow.mvc.servlet.flowhandleradapter.handle(flowhandleradapter.java:183) @ org.springframework.web.servlet.dispatcherservlet.dodispatch(dispatcherservlet.java:875) @ org.springframework.web.servlet.dispatcherservlet.doservice(dispatcherservlet.java:807) @ org.springframework.web.servlet.frameworkservlet.processrequest(frameworkservlet.java:571) @ org.springframework.web.servlet.frameworkservlet.doget(frameworkservlet.java:501) @ javax.servlet.http.httpservlet.service(httpservlet.java:707) @ javax.servlet.http.httpservlet.service(httpservlet.java:820) @ tr.com.innova.common.middleware.web.servlets.servlettobeanproxy.service(servlettobeanproxy.java:46) @ weblogic.servlet.internal.stubsecurityhelper$servletserviceaction.run(stubsecurityhelper.java:227) @ weblogic.servlet.internal.stubsecurityhelper.invokeservlet(stubsecurityhelper.java:125) @ weblogic.servlet.internal.servletstubimpl.execute(servletstubimpl.java:300) @ weblogic.servlet.internal.tailfilter.dofilter(tailfilter.java:26) @ weblogic.servlet.internal.filterchainimpl.dofilter(filterchainimpl.java:56) @ org.ajax4jsf.webapp.basexmlfilter.doxmlfilter(basexmlfilter.java:178) @ org.ajax4jsf.webapp.basefilter.handlerequest(basefilter.java:290) @ org.ajax4jsf.webapp.basefilter.processuploadsandhandlerequest(basefilter.java:388) @ org.ajax4jsf.webapp.basefilter.dofilter(basefilter.java:515) @ weblogic.servlet.internal.filterchainimpl.dofilter(filterchainimpl.java:56) @ org.acegisecurity.util.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:265) @ org.acegisecurity.util.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:265) @ tr.com.innova.ortak.web.filters.expiredpasswordcheckfilter.dofilter(expiredpasswordcheckfilter.java:48) @ org.acegisecurity.util.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:275) @ org.acegisecurity.intercept.web.filtersecurityinterceptor.invoke(filtersecurityinterceptor.java:107) @ tr.com.innova.ortak.web.filters.flowsecurityfilter.dofilter(flowsecurityfilter.java:38) @ org.acegisecurity.util.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:275) @ org.acegisecurity.ui.exceptiontranslationfilter.dofilter(exceptiontranslationfilter.java:124) @ org.acegisecurity.util.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:275) @ org.acegisecurity.wrapper.securitycontextholderawarerequestfilter.dofilter(securitycontextholderawarerequestfilter.java:81) @ org.acegisecurity.util.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:275) @ org.acegisecurity.providers.anonymous.anonymousprocessingfilter.dofilter(anonymousprocessingfilter.java:125) @ org.acegisecurity.util.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:275) @ org.acegisecurity.ui.abstractprocessingfilter.dofilter(abstractprocessingfilter.java:271) @ org.acegisecurity.util.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:275) @ tr.com.innova.ortak.web.filters.idmfilter.dofilter(idmfilter.java:68) @ org.acegisecurity.util.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:275) @ org.acegisecurity.ui.logout.logoutfilter.dofilter(logoutfilter.java:110) @ org.acegisecurity.util.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:275) @ org.acegisecurity.context.httpsessioncontextintegrationfilter.dofilter(httpsessioncontextintegrationfilter.java:249) @ org.acegisecurity.util.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:275) @ org.acegisecurity.util.filterchainproxy.dofilter(filterchainproxy.java:149) @ org.acegisecurity.util.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:275) @ org.springframework.web.filter.characterencodingfilter.dofilterinternal(characterencodingfilter.java:96) @ org.springframework.web.filter.onceperrequestfilter.dofilter(onceperrequestfilter.java:76) @ org.acegisecurity.util.filterchainproxy$virtualfilterchain.dofilter(filterchainproxy.java:275) @ org.acegisecurity.util.filterchainproxy.dofilter(filterchainproxy.java:149) @ org.acegisecurity.util.filtertobeanproxy.dofilter(filtertobeanproxy.java:98) @ weblogic.servlet.internal.filterchainimpl.dofilter(filterchainimpl.java:56) @ org.jasig.cas.client.session.singlesignoutfilter.dofilter(singlesignoutfilter.java:99) @ weblogic.servlet.internal.filterchainimpl.dofilter(filterchainimpl.java:56) @ tr.com.innova.ortak.web.filters.iloggerfilter.dofilter(iloggerfilter.java:60) @ org.acegisecurity.util.filtertobeanproxy.dofilter(filtertobeanproxy.java:98) @ weblogic.servlet.internal.filterchainimpl.dofilter(filterchainimpl.java:56) @ weblogic.servlet.internal.requesteventsfilter.dofilter(requesteventsfilter.java:27) @ weblogic.servlet.internal.filterchainimpl.dofilter(filterchainimpl.java:56) @ weblogic.servlet.internal.webappservletcontext$servletinvocationaction.doit(webappservletcontext.java:3684) @ weblogic.servlet.internal.webappservletcontext$servletinvocationaction.run(webappservletcontext.java:3650) @ weblogic.security.acl.internal.authenticatedsubject.doas(authenticatedsubject.java:321) @ weblogic.security.service.securitymanager.runas(securitymanager.java:121) @ weblogic.servlet.internal.webappservletcontext.securedexecute(webappservletcontext.java:2268) @ weblogic.servlet.internal.webappservletcontext.execute(webappservletcontext.java:2174) @ weblogic.servlet.internal.servletrequestimpl.run(servletrequestimpl.java:1446) @ weblogic.work.executethread.execute(executethread.java:201) @ weblogic.work.executethread.run(executethread.java:173) 

i'm thankful advice.

there mistake in example. have move insert statement conversionpattern within layout.

so want like:

<layout class="org.apache.log4j.patternlayout">     <param name="conversionpattern" value="insert flow_path_logs values('%x', %d','%c','%p','%m')"/> </layout>