DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=37349>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=37349 Summary: DBAppender not working with jTDS driver Product: Log4j Version: 1.3alpha Platform: PC URL: http://sourceforge.net/forum/forum.php?thread_id=1377897 &forum_id=104389 OS/Version: Windows XP Status: NEW Severity: normal Priority: P2 Component: Appender AssignedTo: [email protected] ReportedBy: [EMAIL PROTECTED] When using DBAppender with the jTDS driver, it gave the following error: java.sql.SQLException: No current row in the ResultSet. at net.sourceforge.jtds.jdbc.JtdsResultSet.getColumn(JtdsResultSet.java:269) at net.sourceforge.jtds.jdbc.JtdsResultSet.getInt(JtdsResultSet.java:630) at org.apache.log4j.db.DBAppender.append(DBAppender.java:226) at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:239) at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:67) at org.apache.log4j.Category.callAppenders(Category.java:219) at org.apache.log4j.Category.forcedLog(Category.java:588) at org.apache.log4j.Category.log(Category.java:1169) at org.apache.commons.logging.impl.Log4JLogger.info(Log4JLogger.java:135) The jTDS developer believe that it's a bug in DBAppender with the following comment: Moving on to the error itself it's indeed caused by DBAppender. It tries to retrieve auto generated keys although it didn't request them in the first place: it calls prepareStatement(String) instead of prepareStatement(String, int), which is needed if auto generated keys are to be retrieved. A second problem is that it doesn't even check whether ResultSet.next() returned true or not and it just goes for the value which isn't there. Here's the code in question: http://fisheye.cenqua.com/viewrep/jakarta/jakarta-log4j/src/java/org/apache/log4j/db/DBAppender.java?r=1.17&k= For more information, please refer to: http://sourceforge.net/forum/forum.php?thread_id=1377897&forum_id=104389 URL of jTDS: http://jtds.sourceforge.net/ -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
