<div dir="ltr">I'm using Postgres 9.2 on Windows with Logback 0.9.18. I am using the DBAppender to log to a database. I am able to log a single logging_event record, but whenever I add something to the MDC which triggers records being written to the logging_event_property table, I get the following error: I can't for the life of me figure out what's going on. thanks!<div>
BTW, the JDBC driver is postgresql-9.2-1002.jdbc4.jar<br><div><br></div><div><div>16:33:01,514 |-ERROR in ch.qos.logback.classic.db.DBAppender[db] - problem appending event java.sql.BatchUpdateException: Batch entry 0 INSERT INTO logging_event_property (event_id, mapped_key, mapped_value) VALUES (3, 'dog', 'dog') was aborted. Call getNextException to see the cause.</div>
<div><span class="" style="white-space:pre"> </span>at java.sql.BatchUpdateException: Batch entry 0 INSERT INTO logging_event_property (event_id, mapped_key, mapped_value) VALUES (3, 'dog', 'dog') was aborted. Call getNextException to see the cause.</div>
<div><span class="" style="white-space:pre"> </span>at <span class="" style="white-space:pre"> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2746)</div><div>
<span class="" style="white-space:pre"> </span>at <span class="" style="white-space:pre"> </span>at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1887)</div><div><span class="" style="white-space:pre"> </span>at <span class="" style="white-space:pre"> </span>at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405)</div>
<div><span class="" style="white-space:pre"> </span>at <span class="" style="white-space:pre"> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2893)</div><div><span class="" style="white-space:pre"> </span>at <span class="" style="white-space:pre"> </span>at ch.qos.logback.classic.db.DBAppender.insertProperties(DBAppender.java:173)</div>
<div><span class="" style="white-space:pre"> </span>at <span class="" style="white-space:pre"> </span>at ch.qos.logback.classic.db.DBAppender.subAppend(DBAppender.java:94)</div><div><span class="" style="white-space:pre"> </span>at <span class="" style="white-space:pre"> </span>at ch.qos.logback.core.db.DBAppenderBase.append(DBAppenderBase.java:98)</div>
<div><br></div><div><div><b><br></b></div><b>---</b><div><b>Dawson Mossman</b></div><div><div>Certified ScrumMaster</div><div>454.7061 ext. 226</div></div></div>
</div></div></div>