db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "rajguru (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (TORQUE-281) Only issue SQL update with columns whose value is changed in dbObject, since it was loaded from db
Date Tue, 23 Apr 2013 17:25:17 GMT

    [ https://issues.apache.org/jira/browse/TORQUE-281?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13639268#comment-13639268
] 

rajguru commented on TORQUE-281:
--------------------------------

Let's say if a table has COLUMN1, COLUMN2, COLUMN3, COLUMN4 as part of the select query I
specify only COLUMN1 and COLUMN2 as select columns (COLUMN3 and COLUMN4 are not present as
part of select), i.e. I run SELECT COLUMN1, COLUMN2 FROM TABLE ABC.Now if I do save() on those
beans it will set COLUMN3 and COLUMN4 to null right? Is this an expected behavior?
                
> Only issue SQL update with columns whose value is changed in dbObject, since it was loaded
from db
> --------------------------------------------------------------------------------------------------
>
>                 Key: TORQUE-281
>                 URL: https://issues.apache.org/jira/browse/TORQUE-281
>             Project: Torque
>          Issue Type: Improvement
>            Reporter: rajguru
>            Assignee: Thomas Fox
>
> This means dbObject needs to have a way to see oldValue and newValue. If so also provide
some hooks in the code before update/after update/before insert/after insert/before delete
and after delete, so one can plugin an auditing code to log the oldValue to newValue change

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message