Abgeschickt von reym am 04 Juli, 2005 um 10:12:35
Hi there,
I am using your Oracle example, with modifications, to put the log into a MS SQL Server database. Below is the exception that the application throws out. It is complaing about a read-only resultset. How is this possible if I am not expecting any data back?? I am also fully aware that the problem lies with the JDBC driver. How can I resolve this?? Please advise. Thanks in advance.
Kind regards.
log4j:ERROR JDBCAppender::flush_buffer(), :
java.sql.SQLException: ResultSet is read only.
at net.sourceforge.jtds.jdbc.JtdsResultSet.checkUpdateable(JtdsResultSet
.java:314)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.moveToInsertRow(MSCursorR
esultSet.java:1062)
at org.apache.log4j.jdbcplus.JDBCLogger.append(JDBCLogger.java:568)
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:221)
at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders
(AppenderAttachableImpl.java:57)
at org.apache.log4j.Category.callAppenders(Category.java:187)
at org.apache.log4j.Category.forcedLog(Category.java:372)
at org.apache.log4j.Category.info(Category.java:674)
at SourceConfigOracleTest.main(SourceConfigOracleTest.java:88)
log4j:ERROR JDBCAppender::flush_buffer(), :
java.sql.SQLException: ResultSet is read only.
at net.sourceforge.jtds.jdbc.JtdsResultSet.checkUpdateable(JtdsResultSet
.java:314)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.moveToInsertRow(MSCursorR
esultSet.java:1062)
at org.apache.log4j.jdbcplus.JDBCLogger.append(JDBCLogger.java:568)
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:221)
at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders
(AppenderAttachableImpl.java:57)
at org.apache.log4j.Category.callAppenders(Category.java:187)
at org.apache.log4j.Category.forcedLog(Category.java:372)
at org.apache.log4j.Category.info(Category.java:674)
at SourceConfigOracleTest.main(SourceConfigOracleTest.java:88)