openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ravi P Palacherla <ravi.palache...@oracle.com>
Subject Re: Wrong SQL statement being generated
Date Mon, 30 Apr 2012 02:38:32 GMT
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.

Mime
View raw message