logging-log4j-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ece Yildirim <ece...@yahoo.com>
Subject Re: CLOB column datatype for JDBCPlus jdbc appender
Date Tue, 25 Nov 2008 15:04:18 GMT

Hi Vaibhav, 

I am suffering of the same error. Could you find a solution regarding this
problem ? I checked org.apache.log4j.jdbcplus.JDBCLogger class, there seems
to be no explicit implementation for CLOB data type. 

Thank you
Ece




Vaibhav Kumar wrote:
> 
> Hi,
> I am using JDBCPlus (http://www.dankomannhaupt.de/projects/index.html ) as
> a
> jdbc appender for my application. For a particular requirement, I have to
> make a column datatype from varchar2(4000) to CLOB. But as soon as I do
> this, my application fails to log in database giving stack trace as
> 
> log4j:ERROR JDBCAppender::flush_buffer(), :
> java.sql.SQLException: Internal Error: Unable to construct a Datum from
> the
> specified input
>    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
>    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
>    at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:829)
>    at oracle.sql.SQLUtil.makeDatum(SQLUtil.java:645)
>    at oracle.sql.SQLUtil.makeOracleDatum(SQLUtil.java:946)
>    at
> oracle.jdbc.driver.UpdatableResultSet.updateObject(UpdatableResultSet.java:1568)
>    at
> oracle.jdbc.driver.OracleResultSet.updateObject(OracleResultSet.java:2787)
>    at org.apache.log4j.jdbcplus.JDBCLogger.append(JDBCLogger.java:742)
>    at
> org.apache.log4j.jdbcplus.JDBCAppender.flush_buffer(JDBCAppender.java:887)
>    at org.apache.log4j.jdbcplus.JDBCAppender.append(JDBCAppender.java:867)
>    at
> org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:230)
>    at
> org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:65)
>    at org.apache.log4j.Category.callAppenders(Category.java:203)
>    at org.apache.log4j.Category.forcedLog(Category.java:388)
>    at org.apache.log4j.Category.log(Category.java:853)
>    at edu.unc.its.util.UNCLogger.prepareAndLogMessage(UNCLogger.java:445)
>    at edu.unc.its.util.UNCLoggerClient.main(UNCLoggerClient.java:23)
> log4j:ERROR JDBCAppender::flush_buffer(), :
> java.sql.SQLException: Internal Error: Unable to construct a Datum from
> the
> specified input
>    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
>    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
>    at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:829)
>    at oracle.sql.SQLUtil.makeDatum(SQLUtil.java:645)
>    at oracle.sql.SQLUtil.makeOracleDatum(SQLUtil.java:946)
>    at
> oracle.jdbc.driver.UpdatableResultSet.updateObject(UpdatableResultSet.java:1568)
>    at
> oracle.jdbc.driver.OracleResultSet.updateObject(OracleResultSet.java:2787)
>    at org.apache.log4j.jdbcplus.JDBCLogger.append(JDBCLogger.java:742)
>    at
> org.apache.log4j.jdbcplus.JDBCAppender.flush_buffer(JDBCAppender.java:887)
>    at org.apache.log4j.jdbcplus.JDBCAppender.append(JDBCAppender.java:867)
>    at
> org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:230)
>    at
> org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:65)
>    at org.apache.log4j.Category.callAppenders(Category.java:203)
>    at org.apache.log4j.Category.forcedLog(Category.java:388)
>    at org.apache.log4j.Category.log(Category.java:853)
>    at edu.unc.its.util.UNCLogger.prepareAndLogMessage(UNCLogger.java:445)
>    at edu.unc.its.util.UNCLoggerClient.main(UNCLoggerClient.java:23)
> 
> 
> Any suggestions as to how can I incorporate a CLOB datatype in JDBCPlus
> jdbc
> appender will be most welcome.
> 
> Regards,
> Vaibhav
> 
> 

-- 
View this message in context: http://www.nabble.com/CLOB-column-datatype-for-JDBCPlus-jdbc-appender-tp19306835p20682090.html
Sent from the Log4j - Dev mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: log4j-dev-unsubscribe@logging.apache.org
For additional commands, e-mail: log4j-dev-help@logging.apache.org


Mime
View raw message