You are viewing a plain text version of this content. The canonical link for it is here.
Posted to log4j-dev@logging.apache.org by bu...@apache.org on 2007/07/17 18:01:57 UTC
DO NOT REPLY [Bug 42921] New: - DBReceiverJob queries with wrong datatype.
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=42921>.
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=42921
Summary: DBReceiverJob queries with wrong datatype.
Product: Log4j
Version: 1.3alpha
Platform: Other
OS/Version: All
Status: NEW
Severity: normal
Priority: P2
Component: chainsaw
AssignedTo: log4j-dev@logging.apache.org
ReportedBy: richard.landers@ct.gov
DBReceiverJob queries LOGGING_EVENT_PROPERTIES and LOGGING_EVENT_EXCEPTION with
EVENT_ID expressed as a string (in single quotes). On DB2, at least, this
results in SQL Errors whenever a LOGGING_EVENT has associated properties or
exceptions.
This bug manifests itself in Chainsaw when the DBRecieverJob only retrieves a
portion of the LOGGING_EVENTS available in the database. As soon as a
LOGGING_EVENT has an associated property or exception, the loop iterating over
LOGGING_EVENTS exits because of an SQLException.
The solution is to remove the single-quotes from the EVENT_ID arguments of the
SQL queries on lines 164 and 197 of DBReceiverJob.java.
--
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
DO NOT REPLY [Bug 42921] - DBReceiverJob queries with wrong datatype.
Posted by bu...@apache.org.
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=42921>.
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=42921
richard.landers@ct.gov changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution| |FIXED
--
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
DO NOT REPLY [Bug 42921] - DBReceiverJob queries with wrong datatype.
Posted by bu...@apache.org.
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=42921>.
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=42921
sdeboy@iname.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
------- Additional Comments From sdeboy@iname.com 2007-08-09 23:10 -------
I don't see single quotes around event_id in DBReceiverJob on the trunk - could
you try and let us know?
Here are the event, exception & property query strings on trunk:
String sqlException = "SELECT trace_line FROM logging_event_exception where
event_id=? ORDER by i ASC";
String sqlProperties = "SELECT mapped_key, mapped_value FROM
logging_event_property WHERE event_id=?";
String sqlSelect =
"SELECT " +
"sequence_number, timestamp, rendered_message, logger_name, " +
"level_string, ndc, thread_name, reference_flag, " +
"caller_filename, caller_class, caller_method, caller_line, " +
"event_id " +
"FROM logging_event " +
"WHERE event_id > ? ORDER BY event_id ASC";
--
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