RE: ADONetAppender

Pass the name of the System.Data.DbType enum value that you would pass
to the OracleParameter.DbType.OracleParameter.DbType for the prepared
statement parameter.

I don't use Oracle but I would guess that String or AnsiString and
Decimal are the values to use.

Nicko

> -----Original Message-----
> From: Ping Xie [mailto:pxie@xxxxxxxx] 
> Sent: 17 February 2005 16:47
> To: Log4NET User
> Cc: Log4NET User
> Subject: Re: ADONetAppender
> 
> 
> Sorry that I forgot to mention that I'm using ADONetAppender 
> to log to Oracle 9i database. In log4net configuration file, 
> there is a <param..>...</param> block for each database 
> column, something like listed below. 
> 
> <param name="Parameter"> 
>         <param name="ParameterName" value=":thread" /> 
>         <param name="DbType" value="String" /> 
>         <param name="Size" value="255" /> 
>         <param name="Layout" type="log4net.Layout.PatternLayout"> 
>                 <param name="ConversionPattern" value="%t" /> 
>         </param>
> </param> 
> 
> If I need to log to CLOB and NUMBER columns, what are the 
> values for the DbType and Size entries? 
> 
> Thank you. 
> 
> Ping Xie
> 
> CACI
> 4831 Walden Lane
> Lanham, MD 20706
> pxie@xxxxxxxx
> (301) 306-8200 - Main
> (301) 306-2829 - Direct
> 
> 
> 
> 
> Ping Xie <pxie@xxxxxxxx> 
> 
> 02/17/2005 07:41 AM
> Please respond to
> "Log4NET User" <log4net-user@xxxxxxxxxxxxxxxxxx>
> 
> To
> "Log4NET User" <log4net-user@xxxxxxxxxxxxxxxxxx> cc Subject 
> ADONetAppender
> 
>       
> 
> 
> 
> 
> 
> Hi, 
> 
> If I want to write logging to a CLOB and NUMBER columns, how 
> should I define the parameters in the configuration file? 
> Specifically, what are the values in the following two lines? 
> 
> <param name="DbType" value="?????" />
> <param name="Size" value="????" /> 
> 
> Thank you in advance. 
> 
> Ping Xie
> 
> CACI
> 4831 Walden Lane
> Lanham, MD 20706
> pxie@xxxxxxxx
> (301) 306-8200 - Main
> (301) 306-2829 - Direct 
> 
> 
>