Dear Nikita,
Thank you for this workaround, it seems to work.
> Just checked dbimport with sqlite, seems like driver still skips part
> of the information about foreign keys (or rather quite strictly
> follows the definition of the table).
I don't think it is an issue with the driver. I think
> 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.
It must have been a long while ago.
If I use it from DBeaver, I do get all the foreign keys, so the JDBC
driver has been fixed by now.
Ali
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.
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.
Dear Michael,
Thank you for the prompt reply!
> Like if you are using a barebones java command, try adding a -cp entry, etc.
Yes, putting the configuration files on the class path seems to have
solved the problem, thank you!
> What tooling are you using?
I need a solution that is independent
Hi,
I am trying to integrate Cayenne into a project that must not use
Maven. The application – not too surprisingly – crashes on this line:
ServerRuntime cayenneRuntime = ServerRuntime.builder()
.addConfig("cayenne-project.xml")
.build();
Exception in
Dear Andrus,
> I think that we simply need to
> remove the "Converting to Web Application" section, which is indeed dated.
Please don't!
I am teaching Java for absolute beginners, and Apache Cayenne and this
tutorial is exactly what I have been looking for.
I think just pinning down the
Adding:
war
and
org.eclipse.jetty
jetty-maven-plugin
9.4.25.v20191220
war
seems to solve the problem. I seriously think that the Getting Started
Guide should be updated on the
Hello everyone,
I am following the Getting Started Guide on the website,
and up until 4.1.1. Running Web Application everything works.
When I try to run the web application, I don't get any error messages,
but it just does not start Jetty after successfully building the project.
The last few