Dear Andrus, Thank you for your prompt reply.
> Last time I checked, SQLite driver didn't support FKs. But this was a long > time ago, so who knows :) FKs have been supported since at least 2009. It does have a well documented quirk though: You must enable foreign key support explicitly. 2. Enabling Foreign Key Support https://www.sqlite.org/foreignkeys.html#fk_enable But apart from that, it works like a charm. > Derby would certainly support FKs, and the driver is pretty solid. I need a solution ASAP. If that is the case, then the whole DB will be migrated to Embedded Derby. As a side note: The derby team made a breaking change to the embedded driver at around 10.13. So if I try to use the embedded driver as documented on the Cayenne website, the Cayenne application crashes. But the Derby team made a big mistake in my opinion: they made a breaking change, but they did not bump up the major version to 11. Thanks again for the prompt reply. Best wishes, Ali