Unable to replicate the issue on oracle DB. openJPA version: OpenJPA 1.2.3-SNAPSHOT
Here is the SQL I am seeing: SELECT t0.ID, t1.EXPORT_ORDER_ID, t1.VM_ID FROM weblogic.EXPORT_ORDER t0, weblogic.EXPORT_ORDER_VM t1 WHERE t0.ID = t1.EXPORT_ORDER_ID ORDER BY t0.ID ASC Testcase is here: http://openjpa.208410.n2.nabble.com/file/n7512197/openjpa123_testcase.jar openjpa123_testcase.jar It was run against oracle DB: mvn test -Dtest=TestNamedQuery -DfailIfNoTests=false -Ptest-custom -Dopenjpa.custom.driverjar=/scratch/rpalache/WLS/WLS10MP2/wlserver_10.0/server/lib/ojdbc14.jar -Dopenjpa.custom.driverclass=oracle.jdbc.driver.OracleDriver -Dopenjpa.custom.url=jdbc:oracle:thin:@ -Dopenjpa.custom.username= -Dopenjpa.custom.password= I developed the testcase from the source code posted in this thread. Regards, Ravi. -- View this message in context: http://openjpa.208410.n2.nabble.com/Wrong-SQL-statement-being-generated-tp7470306p7512197.html Sent from the OpenJPA Users mailing list archive at Nabble.com.