I had followed the instructions to loading the config
file. I had the error encountered attached.
It seems that the SQLreceiver class cannot be found.
The program was run using the provided chainsaw.bat.
Thanks
--- Scott Deboy <[EMAIL PROTECTED]> wrote:
> 1. The file-load menu items are provided as a way to
> process a log file created by a file appender
> configured to use XMLLayout.
>
> Instead, configure Chainsaw this way:
>
> Open Chainsaw
> Select the view-show application wide preferences
> menu
>
> In the 'automatic configuration url' field at the
> bottom, specify the URL to your config file.
> Example: file:///c:/mysql-chainsaw-config.xml
>
> Restart Chainsaw
>
> 2. Chainsaw does support custom fields and
> CustomSQLDBReceiver provides a way to pass them to
> Chainsaw. Customsqldbreceiver expects all
> properties to be combined into a single string and
> returned as the PROPERTIES field in the SQL
> statement. This field is then parsed into the
> individual properties, thus the need for concat.
> Ugly but it works. If you feel like contributing a
> patch to improve the receiver in this area, please
> do!
>
> 3. There is a JNDIConnectionSource, which can be
> pooled. See
>
http://logging.apache.org/log4j/docs/api-1.3/org/apache/log4j/db/JNDIConnectionSource.html
>
> Scott
>
> -----Original Message-----
> From: Tan Kah Siong [mailto:[EMAIL PROTECTED]
> Sent: Tue 6/14/2005 2:12 AM
> To: [email protected]
> Cc:
> Subject: CustomSQLDBReceiver
> Hi,
>
> I am interested in using my mssql server as a base
> for
> Chainsaw log viewer.
>
> I had tried to do this after reading the
> documentation
> and encountered the following problems and
> questions.
>
> I had edited the Example Receiver configuration by
> deleting away all plugins except CustomDBReceiver. I
> also changed the connection source's password, user,
> driver and url to my requirements. Lastly i used a
> sql
> statement that would utilise the compulsary fields
> as
> stated in the documentation, without the concat
> part.
> The sql server i used is setup with the
> corresponding
> fields.
>
> I fired up ChainSaw and loaded the edited xml file
> through the "Load Log4J File" menu, however, nothing
> happens after that, no loading nor errors. I also
> see
> no network activity that indicates attempts to
> contact
> sql server.
>
> 1) Is there any step i missed or gone wrong?
>
> 2) I noted that chainsaw support only the documented
> fields, can it support other custom fields. ?Using
> concat?
>
> 3) How would i use pooled connections with ChainSaw?
>
> Please advice.
>
>
>
> __________________________________
> Discover Yahoo!
> Use Yahoo! to plan a weekend, have fun online and
> more. Check it out!
> http://discover.yahoo.com/
>
>
---------------------------------------------------------------------
> 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]
__________________________________
Discover Yahoo!
Get on-the-go sports scores, stock quotes, news and more. Check it out!
http://discover.yahoo.com/mobile.htmlUsing font=Arial
*** configurationOptionStr=null
** End of LogManager static initializer
log4j:INFO Creating new logger [org.apache.log4j.chainsaw.LogUI] in repository
[default].
log4j:INFO Creating new logger
[org.apache.log4j.chainsaw.plugins.PluginClassLoaderFactory] in repository
[default].
log4j:INFO Returning existing logger [org.apache.log4j] in repository [default].
log4j:INFO Creating new logger
[org.apache.log4j.joran.action.ConfigurationAction] in repository [default].
0 [main] ERROR org.apache.log4j.varia.ListAppender - Attempted to log with
inactive appender named [TEMP_LIST_APPENDER].
LOG4J-INTERNAL: 2005-06-15 08:39:35,371 DEBUG [main]
org.apache.log4j.joran.action.ConfigurationAction#begin:42)- Starting internal
logs on console.
log4j:INFO Creating new logger [org.apache.log4j.joran.action.AppenderAction]
in repository [default].
0 [main] ERROR org.apache.log4j.varia.ListAppender - Attempted to log with
inactive appender named [TEMP_LIST_APPENDER].
LOG4J-INTERNAL: 2005-06-15 08:39:35,371 DEBUG [main]
org.apache.log4j.joran.action.AppenderAction#begin:52)- About to instantiate
appender of type [org.apache.log4j.ConsoleAppender]
16 [main] ERROR org.apache.log4j.varia.ListAppender - Attempted to log with
inactive appender named [TEMP_LIST_APPENDER].
LOG4J-INTERNAL: 2005-06-15 08:39:35,387 DEBUG [main]
org.apache.log4j.joran.action.AppenderAction#begin:67)- Appender named as [A2]
LOG4J-INTERNAL: 2005-06-15 08:39:35,387 DEBUG [main]
org.apache.log4j.joran.action.AppenderAction#begin:78)- Pushing appender on to
the object stack.
log4j:INFO Creating new logger [org.apache.log4j.joran.action.LayoutAction] in
repository [default].
LOG4J-INTERNAL: 2005-06-15 08:39:35,387 DEBUG [main]
org.apache.log4j.joran.action.LayoutAction#begin:45)- About to instantiate
layout of type [org.apache.log4j.SimpleLayout]
LOG4J-INTERNAL: 2005-06-15 08:39:35,387 DEBUG [main]
org.apache.log4j.joran.action.LayoutAction#begin:56)- Pushing layout on top of
the object stack.
LOG4J-INTERNAL: 2005-06-15 08:39:35,387 DEBUG [main]
org.apache.log4j.joran.action.LayoutAction#end:86)- Popping layout from the
object stack
LOG4J-INTERNAL: 2005-06-15 08:39:35,387 DEBUG [main]
org.apache.log4j.joran.action.LayoutAction#end:90)- About to set the layout of
the containing appender.
LOG4J-INTERNAL: 2005-06-15 08:39:35,387 DEBUG [main]
org.apache.log4j.joran.action.AppenderAction#end:110)- Popping appender named
[A2] from the object stack
log4j:INFO Creating new logger [org.apache.log4j.joran.action.PluginAction] in
repository [default].
LOG4J-INTERNAL: 2005-06-15 08:39:35,387 DEBUG [main]
org.apache.log4j.joran.action.PluginAction#begin:44)- About to instantiate
plugin of type [org.apache.log4j.db.CustomSQLDBReceiver]
log4j:INFO Creating new logger [org.apache.log4j.helpers.OptionConverter] in
repository [default].
LOG4J-INTERNAL: 2005-06-15 08:39:35,403 ERROR [main]
org.apache.log4j.helpers.OptionConverter#instantiateByClassName:363)- Could not
instantiate object of class [org.apache.log4j.db.CustomSQLDBReceiver].
java.lang.ClassNotFoundException: org.apache.log4j.db.CustomSQLDBReceiver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.apache.log4j.helpers.Loader.loadClass(Loader.java:162)
at
org.apache.log4j.helpers.OptionConverter.instantiateByClassName(OptionConverter.java:340)
at
org.apache.log4j.joran.action.PluginAction.begin(PluginAction.java:47)
at
org.apache.log4j.joran.spi.Interpreter.callBeginAction(Interpreter.java:239)
at
org.apache.log4j.joran.spi.Interpreter.startElement(Interpreter.java:131)
at
org.apache.log4j.joran.spi.JoranDocument$StartElementEvent.replay(JoranDocument.java:225)
at
org.apache.log4j.joran.spi.JoranDocument.replay(JoranDocument.java:113)
at
org.apache.log4j.joran.JoranConfigurator.doConfigure(JoranConfigurator.java:170)
at
org.apache.log4j.joran.JoranConfigurator.doConfigure(JoranConfigurator.java:89)
at
org.apache.log4j.chainsaw.LogUI.loadConfigurationUsingPluginClassLoader(LogUI.java:1846)
at org.apache.log4j.chainsaw.LogUI.createChainsawGUI(LogUI.java:314)
at org.apache.log4j.chainsaw.LogUI.main(LogUI.java:250)
LOG4J-INTERNAL: 2005-06-15 08:39:35,403 ERROR [main]
org.apache.log4j.joran.action.PluginAction#begin:70)- Could not create a
plugin. Reported error follows.
java.lang.NullPointerException
at
org.apache.log4j.joran.action.PluginAction.begin(PluginAction.java:57)
at
org.apache.log4j.joran.spi.Interpreter.callBeginAction(Interpreter.java:239)
at
org.apache.log4j.joran.spi.Interpreter.startElement(Interpreter.java:131)
at
org.apache.log4j.joran.spi.JoranDocument$StartElementEvent.replay(JoranDocument.java:225)
at
org.apache.log4j.joran.spi.JoranDocument.replay(JoranDocument.java:113)
at
org.apache.log4j.joran.JoranConfigurator.doConfigure(JoranConfigurator.java:170)
at
org.apache.log4j.joran.JoranConfigurator.doConfigure(JoranConfigurator.java:89)
at
org.apache.log4j.chainsaw.LogUI.loadConfigurationUsingPluginClassLoader(LogUI.java:1846)
at org.apache.log4j.chainsaw.LogUI.createChainsawGUI(LogUI.java:314)
at org.apache.log4j.chainsaw.LogUI.main(LogUI.java:250)
log4j:INFO Creating new logger [org.apache.log4j.joran.spi.Interpreter] in
repository [default].
LOG4J-INTERNAL: 2005-06-15 08:39:35,418 WARN [main]
org.apache.log4j.joran.spi.Interpreter#startElement:138)- no applicable action
for <connectionSource>, current pattern is
[/configuration/plugin/connectionSource]
log4j:INFO Creating new logger [org.apache.log4j.joran.action.ParamAction] in
repository [default].
LOG4J-INTERNAL: 2005-06-15 08:39:35,418 DEBUG [main]
org.apache.log4j.joran.action.ParamAction#begin:61)- In ParamAction setting
parameter [password] to value [].
47 [main] WARN org.apache.log4j.config.PropertySetter - No such property
[password] in org.apache.log4j.Hierarchy.
LOG4J-INTERNAL: 2005-06-15 08:39:35,418 DEBUG [main]
org.apache.log4j.joran.action.ParamAction#begin:61)- In ParamAction setting
parameter [user] to value [sa].
47 [main] WARN org.apache.log4j.config.PropertySetter - No such property [user]
in org.apache.log4j.Hierarchy.
LOG4J-INTERNAL: 2005-06-15 08:39:35,418 DEBUG [main]
org.apache.log4j.joran.action.ParamAction#begin:61)- In ParamAction setting
parameter [driverClass] to value [com.microsoft.jdbc.sqlserver.SQLServerDriver].
47 [main] WARN org.apache.log4j.config.PropertySetter - No such property
[driverClass] in org.apache.log4j.Hierarchy.
LOG4J-INTERNAL: 2005-06-15 08:39:35,418 DEBUG [main]
org.apache.log4j.joran.action.ParamAction#begin:61)- In ParamAction setting
parameter [url] to value
[jdbc:microsoft:sqlserver://MYCOMP:1433;DatabaseName=loggingServer;SelectMethod=cursor].
47 [main] WARN org.apache.log4j.config.PropertySetter - No such property [url]
in org.apache.log4j.Hierarchy.
LOG4J-INTERNAL: 2005-06-15 08:39:35,418 DEBUG [main]
org.apache.log4j.joran.action.ParamAction#begin:61)- In ParamAction setting
parameter [refreshMillis] to value [2000].
47 [main] WARN org.apache.log4j.config.PropertySetter - No such property
[refreshMillis] in org.apache.log4j.Hierarchy.
LOG4J-INTERNAL: 2005-06-15 08:39:35,418 DEBUG [main]
org.apache.log4j.joran.action.ParamAction#begin:61)- In ParamAction setting
parameter [sql] to value [select logger as LOGGER, timestamp1 as TIMESTAMP,
level1 as LEVEL, thread as THREAD, message as MESSAGE, ndc as NDC, mdc as MDC,
class as CLASS, method as METHOD, file1 as FILE, line as LINE,
concat("{{application,databaselogs,hostname,mymachine,log4jid,", COUNTER, "}}")
as PROPERTIES, "" as EXCEPTION from logging].
47 [main] WARN org.apache.log4j.config.PropertySetter - No such property [sql]
in org.apache.log4j.Hierarchy.
LOG4J-INTERNAL: 2005-06-15 08:39:35,418 DEBUG [main]
org.apache.log4j.joran.action.ParamAction#begin:61)- In ParamAction setting
parameter [IDField] to value [COUNTER].
47 [main] WARN org.apache.log4j.config.PropertySetter - No such property
[IDField] in org.apache.log4j.Hierarchy.
log4j:INFO Creating new logger [org.apache.log4j.joran.action.RootLoggerAction]
in repository [default].
LOG4J-INTERNAL: 2005-06-15 08:39:35,418 DEBUG [main]
org.apache.log4j.joran.action.RootLoggerAction#begin:43)- Pushing root logger
on stack
log4j:INFO Creating new logger [org.apache.log4j.joran.action.LevelAction] in
repository [default].
LOG4J-INTERNAL: 2005-06-15 08:39:35,418 DEBUG [main]
org.apache.log4j.joran.action.LevelAction#begin:45)- Encapsulating logger name
is [root], levelvalue is [debug].
LOG4J-INTERNAL: 2005-06-15 08:39:35,418 DEBUG [main]
org.apache.log4j.joran.action.LevelAction#begin:76)- root level set to DEBUG
LOG4J-INTERNAL: 2005-06-15 08:39:35,418 DEBUG [main]
org.apache.log4j.joran.action.RootLoggerAction#end:61)- Removing root logger
from top of stack.
LOG4J-INTERNAL: 2005-06-15 08:39:35,418 DEBUG [main]
org.apache.log4j.joran.action.ConfigurationAction#end:49)- Will stop writing
internal logs on console.
log4j:INFO Returning existing logger [org.apache.log4j] in repository [default].
log4j:INFO Creating new logger [org.apache.log4j.joran.JoranConfigurator] in
repository [default].
log4j:INFO Returning existing logger [org.apache.log4j] in repository [default].
log4j:INFO Creating new logger [org.apache.log4j.chainsaw.help.HelpLocator] in
repository [default].
log4j:INFO Creating new logger [org.apache.log4j.chainsaw.help.HelpManager] in
repository [default].
log4j:INFO Creating new logger
[org.apache.log4j.chainsaw.receivers.ReceiversHelper] in repository [default].
log4j:INFO Creating new logger
[org.apache.log4j.chainsaw.receivers.PluginPropertyEditorPanel] in repository
[default].
log4j:INFO Creating new logger
[org.apache.log4j.chainsaw.receivers.ReceiversPanel] in repository [default].
log4j:INFO Creating new logger [org.apache.log4j.ConsoleAppender] in repository
[default].
log4j:INFO Creating new logger
[org.apache.log4j.chainsaw.receivers.ReceiversTreeModel] in repository
[default].
log4j:INFO Creating new logger
[org.apache.log4j.chainsaw.icons.LineIconFactory] in repository [default].
log4j:INFO Creating new logger [org.apache.log4j.chainsaw.FileLoadAction] in
repository [default].
log4j:INFO Creating new logger [org.apache.log4j.xml.SAXErrorHandler] in
repository [default].
log4j:INFO Returning existing logger [org.apache.log4j.xml.SAXErrorHandler] in
repository [default].
log4j:INFO Returning existing logger [org.apache.log4j.xml.SAXErrorHandler] in
repository [default].
log4j:INFO Returning existing logger [org.apache.log4j.xml.SAXErrorHandler] in
repository [default].
log4j:INFO Creating new logger [org.apache.log4j.rule.RuleFactory] in
repository [default].
log4j:INFO Creating new logger [org.apache.log4j.chainsaw.dnd.FileDnDTarget] in
repository [default].
log4j:INFO Creating new logger
[org.apache.log4j.chainsaw.ApplicationPreferenceModelPanel] in repository
[default].
log4j:INFO Creating new logger
[org.apache.log4j.chainsaw.messages.MessageCenter] in repository [default].
844 [main] ERROR org.apache.log4j.varia.ListModelAppender - Attempted to log
with inactive appender named [null].
844 [main] ERROR org.apache.log4j.chainsaw.LogUI$12 - Attempted to log with
inactive appender named [null].
Wanting to add a row, but GUI not initialized, waiting...
log4j:INFO Creating new logger
[org.apache.log4j.chainsaw.NoReceiversWarningPanel] in repository [default].
log4j:INFO Creating new logger
[org.apache.log4j.chainsaw.LogPanelPreferenceModel] in repository [default].
log4j:INFO Creating new logger [org.apache.log4j.chainsaw.LogPanel] in
repository [default].
log4j:INFO Creating new logger
[org.apache.log4j.chainsaw.ChainsawCyclicBufferTableModel] in repository
[default].
log4j:INFO Creating new logger
[org.apache.log4j.chainsaw.LogPanelLoggerTreeModel] in repository [default].
log4j:INFO Creating new logger [org.apache.log4j.chainsaw.LoggerNameTreePanel]
in repository [default].
log4j:INFO Creating new logger [com.mycompany.mylogger] in repository [default].
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
