1 Reply Latest reply on Mar 16, 2003 8:53 PM by Adrian Brock

    Update problem using CMP

    janice Newbie

      I am using CMP in JBoss 3.0 and MySQL to implement the application.

      I have a table with the following columns:
      Txnid (number),
      TxnDesc (String),
      Status (String),
      ResponseCode(String),
      CreateTime (TimeStamp),
      ResponseTime (Timestamp)

      While I create a new record, I put values into Txnid, TxnDesc and CreateTime.
      While response come, then I update the record with Status, ResponseCode and ResponseTime.

      However, I found that every I update the ResponseTime, the CreateTime will be updated at the same time.
      As a result, I got CreateTime = ResponseTime.

      Any idea for this situation?? Please suggest!!!
      Thanks in advance.

      Janice.