Re: log4j:ERROR Failed to excute sql [java.sql.SQLException: ORA-00917: missing comma]

[Thomas Svensen]

Your message (from %m) probably includes an apostrophe: ', which is not 
properly escaped. You are better off using the JDBCAppender found here: 
http://www.dankomannhaupt.de/projects/index.html

- Thomas S.

On Thu, 11 Mar 2004 14:17:55 -0800 (PST), Peter Vennel <[EMAIL PROTECTED]> 
wrote:

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.



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]