ADF/MySQL: Primary Keys and auto-increment
Hi all,
I have been following Steve Andersons how-to on using ADF and MySQL have successfully created simple CRUD pages using UIX.
I have hit one snag related around the primary key and the absense of a true sequence object in MySQL. The table has a primary key defined as auto-increment in MySQL and flagged as a primary key in the ADO Entity Object.
I set the input field on the UIX page for the primary key field to read-only, but the catch is that the view object thinks that the primary key value needs to be supplied on insert and the the form does not pass JBO validation.
can anyone advise on how to make ADF auto-increment aware or advise on an alternate approach?
regards,
Brenden