Message:
A new issue has been created in JIRA.
---------------------------------------------------------------------
View the issue:
http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-317
Here is an overview of the issue:
---------------------------------------------------------------------
Key: CAY-317
Summary: Improve SQL Logging Output when Optimistic Locking is Used
Type: Improvement
Status: Assigned
Priority: Minor
Project: Cayenne
Components:
Cayenne Core Library
Versions:
1.1
Assignee: Andrus Adamchik
Reporter: Michael Gentry
Created: Thu, 19 May 2005 3:45 PM
Updated: Thu, 19 May 2005 3:45 PM
Environment: All
Description:
When Cayenne outputs SQL for logging and optimistic locking is being used, Cayenne smartly doesn't create bindings for null values (generates "IS NULL" for the SQL), but the "bind:" output immediately following shows "NULL" in the output instead of omitting it.
Example:
INFO QueryLogger:315 - UPDATE Foo SET bar = ? WHERE bar = ? and baz IS NULL
INFO QUeryLogger:337 - [bind: 2, 1, NULL]
Since Cayenne generated "IS NULL for the SQL, it is not needed (and in fact Cayenne does not include it) as a bind parameter, but the logging doesn't reflect this, which is confusing.
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://objectstyle.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
This archive was generated by hypermail 2.0.0 : Thu May 19 2005 - 15:47:20 EDT