You are viewing a plain text version of this content. The canonical link for it is here.
Posted to log4net-user@logging.apache.org by "Esterbrooks, Brette" <BG...@landolakes.com> on 2005/07/12 16:42:14 UTC

ADONetAppender and Oracle 8i ORA-12704: character set mismatch

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=3DLOL_EXCP_DB;Password=3Dtechie1" /> <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>
Brette Esterbrooks

Brette Esterbrooks
Land O'Lakes E-Business 
651-766-1436