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{- 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 str det om dig p ntet? - http://www.lycos.se/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: ms sql server and log4j problems
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{- 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]
Re: ms sql server and log4j problems
I believe the problem is with syntax of your SQL statement, not w/ log4j per se try putting commas between your VALUES in your SQL statement. -Don On Thu, 13 Nov 2003 09:55:45 -0500 [EMAIL PROTECTED] wrote: 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(???) state ment? 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.jav a: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, Logge r, Method, Message) VALUES ('%d{- 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 com munication, and may contain information that is confidential, propriet ary and/or privileged.This e-mail is intended only for the individua l(s) to whom it is addressed, and may not be saved, copied, printed, d isclosed or used by anyone else. If you are not the(an) intended reci pient, 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]