[Marko]

Hi,

I have one big problem.

I have two MYSQL tables:

FIRST
CREATE TABLE JPT_KB_PROJECT_TYPE (
ID BIGINT(4) NOT NULL
, NAME VARCHAR(255) NOT NULL
, DESCIRPTION TEXT
, CREATED_BY VARCHAR(64)
, CREATED DATETIME
, UPDATED_BY VARCHAR(64)
, UPDATED DATETIME
, IND_VAL VARCHAR(1) NOT NULL DEFAULT ‘Y’
, PRIMARY KEY (ID)
)TYPE=InnoDB;

SECOND
CREATE TABLE JPT_KB_PROJECT (
ID BIGINT(4) NOT NULL
, NAME VARCHAR(255) NOT NULL
, TYPE_ BIGINT(4)
, PROJECT_KEY VARCHAR(5) NOT NULL
, URL VARCHAR(255)
, DESCRIPTION TEXT
, CREATED_BY VARCHAR(64)
, CREATED DATETIME
, UPDATED_BY VARCHAR(64)
, UPDATED DATETIME
, IND_VAL VARCHAR(1) NOT NULL DEFAULT ‘Y’
, PRIMARY KEY (ID)
, INDEX (TYPE_)
, CONSTRAINT FK_JPT_KB_PROJECT_1 FOREIGN KEY (TYPE_)
REFERENCES jprotrack.JPT_KB_PROJECT_TYPE (ID)
)TYPE=InnoDB;

After I select these tables in DB Browser and choose “Create Hibernate Mapping”, for JPT_KB_PROJECT I’m getting mapping file without many-to-one relation, that is not OK because JPT_KB_PROJECT has one FOREIGN KEY.

Why ? 🙁

I have

-> MyEclipse 4.1.0
-> MySQL 4.0.20a-nt

Thanks.

Marko.

[snpe]

do your referenced table in same schema (you have schema prefix in references ) – try remove refrence or
set deafult_schema in *cfg.xml

[Marko]

no, that is not problem I tried without schema and got the same result 🙁

Marko.

[Marko]

so the problem was in one of the MySQL table definitions, the second table PT_KB_PROJECT_TYPE must have create statement as follows:

CREATE TABLE JPT_KB_PROJECT (
ID BIGINT(4) NOT NULL
, NAME VARCHAR(255) NOT NULL
, TYPE_ BIGINT(4)
, PROJECT_KEY VARCHAR(5) NOT NULL
, URL VARCHAR(255)
, DESCRIPTION TEXT
, CREATED_BY VARCHAR(64)
, CREATED DATETIME
, UPDATED_BY VARCHAR(64)
, UPDATED DATETIME
, IND_VAL VARCHAR(1) NOT NULL DEFAULT ‘Y’
, PRIMARY KEY (ID)
, KEY (TYPE_)
, INDEX (TYPE_)
)TYPE=InnoDB;

ALTER TABLE JPT_KB_PROJECT
ADD FOREIGN KEY (TYPE_) REFERENCES jprotrack.JPT_KB_PROJECT_TYPE (ID);

Marko.

[Author]

Posts