Return-Path: Delivered-To: apmail-jakarta-log4j-user-archive@apache.org Received: (qmail 79531 invoked from network); 6 Aug 2002 13:37:16 -0000 Received: from unknown (HELO nagoya.betaversion.org) (192.18.49.131) by daedalus.apache.org with SMTP; 6 Aug 2002 13:37:16 -0000 Received: (qmail 22705 invoked by uid 97); 6 Aug 2002 13:37:35 -0000 Delivered-To: qmlist-jakarta-archive-log4j-user@jakarta.apache.org Received: (qmail 22619 invoked by uid 97); 6 Aug 2002 13:37:34 -0000 Mailing-List: contact log4j-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Log4J Users List" Reply-To: "Log4J Users List" Delivered-To: mailing list log4j-user@jakarta.apache.org Received: (qmail 22607 invoked by uid 98); 6 Aug 2002 13:37:33 -0000 X-Antivirus: nagoya (v4198 created Apr 24 2002) Message-ID: <21D69ED9FBBCD244B4F90368B4CD045D4D6AE3@gtsny19> From: "Bhangale, Bhushan" To: 'Log4J Users List' Subject: RE: JDBCAppender problem Date: Tue, 6 Aug 2002 10:37:05 -0300 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Its okay now my problem solved but this @msg@ funda doesn't work. I tried all possible ways. May be if somebody has really done it successfully can throw some light on it. -----Original Message----- From: Steve.Lewis@ctimi.com [mailto:Steve.Lewis@ctimi.com] Sent: Tuesday, August 06, 2002 9:11 AM To: Log4J Users List Subject: RE: JDBCAppender problem Oops. You're right. I don't know then. Maybe try lowercase in the sql. "@msg@" ?? Steve |---------+------------------------------> | | "Bhangale, Bhushan"| | | | | | | | | 08/06/2002 10:08 AM| | | Please respond to | | | "Log4J Users List" | | | | |---------+------------------------------> >--------------------------------------------------------------------------- -----------------------------------| | | | To: 'Log4J Users List' | | cc: | | Subject: RE: JDBCAppender problem | >--------------------------------------------------------------------------- -----------------------------------| That's what I did see log4j.appender.dest3.sql=INSERT INTO ACTIVITYLOG(msg) VALUES(@MSG@) -----Original Message----- From: Steve.Lewis@ctimi.com [mailto:Steve.Lewis@ctimi.com] Sent: Tuesday, August 06, 2002 9:03 AM To: Log4J Users List Subject: Re: JDBCAppender problem You need "@msg@" or "@MSG@", not just "msg" you need to add the @'s. Thanks, Steve |---------+------------------------------> | | "Bhangale, Bhushan"| | | | | | | | | 08/06/2002 09:02 AM| | | Please respond to | | | "Log4J Users List" | | | | |---------+------------------------------> > --------------------------------------------------------------------------- -----------------------------------| | | | To: "'log4j-user@jakarta.apache.org'" | | cc: | | Subject: JDBCAppender problem | > --------------------------------------------------------------------------- -----------------------------------| Hi Everybody, I am trying to use JDBCAppender in 1.2.6 version of log4j. It is giving me following exception java.sql.SQLException: Must declare the variable '@MSG@' . Severity 15, State 2, Procedure 'GTSNY94 null', Line 1 at weblogic.jdbcbase.mssqlserver4.TdsStatement.processWarning(TdsStatement.java :1207) at weblogic.jdbcbase.mssqlserver4.TdsStatement.parseMsWarning(TdsStatement.java :1129) at weblogic.jdbcbase.mssqlserver4.TdsStatement.getMoreResults(TdsStatement.java :812) at weblogic.jdbcbase.mssqlserver4.TdsStatement.execute(TdsStatement.java:211) at weblogic.jdbcbase.mssqlserver4.TdsStatement.executeUpdate(TdsStatement.java: 94) 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(Append erAttachableImpl.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.debug(Category.java:241) at com.gtrade.vtbroker.main.VTBroker.start(VTBroker.java:53) at com.gtrade.vtbroker.main.VTBroker.main(VTBroker.java:36) Here is my log4j.properties part. ! WRITE TO DATABASE log4j.appender.dest3=org.apache.log4j.jdbc.JDBCAppender log4j.appender.dest3.driver=weblogic.jdbc.mssqlserver4.Driver log4j.appender.dest3.URL=jdbc:weblogic:mssqlserver4:VTBroker@172.26.2.208:14 33 log4j.appender.dest3.user=VTBroker log4j.appender.dest3.password=VTBroker log4j.appender.dest3.sql=INSERT INTO ACTIVITYLOG(msg) VALUES('VTBroker', @MSG@) Please help me. Thanks & Regards Bhushan Bhangale Sr. Software Engineer Fusion Infotech India Private Ltd. Ph. no. - 1-212-641-6932 (O) "The information in this e-mail, and any attachment therein, is confidential and for use by the addressee only. If you are not the intended recipient, please return the e-mail to the sender and delete it from your computer. Although The Bank of New York attempts to sweep e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses." -- To unsubscribe, e-mail: For additional commands, e-mail: -- NOTICE: This e-mail message and all attachments transmitted with it may contain legally privileged and confidential information intended solely for the use of the addressee. If the reader of this message is not the intended recipient, you are hereby notified that any reading, dissemination, distribution, copying, or other use of this message or its attachments, hyperlinks, or any other files of any kind is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone (865-218-2000) or by a reply to this electronic mail message and delete this message and all copies and backups thereof. -- To unsubscribe, e-mail: For additional commands, e-mail: "The information in this e-mail, and any attachment therein, is confidential and for use by the addressee only. If you are not the intended recipient, please return the e-mail to the sender and delete it from your computer. Although The Bank of New York attempts to sweep e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses." -- To unsubscribe, e-mail: For additional commands, e-mail: -- NOTICE: This e-mail message and all attachments transmitted with it may contain legally privileged and confidential information intended solely for the use of the addressee. If the reader of this message is not the intended recipient, you are hereby notified that any reading, dissemination, distribution, copying, or other use of this message or its attachments, hyperlinks, or any other files of any kind is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone (865-218-2000) or by a reply to this electronic mail message and delete this message and all copies and backups thereof. -- To unsubscribe, e-mail: For additional commands, e-mail: "The information in this e-mail, and any attachment therein, is confidential and for use by the addressee only. If you are not the intended recipient, please return the e-mail to the sender and delete it from your computer. Although The Bank of New York attempts to sweep e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses." -- To unsubscribe, e-mail: For additional commands, e-mail: