logging-log4j-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 37349] New: - DBAppender not working with jTDS driver
Date Thu, 03 Nov 2005 22:16:25 GMT
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: log4j-dev@logging.apache.org
        ReportedBy: gingming@hotmail.com


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: log4j-dev-unsubscribe@logging.apache.org
For additional commands, e-mail: log4j-dev-help@logging.apache.org


Mime
View raw message