[Bernhard Gramberg]

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

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 ——————

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

[Bernhard Gramberg]

Hibernate + Informix does not work together.

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

[support-swapna]

gramberg,

Thank you for posting the solution.

[Author]

Posts