Re: MS SQL Server

Subject:

Text:
: Ignore this. It was a silly mistake on my side. Thanks all the same. : Kind regards : : 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)

Optionale URL:
Link Titel:
Optionale Bild-URL: