AdoNetAppender and Clob field

Question

I have a asp.net 3.5 app that is using log4Net and AdoNetAppender. Currently the app uses a message field just like the log4net documentation http://logging.apache.org/log4net/release/config-examples.html. I would like to convert the field from varchar2 to Clob. I was trying to find some documentation on how to do this. All I could find is:

http://old.nabble.com/DbType-for-CLOB-column-using-AdoNetAppender-td1214036.html#a1214036

which wasn't too useful. Does anyone know a link or some samples on how to use a Clob file with a AdoNetAppender?

Thanks, Bill N

Answer 1

Did you try this:

http://marc.info/?l=log4net-user&m=110874200319166

basically you need to set the DbType to string and remove the Size parameter. Apparently this does not work correctly for nvarchar(max) (see here) but that does not mean it will not work for Clob.