Hey Peeps,
I just wanted to update this issues I had. I did find the solution using
Oracle 8i and the ADONetAppender. The problem was in the providers
converssion. I updated the insert stmt and it worked fine see the insert
stmt below.
<appender threshold="ERROR" name="AdoNetAppender_Oracle"
type="log4net.Appender.AdoNetAppender">
<connectionType value ="System.Data.OracleClient.OracleConnection,
System.Data.OracleClient, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089" />
<connectionString value="data source=*******;User
ID=*******;Password=**********" />
<commandText value="INSERT INTO Log (Log_Level,Logger,Message) VALUES
(Translate(:log_level using CHAR_CS), Translate(:logger using CHAR_CS),
Translate(:message using CHAR_CS))" />
<bufferSize value="1" />
<parameter>
<parameterName value=":log_level" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%level" />
</layout>
</parameter>
<parameter>
<parameterName value=":logger" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%logger" />
</layout>
</parameter>
<parameter>
<parameterName value=":message" />
<dbType value="String" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%message" />
</layout>
</parameter>
</appender>
_______________________________________________________________________
Hello All,
I am running into an issue with the ADONetAppender and writing to an
oracle 8i database. When the query attempts to run I get the following
error.
System.Data.OracleClient.OracleException: ORA-12704: character set
mismatch This is proving to be a harder problem to solve then I though.
Here is my config or at least the appropriate sections. It appears it is
having some trouble with the conversion to a varchar2 in the oracle
database. Anyone seen this? Also if I hard code the values as such it
works fine. So something must be happening on the Prepared statement
bind that is causing probs.
<commandText value=3D"INSERT INTO Log (Log_Level,Logger,Message) VALUES
('asdfasfasdf', 'asdfasfasdf', 'asdfasfasdf')" />
Table def.
CREATE TABLE LOG
(
THREAD VARCHAR2(255),
LOG_LEVEL VARCHAR2(255),
LOGGER VARCHAR2(255),
MESSAGE VARCHAR2(4000)
)
Log4net.config
<appender threshold=3D"ERROR" name=3D"AdoNetAppender_Oracle"
type=3D"log4net.Appender.AdoNetAppender">
<connectionType value =3D"System.Data.OracleClient.OracleConnection,
System.Data.OracleClient, Version=3D1.0.5000.0, Culture=3Dneutral,
PublicKeyToken=3Db77a5c561934e089" /> <connectionString value=3D"data
source=3DCDB08;User ID=0000000;Password=00000000" /> <commandText
value=3D"INSERT INTO Log (Log_Level,Logger,Message) VALUES (:log_level,
:logger, :message)" /> <bufferSize value=3D"1" /> <parameter>
<parameterName value=3D":log_level" /> <layout
type=3D"log4net.Layout.PatternLayout">
<conversionPattern value=3D"%level" />
</layout>
</parameter>
<parameter>
<parameterName value=3D":logger" />
<layout type=3D"log4net.Layout.PatternLayout">
<conversionPattern value=3D"%logger" />
</layout>
</parameter>
<parameter>
<parameterName value=3D":message" />
<dbType value=3D"String" />
<layout type=3D"log4net.Layout.PatternLayout">
<conversionPattern value=3D"%message" />
</layout>
</parameter>
</appender>
