Hi all,
Here is an excerpt from my schema:
CREATE TABLE User (
id INTEGER NOT NULL AUTO_INCREMENT,
name VARCHAR(250) NOT NULL,
email VARCHAR(250) NOT NULL,
password VARCHAR(250) NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE Tag (
id INTEGER NOT NULL AUTO_INCREMENT,
uid UUID NOT NULL,
parent INTEGER DEFAULT NULL,
user INTEGER NOT NULL,
label VARCHAR(250) NULL,
PRIMARY KEY (id),
UNIQUE (user, label),
UNIQUE (uid),
FOREIGN KEY (parent) REFERENCES Tag (id),
FOREIGN KEY (user) REFERENCES User (id),
);
CREATE TABLE TagReferer (
tag INTEGER NOT NULL,
constraint tt_tag FOREIGN KEY (tag) REFERENCES Tag (id)
);
The problem is that jooq generates the following foreign key for TagReferer:
public class Keys {
[...]
private static class UniqueKeys0 extends org.jooq.impl.AbstractKeys {
[...]
public static final
org.jooq.UniqueKey<hu.engard.expenses.generated.tables.records.TagRecord>
CONSTRAINT_1 = createUniqueKey(hu.engard.expenses.generated.tables.Tag.TAG,
hu.engard.expenses.generated.tables.Tag.TAG.ID);
[...]
private static class ForeignKeys0 extends org.jooq.impl.AbstractKeys {
[...]
public static final
org.jooq.ForeignKey<hu.engard.expenses.generated.tables.records.TagrefererRecord,
hu.engard.expenses.generated.tables.records.TagRecord> TT_TAG =
createForeignKey(hu.engard.expenses.generated.Keys.CONSTRAINT_1,
hu.engard.expenses.generated.tables.Tagreferer.TAGREFERER,
*hu.engard.expenses.generated.tables.Tagreferer.TAGREFERER.TAG,
hu.engard.expenses.generated.tables.Tagreferer.TAGREFERER.TAG*);
}
}
Please notice the duplicated ...Tagreferer.TAGREFERER.TAG in the TT_TAG.
This results in exceptions when I am joining the two tables with onKey()
method.
If I remove any of the indexes from the Tag table (e.g., remove the UNIQUE
(uid) index), then the problem disappears, and the generated TT_TAG foreign
key looks like:
public static final
org.jooq.ForeignKey<hu.engard.expenses.generated.tables.records.TagrefererRecord,
hu.engard.expenses.generated.tables.records.TagRecord> TT_TAG =
createForeignKey(hu.engard.expenses.generated.Keys.CONSTRAINT_1,
hu.engard.expenses.generated.tables.Tagreferer.TAGREFERER,
*hu.engard.expenses.generated.tables.Tagreferer.TAGREFERER.TAG*);
What can be the problem, and the solution? Jooq version 3.2.2, H2 database
version 1.3.174. codegen.xml snippet:
<database>
<name>org.jooq.util.h2.H2Database</name>
<includes>.*</includes>
<excludes></excludes>
<inputSchema>PUBLIC</inputSchema>
</database>
<generate>
<pojos>true</pojos>
<interfaces>true</interfaces>
<daos>true</daos>
<navigationMethods>true</navigationMethods>
</generate>
Thanks,
Ferenc
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
