Thank you Radovan, Trigger happy :)
Radovan Raszka wrote: > > Hello, I'm not sure if this is possible using only log4net infrastructure. > But you can use trigger on the logging table, which splits message text > and writes individual parts into individual columns. > Radovan Raszka > > -----Původní zpráva----- > Od: bhupigs [mailto:bhupendra.pa...@hotmail.com] > Odesláno: 8. prosince 2010 1:43 > Komu: log4net-user@logging.apache.org > Předmět: Split a Message > > > Hi, > > I have a third party application which uses log4net.So I have access only > to the config file. > > I have enabled using adonetappender and then redirecting my messages to a > SQL table. > However I need help with this. > The applcaition output message has five parts seperated by colons ":". > I want to be able to put these five parts in five columns in my SQL table. > My current coversion pattern puts the message as it is in one column. > > Here is a snippet of my Log4net.config file. > > <commandText value="INSERT INTO logtable(Message) VALUES (@message)" /> > <parameter> > <parameterName value="@message" /> > <dbType value="String" /> > <size value="1000" /> > <layout type="log4net.Layout.PatternLayout"> > <conversionPattern value="%message" /> > </layout> > </parameter> > > Help.. > > Thanks, > Bhupi > > -- > View this message in context: > http://old.nabble.com/Split-a-Message-tp30401732p30401732.html > Sent from the Log4net - Users mailing list archive at Nabble.com. > > > -- View this message in context: http://old.nabble.com/Split-a-Message-tp30401732p30406043.html Sent from the Log4net - Users mailing list archive at Nabble.com.
