Author: sdeboy
Date: Thu Jul 3 10:49:08 2008
New Revision: 673744
URL: http://svn.apache.org/viewvc?rev=673744&view=rev
Log:
Update the customsqldbreceiver javadoc to make it even more clear that the
user's db columns don't have to have the same name/contain all of the same
columns (can be ALIASed).
Modified:
logging/log4j/companions/receivers/trunk/src/main/java/org/apache/log4j/db/CustomSQLDBReceiver.java
Modified:
logging/log4j/companions/receivers/trunk/src/main/java/org/apache/log4j/db/CustomSQLDBReceiver.java
URL:
http://svn.apache.org/viewvc/logging/log4j/companions/receivers/trunk/src/main/java/org/apache/log4j/db/CustomSQLDBReceiver.java?rev=673744&r1=673743&r2=673744&view=diff
==============================================================================
---
logging/log4j/companions/receivers/trunk/src/main/java/org/apache/log4j/db/CustomSQLDBReceiver.java
(original)
+++
logging/log4j/companions/receivers/trunk/src/main/java/org/apache/log4j/db/CustomSQLDBReceiver.java
Thu Jul 3 10:49:08 2008
@@ -119,11 +119,12 @@
* or save the events to XML for later analysis.
* <p>
* Here is a complete MySQL SQL statement which can be used to provide events
to
- * Chainsaw:
+ * Chainsaw (note how in the example below, there is no column in logtable
representing the throwable, so an
+ * empty string is passed in and an ALIAS is still defined):
* <p>
- * select logger as LOGGER, timestamp as TIMESTAMP, level as LEVEL, thread as
- * THREAD, message as MESSAGE, ndc as NDC, mdc as MDC, class as CLASS, method
as
- * METHOD, file as FILE, line as LINE,
+ * select myloggercolumn as LOGGER, mytimestampcolumn as TIMESTAMP,
mylevelcolumn as LEVEL, mythreadcolumn as
+ * THREAD, mymessagecolumn as MESSAGE, myndccolumn as NDC, mymdccolumn as MDC,
myclasscolumn as CLASS, mymethodcolumn as
+ * METHOD, myfilecolumn as FILE, mylinecolumn as LINE,
* concat("{{application,databaselogs,hostname,mymachine, log4jid,",
* COUNTER,"}}") as PROPERTIES, "" as THROWABLE from logtable
* <p>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
