Eclipse Community Forums: EclipseLink » create-tables doesn't create foreign key constraints

Help

Home

Home » Eclipse Projects » EclipseLink » create-tables doesn't create foreign key constraints

Show: Today's Messages :: Show Polls :: Message Navigator

create-tables doesn't create foreign key constraints [message #746153]

Sun, 23 October 2011 08:18

Pablo

Messages: 5
Registered: October 2009

Junior Member

Hi,

I just noticed that eclipselink is not generating the foreign key constraints for any table.

It does create indexes called FK_XXX_YYY (with the name the FK constraint would have)

See screensjot.

Env:
EL 2.3.0,
MySQL 5.something,
Ubuntu 11.04

Attachment: Screenshot-NetBeans IDE 7.0.1.png
(Size: 212.04KB, Downloaded 233 times)

Report message to a moderator

Re: create-tables doesn't create foreign key constraints [message #748504 is a reply to message #746153]

Mon, 24 October 2011 18:24

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

EclipseLink does create foreign keys (and does not create indexes unless specified). Turn logging on finest and look at the DDL generated, you will see the constraints created.

How did you create your tables?

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Re: create-tables doesn't create foreign key constraints [message #749678 is a reply to message #748504]

Tue, 25 October 2011 11:14

Pablo

Messages: 5
Registered: October 2009

Junior Member

Thanks James,

I found out the MySQL on ubuntu uses MyISAM storage engine by default which silently ignores foreign key constraints...

U the same James that was answering my questions en toplink two years ago? Wink