Error using ADONetAppender
Hi, I'm try to log messages to Oracle database. I got the following debug errors when run my application. --- log4net:ERROR [ADONetAppender] Failed to load connection type [System.Data.Oracl eClient.OracleConnection,System.Data.OracleClient, Version=1.2.0.30714, Culture= neutral,PublicKeyToken=b32731d11ce58905] System.IO.FileLoadException: The located assembly's manifest definition with nam e 'System.Data.OracleClient' does not match the assembly reference. File name: "System.Data.OracleClient" at System.Type.GetType(String typeName, Boolean throwOnError) at log4net.Appender.ADONetAppender.ResolveConnectionType() === Pre-bind state information === LOG: DisplayName = System.Data.OracleClient, Version=1.2.0.30714, Culture=neutra l, PublicKeyToken=b32731d11ce58905 (Fully-specified) LOG: Appbase = C:\hv\HF Security\Log4net\log4net-1.2.0-beta8\examples\net\1.0\Tu torials\ConsoleApp\cs\build\debug\ LOG: Initial PrivatePath = NULL Calling assembly : log4net, Version=1.2.0.30714, Culture=neutral, PublicKeyToken =b32731d11ce58905. === LOG: Publisher policy file is not found. LOG: Host configuration file not found. LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v1 .1.4322\config\machine.config. LOG: Post-policy reference: System.Data.OracleClient, Version=1.2.0.30714, Cultu re=neutral, PublicKeyToken=b32731d11ce58905 LOG: Attempting download of new URL file:///C:/hv/HF Security/Log4net/log4net-1. 2.0-beta8/examples/net/1.0/Tutorials/ConsoleApp/cs/build/debug/System.Data.Oracl eClient.DLL. WRN: Comparing the assembly name resulted in the mismatch: Minor Version - The following is the ADONetAppender portion of my config file. Does anyone know what is wrong?param> param> param> param> param> param> param> param> param> appender>
RE: Error using ADONetAppender
> I'm try to log messages to Oracle database. I got the > following debug errors when run my application. > > -- > - > log4net:ERROR [ADONetAppender] Failed to load connection type > [System.Data.Oracl > eClient.OracleConnection,System.Data.OracleClient, > Version=1.2.0.30714, Culture= neutral,PublicKeyToken=b32731d11ce58905] > System.IO.FileLoadException: The located assembly's manifest > definition with nam e 'System.Data.OracleClient' does not > match the assembly reference. This means that the assembly specified in the config file for the OracleClient does not match the manifest of the System.Data.OracleClient.dll assembly found on disk. In the config file you have specified the ADO.NET provider to use as: System.Data.OracleClient.OracleConnection,System.Data.OracleClient, Version=1.2.0.30714, Culture=neutral,PublicKeyToken=b32731d11ce58905 The version number and public key are not correct for the System.Data.OracleClient assembly. Try the following: Version=1.0.3300.0 PublicKeyToken=b77a5c561934e089 If you still get the same error then you will need to find your System.Data.OracleClient assembly and find the correct version number and public key token from the file. You can get the version from the file properties dialog. To get the public key token you need to use sn.exe with the -t option. Sn.exe is shipped with the .net SDK in VisualStudio. Nicko > File name: "System.Data.OracleClient" >at System.Type.GetType(String typeName, Boolean throwOnError) >at log4net.Appender.ADONetAppender.ResolveConnectionType() > > === Pre-bind state information === > LOG: DisplayName = System.Data.OracleClient, > Version=1.2.0.30714, Culture=neutra l, PublicKeyToken=b32731d11ce58905 > (Fully-specified) > LOG: Appbase = C:\hv\HF > Security\Log4net\log4net-1.2.0-beta8\examples\net\1.0\Tu > torials\ConsoleApp\cs\build\debug\ > LOG: Initial PrivatePath = NULL > Calling assembly : log4net, Version=1.2.0.30714, > Culture=neutral, PublicKeyToken =b32731d11ce58905. > === > > LOG: Publisher policy file is not found. > LOG: Host configuration file not found. > LOG: Using machine configuration file from > C:\WINDOWS\Microsoft.NET\Framework\v1 > .1.4322\config\machine.config. > LOG: Post-policy reference: System.Data.OracleClient, > Version=1.2.0.30714, Cultu re=neutral, PublicKeyToken=b32731d11ce58905 > LOG: Attempting download of new URL file:///C:/hv/HF > Security/Log4net/log4net-1. > 2.0-beta8/examples/net/1.0/Tutorials/ConsoleApp/cs/build/debug > /System.Data.Oracl > eClient.DLL. > WRN: Comparing the assembly name resulted in the mismatch: > Minor Version > > -- > --- > > The following is the ADONetAppender portion of my config > file. Does anyone know what is wrong? > > -- > -- > type="log4net.Appender.ADONetAppender" > > value="System.Data.OracleClient.OracleConnection,System.Data.O > racleClient, Version=1.2.0.30714, > Culture=neutral,PublicKeyToken=b32731d11ce58905" /> > value="data source=[netbltsdb1];User ID=[docex];Password=[docex]" /> > value="INSERT INTO Log (Datetime, > Thread,Log_Level,Logger,Message) VALUES > (:log_date,:thread,:log_level,:logger,:message)" /> > > > value=":log_date" /> > > type="log4net.Layout.RawTimeStampLayout" /> > > > value=":thread" /> > > > type="log4net.Layout.PatternLayout"> > name="ConversionPattern" value="%t" /> > > > > value=":log_level" /> > > > type="log4net.Layout.PatternLayout"> > name="ConversionPattern" value="%p" /> > > > > value=":logger" /> > > > type="log4net.Layout.PatternLayout"> > name="ConversionPattern" value="%c" /> > > > > value=":message" /> > > > type="log4net.Layout.PatternLayout"> >
RE: Error using ADONetAppender
Nicko, Thank you very much for your response. I found out the version number and public key token of System.Data.OracleClient assembly and modified my configuration file. But I still got the same error. System.Data.OracleClient.dll is in C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322 directory of my machine. I had put this directory in the Path. I also tried to copy the dll to the application exe directory. It has the same result. I searched my machine. There is only one System.Data.OracleClient.dll. What else could be wrong? The following are my new config and result. Config - <appender name="ADONetAppender_Oracle" type="log4net.Appender.ADONetAppender" > <param name="ConnectionType" value="System.Data.OracleClient.OracleConnection, System.Data.OracleClient, Version=1.1.4322.573, Culture=neutral, PublicKeyToken=350c7afdc4c296b5" /> <param name="ConnectionString" value="data source=[proddevdatabase];User ID=[chris9];Password=[chris9]" /> <param name="CommandText" value="INSERT INTO Log (Datetime, Thread,Log_Level,Logger,Message) VALUES (:log_date,:thread,:log_level,:logger, :message)" /> <param name="BufferSize" value="128" /> <param name="Parameter"> .. - Result log4net:ERROR [ADONetAppender] Failed to load connection type [System.Data.Oracl eClient.OracleConnection, System.Data.OracleClient, Version=1.1.4322.573, Cultur e=neutral, PublicKeyToken=350c7afdc4c296b5] System.IO.FileNotFoundException: File or assembly name System.Data.OracleClient, or one of its dependencies, was not found. File name: "System.Data.OracleClient" at System.Type.GetType(String typeName, Boolean throwOnError) at log4net.Appender.ADONetAppender.ResolveConnectionType() === Pre-bind state information === LOG: DisplayName = System.Data.OracleClient, Version=1.1.4322.573, Culture=neutr al, PublicKeyToken=350c7afdc4c296b5 (Fully-specified) LOG: Appbase = C:\hv\HF Security\Log4net\log4net-1.2.0-beta8\examples\net\1.0\Tu torials\ConsoleApp\cs\build\debug\ LOG: Initial PrivatePath = NULL Calling assembly : log4net, Version=1.2.0.30714, Culture=neutral, PublicKeyToken =b32731d11ce58905. === I appreciate it. Ping Xie CACI 4831 Walden Lane Lanham, MD 20706 [EMAIL PROTECTED] (301) 306-8200 - Main (301) 306-2829 - Direct "Nicko Cadell" <[EMAIL PROTECTED]> 08/11/2004 09:36 AM Please respond to "Log4NET User" To: "Log4NET User" cc: Subject: RE: Error using ADONetAppender > I'm try to log messages to Oracle database. I got the > following debug errors when run my application. > > -- > - > log4net:ERROR [ADONetAppender] Failed to load connection type > [System.Data.Oracl > eClient.OracleConnection,System.Data.OracleClient, > Version=1.2.0.30714, Culture= neutral,PublicKeyToken=b32731d11ce58905] > System.IO.FileLoadException: The located assembly's manifest > definition with nam e 'System.Data.OracleClient' does not > match the assembly reference. This means that the assembly specified in the config file for the OracleClient does not match the manifest of the System.Data.OracleClient.dll assembly found on disk. In the config file you have specified the ADO.NET provider to use as: System.Data.OracleClient.OracleConnection,System.Data.OracleClient, Version=1.2.0.30714, Culture=neutral,PublicKeyToken=b32731d11ce58905 The version number and public key are not correct for the System.Data.OracleClient assembly. Try the following: Version=1.0.3300.0 PublicKeyToken=b77a5c561934e089 If you still get the same error then you will need to find your System.Data.OracleClient assembly and find the correct version number and public key token from the file. You can get the version from the file properties dialog. To get the public key token you need to use sn.exe with the -t option. Sn.exe is shipped with the .net SDK in VisualStudio. Nicko > File name: "System.Data.OracleClient" > at System.Type.GetType(String typeName, Boolean throwOnError) > at log4net.Appender.ADONetAppender.ResolveConnectionType() > > === Pre-bind state information === > LOG: DisplayName = System.Data.OracleClient, >
RE: Error using ADONetAppender
Looking at the assembly with the file system properties and the sn.exe tool seems to be giving a different set of results to the .NET Reflector. The .NET Reflector (http://www.aisto.com/roeder/dotnet) thinks that the strong name for the assembly is: System.Data.OracleClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 I am not sure why this is different to the Public key token displayed by sn.exe. Try the above details. Also the System.Data.OracleClient references the following DLLs: mtxoci8.dll oci.dll oramts.dll I am assuming that these either come with the OracleClient or are part of the Oracle client tools for windows. These DLLs need to be located either in the windows system32 directory or the application bin directory for the Windows DLL loader to find them. Nicko > -Original Message- > From: Ping Xie [mailto:[EMAIL PROTECTED] > Sent: 11 August 2004 16:23 > To: Log4NET User > Subject: RE: Error using ADONetAppender > > > Nicko, > > Thank you very much for your response. I found out the > version number and public key token of > System.Data.OracleClient assembly and modified my > configuration file. But I still got the same error. > > System.Data.OracleClient.dll is in > C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322 directory of my > machine. I had put this directory in the Path. I also tried > to copy the dll to the application exe directory. It has the > same result. I searched my machine. There is only one > System.Data.OracleClient.dll. What else could be wrong? > > The following are my new config and result. > > Config > -- > --- > type="log4net.Appender.ADONetAppender" > > value="System.Data.OracleClient.OracleConnection, > System.Data.OracleClient, Version=1.1.4322.573, > Culture=neutral, PublicKeyToken=350c7afdc4c296b5" /> > value="data source=[proddevdatabase];User > ID=[chris9];Password=[chris9]" /> > value="INSERT INTO Log (Datetime, > Thread,Log_Level,Logger,Message) VALUES > (:log_date,:thread,:log_level,:logger, :message)" /> > > .. > -- > --- > > > Result > -- > -- > log4net:ERROR [ADONetAppender] Failed to load connection type > [System.Data.Oracl eClient.OracleConnection, > System.Data.OracleClient, Version=1.1.4322.573, Cultur > e=neutral, PublicKeyToken=350c7afdc4c296b5] > System.IO.FileNotFoundException: File or assembly name > System.Data.OracleClient, or one of its dependencies, was not found. > File name: "System.Data.OracleClient" >at System.Type.GetType(String typeName, Boolean throwOnError) >at log4net.Appender.ADONetAppender.ResolveConnectionType() > > === Pre-bind state information === > LOG: DisplayName = System.Data.OracleClient, > Version=1.1.4322.573, Culture=neutr al, > PublicKeyToken=350c7afdc4c296b5 > (Fully-specified) > LOG: Appbase = C:\hv\HF > Security\Log4net\log4net-1.2.0-beta8\examples\net\1.0\Tu > torials\ConsoleApp\cs\build\debug\ > LOG: Initial PrivatePath = NULL > Calling assembly : log4net, Version=1.2.0.30714, > Culture=neutral, PublicKeyToken =b32731d11ce58905. > === > -- > -- > > I appreciate it. > > Ping Xie > > CACI > 4831 Walden Lane > Lanham, MD 20706 > [EMAIL PROTECTED] > (301) 306-8200 - Main > (301) 306-2829 - Direct > > > > > "Nicko Cadell" <[EMAIL PROTECTED]> > > 08/11/2004 09:36 AM > Please respond to "Log4NET User" > To:"Log4NET User" > cc: > Subject:RE: Error using ADONetAppender > > > > > > I'm try to log messages to Oracle database. I got the > following debug > > errors when run my application. > > > > -- > > - > > log4net:ERROR [ADONetAppender] Failed to load connection type > > [System.Data.Oracl > eClient.OracleConnection,System.Data.OracleClient, > > Version=1.2.0.30714, Culture= > neutral,PublicKeyToken=b32731d11ce58905] > > System.IO.FileLoadException: The located assembly's manifest > > definition with nam e 'Sy
RE: Error using ADONetAppender
Nicko, Thanks a lot for your help. The dll is successfully loaded using the version number and public key token given by .NET Reflector. Since oracle bin directory is in the system path in my machine, it works without copying them to the system32 directory. Thanks again. Ping "Nicko Cadell" <[EMAIL PROTECTED]> 08/11/2004 02:23 PM Please respond to "Log4NET User" To: "Log4NET User" cc: Subject: RE: Error using ADONetAppender Looking at the assembly with the file system properties and the sn.exe tool seems to be giving a different set of results to the .NET Reflector. The .NET Reflector (http://www.aisto.com/roeder/dotnet) thinks that the strong name for the assembly is: System.Data.OracleClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 I am not sure why this is different to the Public key token displayed by sn.exe. Try the above details. Also the System.Data.OracleClient references the following DLLs: mtxoci8.dll oci.dll oramts.dll I am assuming that these either come with the OracleClient or are part of the Oracle client tools for windows. These DLLs need to be located either in the windows system32 directory or the application bin directory for the Windows DLL loader to find them. Nicko > -Original Message- > From: Ping Xie [mailto:[EMAIL PROTECTED] > Sent: 11 August 2004 16:23 > To: Log4NET User > Subject: RE: Error using ADONetAppender > > > Nicko, > > Thank you very much for your response. I found out the > version number and public key token of > System.Data.OracleClient assembly and modified my > configuration file. But I still got the same error. > > System.Data.OracleClient.dll is in > C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322 directory of my > machine. I had put this directory in the Path. I also tried > to copy the dll to the application exe directory. It has the > same result. I searched my machine. There is only one > System.Data.OracleClient.dll. What else could be wrong? > > The following are my new config and result. > > Config > -- > --- > > type="log4net.Appender.ADONetAppender" > > > value="System.Data.OracleClient.OracleConnection, > System.Data.OracleClient, Version=1.1.4322.573, > Culture=neutral, PublicKeyToken=350c7afdc4c296b5" /> > > value="data source=[proddevdatabase];User > ID=[chris9];Password=[chris9]" /> > > value="INSERT INTO Log (Datetime, > Thread,Log_Level,Logger,Message) VALUES > (:log_date,:thread,:log_level,:logger, :message)" /> > > .. > -- > --- > > > Result > -- > -- > log4net:ERROR [ADONetAppender] Failed to load connection type > [System.Data.Oracl eClient.OracleConnection, > System.Data.OracleClient, Version=1.1.4322.573, Cultur > e=neutral, PublicKeyToken=350c7afdc4c296b5] > System.IO.FileNotFoundException: File or assembly name > System.Data.OracleClient, or one of its dependencies, was not found. > File name: "System.Data.OracleClient" > at System.Type.GetType(String typeName, Boolean throwOnError) > at log4net.Appender.ADONetAppender.ResolveConnectionType() > > === Pre-bind state information === > LOG: DisplayName = System.Data.OracleClient, > Version=1.1.4322.573, Culture=neutr al, > PublicKeyToken=350c7afdc4c296b5 > (Fully-specified) > LOG: Appbase = C:\hv\HF > Security\Log4net\log4net-1.2.0-beta8\examples\net\1.0\Tu > torials\ConsoleApp\cs\build\debug\ > LOG: Initial PrivatePath = NULL > Calling assembly : log4net, Version=1.2.0.30714, > Culture=neutral, PublicKeyToken =b32731d11ce58905. > === > -- > -- > > I appreciate it. > > Ping Xie > > CACI > 4831 Walden Lane > Lanham, MD 20706 > [EMAIL PROTECTED] > (301) 306-8200 - Main > (301) 306-2829 - Direct > > > > > "Nicko Cadell" <[EMAIL PROTECTED]> > > 08/11/2004 09:36 AM > Please respond to "Log4NET User" > To: "Log4NET User" > cc: > Subject: RE: Error using ADONetAppender > > > > > > I'm try to log messages to Oracle database. I got the > following d
Help inserting GUID using AdoNetAppender
I am trying to insert a uniqueidentifier (Guid) into a Sql Server table and am having problems. I'm using log4net-1.2.0-beta8. CREATE TABLE [dbo].[Log_Test1] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [DateTime] [datetime] NOT NULL , [RequestID] [uniqueidentifier] NOT NULL , [TaskID] [tinyint] NOT NULL , [State] [tinyint] NOT NULL ) ON [PRIMARY] On startup of the application, I get the following error. log4net: DOMConfigurator: Setting Collection Property [AddParameter] to object [log4net.Appender.ADONetAppenderParameter] log4net: DOMConfigurator: Setting Property [ParameterName] to String value [EMAIL PROTECTED] log4net:ERROR DOMConfigurator: Could not create Appender [MyDBAppender] of type[log4net.Appender.AdoNetAppender]. Reported error follows. System.ArgumentException: Requested value uniqueidentifier was not found. at System.Enum.Parse(Type enumType, String value, Boolean ignoreCase) at log4net.helpers.OptionConverter.ParseEnum(Type enumType, String value, Boolean ignoreCase) at log4net.helpers.OptionConverter.ConvertStringTo(Type target, String txt) at log4net.Repository.Hierarchy.DOMHierarchyConfigurator.ConvertStringTo(Type type, String value) at log4net.Repository.Hierarchy.DOMHierarchyConfigurator.SetParameter(XmlElement element, Object target) at log4net.Repository.Hierarchy.DOMHierarchyConfigurator.CreateObjectFromXml(XmlElement element, Type defaultTargetType, Type typeConstraint) at log4net.Repository.Hierarchy.DOMHierarchyConfigurator.SetParameter(XmlElement element, Object target) at log4net.Repository.Hierarchy.DOMHierarchyConfigurator.ParseAppender(XmlElement appenderElement) log4net:ERROR DOMConfigurator: Appender named [MyDBAppender] not found. If I change to Using "Guid" then it will load but then thrown an exception on insertion. log4net:ERROR [ADONetAppender] Exception while writing to database System.InvalidCastException: Invalid cast from System.String to System.Guid. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at log4net.Appender.ADONetAppender.SendBuffer(IDbTransaction dbTran, LoggingEvent[] events) at log4net.Appender.ADONetAppender.SendBuffer(LoggingEvent[] events) Any thoughts would be appreciated. Dave _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
RE: Help inserting GUID using AdoNetAppender
Have a look at the log4net.Layout.RawPropertyLayout class. I use that for my layout type, and still set the DbType to "Guid". I believe the log4net.Layout.RawPropertyLayout class was introduced in beta9, but you should be able to get it locally and incorporate it into your own build. At least that's what worked for me. ;) -Original Message- From: David Elliott [mailto:[EMAIL PROTECTED] Sent: Monday, April 11, 2005 1:43 PM To: log4net-user@logging.apache.org Subject: Help inserting GUID using AdoNetAppender I am trying to insert a uniqueidentifier (Guid) into a Sql Server table and am having problems. I'm using log4net-1.2.0-beta8. CREATE TABLE [dbo].[Log_Test1] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [DateTime] [datetime] NOT NULL , [RequestID] [uniqueidentifier] NOT NULL , [TaskID] [tinyint] NOT NULL , [State] [tinyint] NOT NULL ) ON [PRIMARY] On startup of the application, I get the following error. log4net: DOMConfigurator: Setting Collection Property [AddParameter] to object [log4net.Appender.ADONetAppenderParameter] log4net: DOMConfigurator: Setting Property [ParameterName] to String value [EMAIL PROTECTED] log4net:ERROR DOMConfigurator: Could not create Appender [MyDBAppender] of type[log4net.Appender.AdoNetAppender]. Reported error follows. System.ArgumentException: Requested value uniqueidentifier was not found. at System.Enum.Parse(Type enumType, String value, Boolean ignoreCase) at log4net.helpers.OptionConverter.ParseEnum(Type enumType, String value, Boolean ignoreCase) at log4net.helpers.OptionConverter.ConvertStringTo(Type target, String txt) at log4net.Repository.Hierarchy.DOMHierarchyConfigurator.ConvertStringTo(Ty pe type, String value) at log4net.Repository.Hierarchy.DOMHierarchyConfigurator.SetParameter(XmlEl ement element, Object target) at log4net.Repository.Hierarchy.DOMHierarchyConfigurator.CreateObjectFromXm l(XmlElement element, Type defaultTargetType, Type typeConstraint) at log4net.Repository.Hierarchy.DOMHierarchyConfigurator.SetParameter(XmlEl ement element, Object target) at log4net.Repository.Hierarchy.DOMHierarchyConfigurator.ParseAppender(XmlE lement appenderElement) log4net:ERROR DOMConfigurator: Appender named [MyDBAppender] not found. If I change to Using "Guid" then it will load but then thrown an exception on insertion. log4net:ERROR [ADONetAppender] Exception while writing to database System.InvalidCastException: Invalid cast from System.String to System.Guid. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at log4net.Appender.ADONetAppender.SendBuffer(IDbTransaction dbTran, LoggingEvent[] events) at log4net.Appender.ADONetAppender.SendBuffer(LoggingEvent[] events) Any thoughts would be appreciated. Dave _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
DbType for CLOB column using AdoNetAppender
Hi, I have sent the following email but used a wrong subject (by replying). I'm resending it. Thanks.Hi, I'm using AdoNetAppender to log to an Oracle 10g database. There is a CLOB column used to store diagnosis message with stack trace if there is any. The following config is used for this column. When the size of message is greater than 2000 characters, the following exception is thrown (It works fine if the size is less than or equel to 2000). log4net:ERROR [AdoNetAppender] Exception while writing to database System.Data.OracleClient.OracleException: ORA-01461: can bind a LONG value only for insert into a LONG column at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc) at System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle, CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle& rowidDescriptor, ArrayList& refCursorParameterOrdinals) at System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciHandle& rowidDescriptor) at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciHandle& rowidDescriptor) at System.Data.OracleClient.OracleCommand.ExecuteNonQuery() at log4net.Appender.AdoNetAppender.SendBuffer(IDbTransaction dbTran, LoggingEvent[] events) in c:\Work\cvs_root\apache\r1.2.9\logging-log4net\build\package\log4net-1.2.9-beta\src\Appender\AdoNetAppender.cs:line 550 at log4net.Appender.AdoNetAppender.SendBuffer(LoggingEvent[] events) in c:\Work\cvs_root\apache\r1.2.9\logging-log4net\build\package\log4net-1.2.9-beta\src\Appender\AdoNetAppender.cs:line 460 I wonder if DbType "String" is correct for CLOB column. What should be used if it is not? Thanks you in advance for your help. Ping Xie CACI 4831 Walden Lane Lanham, MD 20706 [EMAIL PROTECTED] (301) 306-8200 - Main (301) 306-2829 - Direct Ping XieCACI4831 Walden LaneLanham, MD 20706[EMAIL PROTECTED](301) 306-8200 - Main(301) 306-2829 - DirectThis electronic message contains information from CACI International Inc or subsidiary companies, which may be company sensitive, proprietary, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named above. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify us immediately at [EMAIL PROTECTED] With the exception of messages sent by authorized CACI contracts or purchasing personnel, nothing in this message may be interpreted as a digital or electronic signature that can be used to: (a) authenticate either the submission or the acceptance of a proposal or offer to contract, or (b) modify an existing contract.