Howdy, Can you rerun your system with -Dlog4j.debug=true as a java runtime option, and tell us what you're logging in the logger.error(???) statement?
Yoav Shapira Millennium ChemInformatics >-----Original Message----- >From: Magnus Andersson [mailto:[EMAIL PROTECTED] >Sent: Thursday, November 13, 2003 9:55 AM >To: Log4J Users List >Subject: ms sql server and log4j problems > >i got a problem with my database and log4j. I found a correct driver that >connect to database but i got a error >message that says: >log4j:ERROR Failed to excute sql >java.sql.SQLException: [MAGNUS]Line 1: Incorrect syntax near 'ERROR'. > at com.inet.tds.a.a(Unknown Source) > at com.inet.tds.g.if(Unknown Source) > at com.inet.tds.g.executeUpdate(Unknown Source) > 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.error(Category.java:286) > at GetMail.main(GetMail.java:76) >and that 'ERROR' is in the java code the first log message it says >logger.error("logging started"); > >This is the config file: >log4j.rootLogger=DEBUG, ROOT > > >#log4j.appender.ROOT.Driver=sun.jdbc.odbc.JdbcOdbcDriver > >log4j.appender.ROOT=org.apache.log4j.jdbc.JDBCAppender >log4j.appender.ROOT.Driver=com.inet.tds.TdsDriver > >log4j.appender.ROOT.URL=jdbc:inetdae7:MAGNUS:1433?database=Log4j_db >log4j.appender.ROOT.user=sa >log4j.appender.ROOT.password=sa >log4j.appender.ROOT.sql=INSERT INTO JDBCTEST (Date, Priority, Logger, >Method, Message) VALUES ('%d{yyyy- >MMM-dd HH:mm:ss,SSS}' '%-5.5p' '%C' '%M' '%m\r\n') >log4j.appender.ROOT.layout=org.apache.log4j.PatternLayout >PLEASE what is wrong??? > >____________________________________________________________ > Vad står det om dig på nätet? - http://www.lycos.se/ > This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
