Unnecessary Join on bidirectional OneToOne relation

2011-10-17 Thread Tobias Trelle
Hi, our DBAs detected a strange SQL statement in conjunction w/ a bidirectional one-to-one relationship between entities. I compiled a minimal example that demonstrates the case: When querying an entity of type A the following SQL is executed: The select starts at table A and performs a

Re: Named Queries

2011-10-17 Thread Tobias Trelle
rjdevet wrote: In OpenJPA, merchHier.orm.xml file is not recognized, tried few options of renaming the file orm.xml and other suggested options, but nothing worked. The JPA spec suggests to put the O/R mapping definition into META-INF/orm.xml somewhere in the classpath. rjdevet

Re: Unnecessary Join on bidirectional OneToOne relation

2011-10-17 Thread Rick Curtis
https://issues.apache.org/jira/browse/OPENJPA-292 which seems to be unresolved. You are correct that the JIRA is unresolved... but but it appears that some code was committed. By looking at the unit tests, it looks like the issue may have been resolved. How are you mapping this relationship? Can