Hello all. I use OpenJPA (currently 2.1.0 version), PostgreSQL (currently 9.0). My model has one abstract class and many, many extended classes, and inheritance goes four levels deep and about 20 classes wide (please don't question the model, I am currently proposing the refactoring).
I have noticed that rather than generating NATURAL JOINS, OpenJPA (versions 1.2.2, 2.0.1 and 2.1.0) tends to generate SELECT ... WHERE statements. Is that so only in my case, or Postgres Dictionary is just set up that way? Is there a way to force NATURAL JOINs since all my entities and tables are made such that PKs and FKs bear the same name? Thanks for the response! -- Rade Martinović, M.Sc.E.E Software engineer Belgrade University Computer Center Kumanovska 7, 126119 Beograd Serbia Tel: +381-11-3031258 Fax: +381-11-3031259 Email: r...@rcub.bg.ac.rs Internet: http://www.rcub.bg.ac.rs