Nlog don't log on Oracle database

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Nlog don't log on Oracle database

harry180
Hi,
I just maked to nlog work with mssql2008 but i also need to make this work for oracle database.
My nlog.config seems to be fine (used this site: http://nlog-project.org/help/NLog.Targets.DatabaseTarget.html)

my target :
<target name="database" xsi:type="Database" useTransactions="true"
              connectionString="DATA SOURCE=192.168.100.13;USER ID=API;PASSWORD=api"
              keepConnection="true" dbProvider="System.Data.OracleClient.OracleConnection,System.Data.OracleClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
              commandText="insert into Log_1(DATETIME,LEVEL, MESSAGE, LOGGER) values(:DATETIME_1, :LEVEL, :MESSAGE, :LOGGER)">       
        <parameter name="DATETIME_1" layout="${date}"/>
        <parameter name="LEVEL" layout="${level:uppercase=true}"/>
        <parameter name="MESSAGE" layout="${message}"/>
        <parameter name="LOGGER" layout="${logger}"/>
      </target>

Am I doing something wrong?
Thanks for advance:)