RE: Using JDBCAppender to insert CLOB?
Lutz Michael <michael.h.lutz <at> siemens.com>
2003-02-01 17:03:58 GMT
I'm getting out of my comfort level here, because I don't know the specifics
about CLOB's, but I'll offer up all that I believe to be correct.
Last week, I showed my colleague the SQL typically found in a Log4j config
file for a JDBC setup (e.g. log4j.appender.myJDBC.Sql="INSERT INTO
table_name_here VALUES ..."), and he replied, "that SQL statement won't work
in Oracle if any of the fields are CLOB's." Thus, I'm guessing that
possibly the fix could be made in the config file directly on the SQL;
however, I suspect there's more to it than that. He indicated it was
Unfortunately, Art's out today (Saturday), but he does understand CLOB
support clearly (across RDBMS systems). If the question is not answered by
Monday, I'll track him down and summarize from an Oracle perspective what
needs to be done. Then the Log4j pros can determine the best approach,
although I'm hoping it's just a SQL change in the config file, we'll see.
I'm not familiar with the details of the Log4j JDBC appenders. I just
wanted to offer up the fact that CLOB support is not consistent across
RDBMS's even if one is going through JDBC.
I apologize for not having a crystal clear answer.
From: Martin [mailto:mgainty <at> hotmail.com]
Sent: Monday, September 02, 2002 9:23 AM
To: Log4J Users List