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.
Post the code, deployment descriptors.
It is clearly a bug in your code or mappings.
Regards,
Adrian