Hi,

I use Infiormix JDBC. I tried (first time) to use the function "create foreign key) in the DB explorer. Just to learn mor about MyEclipse

I got an Syntax Error for the following DDL

Code:

alter table guttest:fest.vorgang add constraint fk_gut_nr   foreign Key (vg_gut)   referencing guttest:fest.gut(gut_nr)

-------- Correct Syntax for Informix Backend ------------------

Code:

alter table "fest".vorgang add constraint (foreign key (vg_gut) references     "fest".gut  constraint "fest".fk_vg_gut);

------------------------------

not this importend, it was just a try

Hibernate + Informix does not work together.

Solution is, to change to openJPA,
there, Infiiormix is suported.

gramberg,

Thank you for posting the solution.