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]