logging-log4net-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ping Xie <p...@caci.com>
Subject Re: Log4net seems to hang when starting up windows service
Date Mon, 24 Oct 2005 14:09:29 GMT
<FONT face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size=2><DIV><DIV>Hi,</DIV><DIV>&nbsp;</DIV><DIV>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. </DIV><DIV>&nbsp;</DIV><DIV>&lt;param name="Parameter"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;param name="ParameterName" value=":message" /&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;param name="DbType" value="String" /&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;param name="Layout" type="log4net.Layout.PatternLayout"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;param name="ConversionPattern" value="%m" /&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;/param&gt;<BR>&lt;/param&gt;<BR><BR>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).</DIV><DIV>&nbsp;</DIV><DIV><FONT
face="Courier New" size=1>log4net:ERROR [AdoNetAppender] Exception while writing to database<BR>System.Data.OracleClient.OracleException:
ORA-01461: can bind a LONG value only for insert into a LONG column</FONT><BR><BR><FONT
face="Courier New" size=1>&nbsp; &nbsp;at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle
errorHandle, Int32 rc)</FONT><BR><FONT face="Courier New" size=1>&nbsp;
&nbsp;at System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle, CommandBehavior
behavior, Boolean isReader, Boolean needRowid, OciHandle&amp; rowidDescriptor, ArrayList&amp;
refCursorParameterOrdinals)</FONT><BR><FONT face="Courier New" size=1>&nbsp;
&nbsp;at System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle, CommandBehavior
behavior, Boolean needRowid, OciHandle&amp; rowidDescriptor)</FONT><BR><FONT
face="Courier New" size=1>&nbsp; &nbsp;at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean
needRowid, OciHandle&amp; rowidDescriptor)</FONT><BR><FONT face="Courier
New" size=1>&nbsp; &nbsp;at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()</FONT><BR><FONT
face="Courier New" size=1>&nbsp; &nbsp;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</FONT><BR><FONT face="Courier New" size=1>&nbsp; &nbsp;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</FONT><BR></DIV><DIV>I wonder if DbType "String" is correct for
CLOB column. What should be used if it is not?</DIV><DIV>&nbsp;</DIV><DIV>Thanks
you in advance for your help.</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV><DIV>Ping
Xie<BR><BR>CACI<BR>4831 Walden Lane<BR>Lanham, MD 20706<BR><A
href="mailto:pxie@caci.com" target=blank >pxie@caci.com</A><BR>(301) 306-8200
- Main<BR>(301) 306-2829 - Direct<BR></DIV></DIV></FONT>This
electronic message contains information from CACI International Inc or subsidiary companies&#44;
which may be company sensitive&#44; proprietary&#44; 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&#44; be aware that any review&#44; disclosure&#44;
copying&#44; distribution or use of this transmission or its contents is prohibited. 
If you have received this transmission in error&#44; please notify us immediately at postmaster@caci.com.
With the exception of messages sent by authorized CACI contracts or purchasing personnel&#44;
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&#44; or (b) modify an existing contract.<br />
View raw message