Abe White wrote:
Is that a hint to set openjpa.jdbc.SchemaFactory=native (ForeignKeys=true)?

No. I'm saying that if these secret tests rely on OpenJPA to detect foreign keys based on the above setting,
Secret tests?

then it's likely that the problem is in OpenJPA's ability to detect the existing foreign keys rather than in OpenJPA's constraint analyses and SQL ordering. For example, I know in some versions of MySQL the standard DatabaseMetaData.getExportedKeys call didn't work unless the keys were created with ALTER TABLE statements rather than in the CREATE TABLE statement.
Understood. I was however under the impression that correctly annotated relations would make it unnecessary to resort to database metadata to build a correct dependency graph --it appears that's not the case.

FWIW, setting SchemaFactory=native(ForeignKeys=true) does fix that particular problem with ConstraintUpdateManager.

Reply via email to