Using parameters with ADONetAppender and FireBird

[Frode Breimo <fr...@broadpark.no>]

Hi

I''ve been working for two days now trying to send log information to my 
FireBird database using SQL parameters, but I've been unable to find any 
helpful examples or articles and could really use some help.

For testing purposes I'm just using a very simple table called TESTTABLE 
with a single column called TESTSTRING, of type VarChar. I've tried 
several things but here's what the appender definition in my config file 
look like now:

    <appender name="myODBCAppender" type="log4net.Appender.ADONetAppender" >
        <bufferSize value="1"/>
        <param name="Threshold" value="ERROR" />
        <param name="ConnectionType" 
value="System.Data.Odbc.OdbcConnection, System.Data, version=1.0.3300.0, 
publicKeyToken=b77a5c561934e089, culture=neutral" />
        <param name="ConnectionString" 
value="DRIVER=Firebird/Interbase(r) 
driver;UID=sysdba;PWD=masterkey;DBNAME=127.0.0.1:c:\\mbos\\mtbs1604v.gdb" />
        <param name="CommandText" value="INSERT INTO TESTTABLE 
(TESTSTRING) VALUES (:logText)" />
        <param name="Parameter">
            <param name="ParameterName" value="logText" />
            <param name="DbType" value="String" />
            <param name="Layout" type="log4net.Layout.PatternLayout">
                <param name="ConversionPattern" value="%P{logText}" />
            </param>
        </param>
    </appender>

Using this config I get the following error message when I declare my 
logger:

    log4net:ERROR [ADONetAppender] Could not prepare database command 
[INSERT INTO TESTTABLE    (TESTSTRING) VALUES (:logText)]
    System.Data.Odbc.OdbcException: ERROR [HY000] Dynamic SQL Error
    SQL error code = -206
    Column unknown
    LOGTEXT
    At line 1, column 45.

If I change the CommandText and use (@logText) instead of (:logText) I 
get the following error:

    SQL error code = -104
    Token unknown - line 1, char 44
    @

If I remove the parameter and replace it with a set value everything 
works fine, so for instance
    <param name="CommandText" value="INSERT INTO TESTTABLE (TESTSTRING) 
VALUES ('TestValue')" />
will insert the value "TestValue" into the database, so there's nothing 
wrong with the connection.

This should be possible just using the config file, shouldn't it? I 
don't want to have to create everything programmatically.

I'm totally lost here, and any help would be much appreciated. I'm using 
log4net 1.2.0 Beta 8 and FireBird 1.5, the project is a .Net 1.1 console 
application (for testing purposes, log4net will eventually be used in 
our asp.net solutions)


Thank you,
Frode