Update problem using CMP

[janice]

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.

[adrian.brock]

Post the code, deployment descriptors.

It is clearly a bug in your code or mappings.

Regards,
Adrian