We have a
J2EE application based on Toplink (10.1.3.5) / ADF / Oracle db. We tried to migrate it to MySql. We slightly changed data structure (IDs, some data types) and succesfully migrated data from Oracle to MySql. We even started the application, but we are stuck at some strange toplink error:
[TOPLINK-7197] (Oracle TopLink - 10g Release 3 (10.1.3.5.0) (Build 090715)): oracle.toplink.exceptions.ValidationException
Exception Description: Exception calculating changes. Primary Key can not be set to null.
We searched in code and found out the source of the problem - method hasChanges() in UnitOfWork object.
The problem started when we succesfully inserted new record to database (via form) and tried to return from form to list of records.
Does anybody have any experience with migrating Toplink/ADF application to MySql ? Please share your experience.
Thanks.