Mysql auto_increment Id

[Igor Perevozchikov]

Hi, Flavio!

General idea of the activate-framework is awesome, but i have some problem around work with Mysql DB.

Whats about auto incremented primary key in table?

For example, i have table Quality with auto incremented primary key, id value must set by DB Layer, but its required in Activate Layer.

Using UUID as primary key is not a good idea for Mysql DB.

So, i thought about next implementaion but i don't known how to do it, general idea:

Memory Layer         |             Db Layer

------------------------------------------------------

create entity       ---------> persist in table

update entity id  <--------  persisted (may be propagate statement or resultset)

Can you advise some solution or may be workaround or idea of how to do it?