conditional update is executed even if condition is false

From: Lothar Krenzien (
Date: Tue Nov 15 2005 - 04:35:10 EST

  • Next message: Ahmed Mohombe: "DataViews Status?"

    Hi there,

    I have a method called like 'updateXXX' which should update two tables. In the second one there is column which I would like to update only when the value of the corresponding java field is not empty. But it seems that this column is alsways updatet by cayenne !?

    //Java code
    TblPlant plant = (TblPlant) DataObjectUtils.objectForPK(context, TblPlant.class, Integer.parseInt(plantId));
    if(plant == null)
    throw new DataNotFoundException("plant not found");


    TblLogger logger = (TblLogger) DataObjectUtils.objectForPK(context, TblLogger.class, Integer.parseInt(loggerId));
    if (! StringUtils.isEmpty(getSubstitutionSerialNumber())) {

    In the log file I have always the following entry even if getSubstitutionSerialNumber() is empty:
    UPDATE dbo.tblLogger SET newSerialNumber = ? WHERE loggerId = ?

    And this fails because of a database trigger. Maybe it's a caching problem because in the previous call the getSubstitutionSerialNumber() was not empty.

    Thanks, Lothar
    Verschicken Sie romantische, coole und witzige Bilder per SMS!
    Jetzt bei WEB.DE FreeMail:

    This archive was generated by hypermail 2.0.0 : Tue Nov 15 2005 - 04:35:13 EST