Re: cdbimport ignores foreign key constrains with SQLite
Andrus Adamchik <[email protected]> Fri, 22 Jul 2022 16:10:09 +0200
| Newsgroups | gmane.comp.java.cayenne.user |
|---|---|
| Message-ID | <[email protected]> |
> On Jul 22, 2022, at 3:56 PM, Ali Baharev <[email protected]> wrote: > > 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 <https://www.sqlite.org/foreignkeys.html#fk_enable> > > But apart from that, it works like a charm. IIRC the issue on Cayenne side was with SQLite JDBC driver not bringing over the FK metadata during DB import. Again, this was years ago. A.