Last time I checked, SQLite driver didn't support FKs. But this was a long time ago, so who knows :)
Derby would certainly support FKs, and the driver is pretty solid. Andrus > On Jul 22, 2022, at 3:24 PM, Ali Baharev <ali.baha...@gmail.com> wrote: > > Hi, > > I am trying to use cdbimport with the attached toy SQLite database. > The pom.xml file and the log file are also attached. > > My tables are imported but Cayenne 4.2.RC1 does not recognize any of > the foreign key constraints. In other words: I can import the tables > but their relationships are lost. > > I am following the steps in the Cayenne Guide: > > 3. DB-First Flow > https://cayenne.apache.org/docs/4.2/cayenne-guide/#db-first-flow > > and also the Cayenne Database First tutorial: > > 2. Importing database > https://cayenne.apache.org/docs/4.2/getting-started-db-first/#importing-database > > What am I doing wrong? Why are my foreign key constraints lost? > > If – for some reason – SQLite is not yet supported, would it work with > Apache Derby Embedded DB? > > Any help is greatly appreciated. > > Best wishes, > > Ali > <log.txt><kundeninteressen.sqlite3><pom.xml>
