Hi ,
I was trying to use JDBCAppender.
<param name="sql" value="insert into PFO_LOGS (
LOG_DATE,LOG_USER_ID, LOG_CODE_LOCATION, LOG_PRIORITY,
LOG_MESSAGE) values ( to_date('%d{yyyy-MM-dd
hh:mm:ss}' ,'YYYY-MM-DD HH-MI-SS') , '%x' , '%l' ,
'%p' , '%m') " />
I get this error only if '%m' is in the above sql.
Is this a bug with JDBCAppender or am I missing
something.
-------------------------------------------
Start of Error
-------------------------------------------
log4j:ERROR Failed to excute sql
java.sql.SQLException: ORA-00917: missing comma
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:579)
at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2877)
at
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:858)
at
org.apache.log4j.jdbc.JDBCAppender.execute(JDBCAppender.java:163)
at
org.apache.log4j.jdbc.JDBCAppender.flushBuffer(JDBCAppender.java:235)
at
org.apache.log4j.jdbc.JDBCAppender.append(JDBCAppender.java:131)
at
org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:221)
at
org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders
(AppenderAttachableImpl.java:57)
at
org.apache.log4j.Category.callAppenders(Category.java:187)
at
org.apache.log4j.Category.forcedLog(Category.java:372)
at
org.apache.log4j.Category.log(Category.java:864)
at
org.apache.commons.logging.impl.Log4JLogger.info(Log4JLogger.java:152)
at
org.apache.struts.util.PropertyMessageResources.<init>(PropertyMessageResources.java:127)
at
org.apache.struts.util.PropertyMessageResourcesFactory.createResources(PropertyMessageResourcesFactory.java:90)
at
org.apache.struts.util.MessageResources.getMessageResources(MessageResources.java:577)
at
org.apache.struts.util.RequestUtils.<clinit>(RequestUtils.java:134)
at
org.apache.struts.util.MessageResourcesFactory.createFactory(MessageResourcesFactory.java:192)
at
org.apache.struts.util.MessageResources.getMessageResources(MessageResources.java:576)
at
org.apache.struts.action.ActionServlet.initInternal(ActionServlet.java:1329)
at
org.apache.struts.action.ActionServlet.init(ActionServlet.java:464)
at
javax.servlet.GenericServlet.init(GenericServlet.java:258)
at
weblogic.servlet.internal.ServletStubImpl$ServletInitAction.run(ServletStubImpl.java:1070)
at
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
at
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
at
weblogic.servlet.internal.ServletStubImpl.createServlet(ServletStubImpl.java:893)
at
weblogic.servlet.internal.ServletStubImpl.createInstances(ServletStubImpl.java:842)
at
weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.java:782)
at
weblogic.servlet.internal.WebAppServletContext.preloadServlet(WebAppServletContext.java:3236)
at
weblogic.servlet.internal.WebAppServletContext.preloadServlets(WebAppServletContext.java:3181)
at
weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:3154)
at
weblogic.servlet.internal.HttpServer.preloadResources(HttpServer.java:654)
at
weblogic.servlet.internal.WebService.preloadResources(WebService.java:483)
at
weblogic.servlet.internal.ServletInitService.resume(ServletInitService.java:30)
at
weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
at
weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
at
weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
at weblogic.Server.main(Server.java:32)
-------------------------------------------
End of Error
-------------------------------------------
Thanks.
Peter
__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you�re looking for faster
http://search.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
