# auto inc id at end of list so will default bind to undef:
log4j.appender.DBAppndr.sql = \
insert into log \
( priority, level, message, date,deltat, host, pid, file, line, method, id ) \
values (?,?,?,?,?,?,?,?,?,?,?)
#just pass through the array of message items in the log statement
log4j.appender.DBAppndr.layout = Log::Log4perl::Layout::NoopLayout
log4j.appender.DBAppndr.warp_message = 0
contents:
Symptom
Conf defining only a DBI appender
symptom:
The message text is going in as a stringified
ARRAY ref. However, thehe only layout is the noop layout and warp_message is 0.
id level priority message date deltat host pid file line method
1 main ERROR ARRAY(0x84d146c) 2006-03-29 10:56:58 42 vm-esilber-40 652 ./run_api_test 82 main::
2 BPTestXML_RPC ERROR ARRAY(0x849b148) 2006-03-29 10:56:58 47 vm-esilber-40 652 BPTest.pm 136 BPTest::Configure
3 BPTestXML_RPC ERROR ARRAY(0x85e3ca4) 2006-03-29 10:56:58 52 vm-esilber-40 652 BPTestXML_RPC.pm 63 BPTestXML_RPC::Run
entire conf file text:
log4j.category = WARN, DBAppndr
log4j.appender.DBAppndr = Log::Log4perl::Appender::DBI
log4j.appender.DBAppndr.datasource = DBI:mysql:QA
log4j.appender.DBAppndr.username = xyz
log4j.appender.DBAppndr.password = xyz
# auto inc id at end of list so will default bind to undef:
log4j.appender.DBAppndr.sql = \ insert into log \ ( priority, level, message, date,deltat, host, pid, file, line, method, id ) \ values (?,?,?,?,?,?,?,?,?,?,?)
log4j.appender.DBAppndr.params.1 = %p
log4j.appender.DBAppndr.params.2 = %c
log4j.appender.DBAppndr.params.3 = %m
log4j.appender.DBAppndr.params.4 = %d
log4j.appender.DBAppndr.params.5 = %r
log4j.appender.DBAppndr.params.6 = %H
log4j.appender.DBAppndr.params.7 = %P
log4j.appender.DBAppndr.params.8 = %F
log4j.appender.DBAppndr.params.9 = %L
log4j.appender.DBAppndr.params.10 = %M
log4j.appender.DBAppndr.bufferSize = 2
#just pass through the array of message items in the log statement
log4j.appender.DBAppndr.layout = Log::Log4perl::Layout::NoopLayout
log4j.appender.DBAppndr.warp_message = 0
##############################################################################