Hi guys,
I am implementing my own record listener to catch all insert/update/delete operations and insert a corresponding record to a audit table with the same values in addition to serveral self-defined fields like Hibernate.
However, I found the default value defined in MySQL is lost or not updated when insertEnd() is called in my own record listener. e.g. I defined a table with a field 'STATUS' with definition:
CHAR(1) not null default "A"
When a record is inserted into the table with implicit value for the field, the record got created with the default value. But in the callback insertEnd(), the default value is not updated. In this case I can't have the default value for the insertion of audit table.
Am I wrong or can anyone help? Thanks.
Best Regards,
Nicholas