JDBC driver does not support getGeneratedKeys method

[Thomas SMETS <tsmets(at)brutele(dot)be>]

Dear,

I try to use Log4J new DBAppender (cfr. the config file herebelow) but
it keeps on complaining with the following message :
	

Reported error: "Exception in Action for tag <appender>" at line 20
column -1
java.lang.IllegalStateException: DBAppender cannot function if the JDBC
driver does not support getGeneratedKeys method *and* without a specific
SQL dialect
	at org.apache.log4j.db.DBAppender.activateOptions(DBAppender.java:179)

As I cannot get the information out of the ML's of Log4J ( Log4J Users
List <log4j-user(at)logging(dot)apache(dot)org>, 
ML log4j dev <log4j-dev(at)logging(dot)apache(dot)org> ) on how to set the
SQL_DIALECT variable ....  I was wandering if the postgresql driver
allowed for getGeneratedKeys....

I was wandering if I needed to use the "jxDBCon-Open Source JDBC driver
framework" available here : http://jxdbcon.sourceforge.net/ ... ?

Tx,

\T,




-- 
Thomas Lionel SMETS
rue J. Wytsmanstraat 62
1050 Brussels
T : +32 (0)2 742 05 94
M : +32 (0)497 44 68 12
@ : duvelbier-tsmets(at)yahoo(dot)com
Do you skype (callto://tsmets) ?



<snip>

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">

<log4j:configuration
    debug="true"
    xmlns:log4j='http://jakarta.apache.org/log4j/'>

  <appender name="DB" class="org.apache.log4j.db.DBAppender">
    <layout class="org.apache.log4j.PatternLayout">
      <param name="ConversionPattern" value="%d %-5p %c - %m%n"/>
    </layout>
    <connectionSource
class="org.apache.log4j.db.DriverManagerConnectionSource">
        <param name="driver" value="org.postgresql.Driver" />
        <param name="url"
value="jdbc:postgresql://localhost:5432/Log4j" />
        <param name="username" value="xyz" />
        <param name="password" value="xyz" />
        <param name="dialect" value="POSTGRES_DIALECT" />
    </connectionSource>
        
  </appender>

  <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
    <layout class="org.apache.log4j.PatternLayout">
      <param name="ConversionPattern" value="%d %-5p %c - %m%n"/>
    </layout>
  </appender>
  
  
  <root>
    <level value ="debug"/>
    <appender-ref ref="Db" />
  </root>
  <logger name="com">
    <level value="debug" />
    <appender-ref ref="STDOUT" />
  </logger>
</log4j:configuration>



</snip>