I solved the issue modifying the database: I made all foreign key columns part of the primary key of the referenced table and child columns related too, so now hibernate properly generate the sql, maybe is not the cleanest way but works.