RE: CustomSQLDBReceiver not working correctly. Where can I find the code for it?

2006-05-12 Thread Scott Deboy
Great! By the way, Chainsaw should handle sorting for you if you choose a sort column - I think it sorts by default on the ID column (I was surprised to hear you needed to sort your resultset - maybe with this change you would no longer have to). Scott -Original Message- From: Mostrom,

RE: CustomSQLDBReceiver not working correctly. Where can I find the code for it?

2006-05-12 Thread Mostrom, Edward
After getting the source and putting in debug statements I found the problem. The code is not trimming the properties value/pairs. In my sql I had: hostname, 116, log4jid,' || CAST(COUNTER AS varchar(255)) With the space before log4jid the program was comparing " log4jid" with "log4jid" and cl

RE: CustomSQLDBReceiver not working correctly. Where can I find the code for it?

2006-05-12 Thread Mostrom, Edward
Thanks. I did finally get it to sort by using a sub query. In case anyone is interested in how to set up a custom db receiver for Oracle this is what I used. It still gets everything on an update and not just the new events so I'll look at the code and see why it might be doing that.

RE: CustomSQLDBReceiver not working correctly. Where can I find the code for it?

2006-05-12 Thread Scott Deboy
The SVN repository was down for a couple of days. Here's a link to the latest revision of CustomSQLDBReceiver. As always, patches are always appreciated! http://svn.apache.org/viewcvs.cgi/logging/log4j/trunk/src/java/org/apach e/log4j/db/CustomSQLDBReceiver.java?view=markup Scott -Original

RE: [BULK] how to print line number

2006-05-12 Thread Jacob Kjome
Shiby, please see the following thread. It provides exactly the info you need. http://marc.theaimsgroup.com/?t=11450579171&r=1&w=2 Jake Quoting Philip Denno <[EMAIL PROTECTED]>: > The approach you are taking is called using a "wrapper class". > > You need to use the generic "log" method

Re: how to print line number

2006-05-12 Thread Curt Arnold
On May 12, 2006, at 1:53 AM, Shiby Maria John wrote: Hi, I have a framework that implements the logging by log4j. Now my classes need to log using this and I need to print the line number from where the log originally originated from. ... 11 : public void debug(String message) { 12 :

RE: [BULK] how to print line number

2006-05-12 Thread Philip Denno
The approach you are taking is called using a "wrapper class". You need to use the generic "log" methods on Logger. See the Javadoc. Basically, what these methods do is do a backtrace on the call - stack to find the method which called your wrapper method. One thing to keep in mind is that thes

Re: Stuck with file format!!!

2006-05-12 Thread James Stauffer
For log4j 1.2 you would need to create a new FileAppender class. On 5/11/06, Kailash KN <[EMAIL PROTECTED]> wrote: Thanks Dirk and James, but i use a property file not an XML file, anyways ill give it a shot. james, i did not understand your reply, could be please be more precise. Thanks & Reg

RE: why my logger doesn't get executed??

2006-05-12 Thread Zheng Wen Zhe
Jake. You're absolutely right. It's working perfectly now. I was putting log4j.xml in directory /WEB-INF. and cause tomcat server not packing up it. Thanks a million!! Jason -Original Message- From: Jacob Kjome [mailto:[EMAIL PROTECTED] Sent: 11 May 2006 22:34 To: Log4J Users List Subjec