Further to my previous post, here's the SQL that runs for 1.3.0-SNAPSHOT: 3725575 status TRACE [http-8080-3] openjpa.jdbc.SQL - <t 16080882, conn 21942248> executing prepstmnt 12167706 SELECT t0.ITMDES_ID, t0.DPLODR_NBR, t0.ITM_CDE, t0.ITM_DES FROM EBSTATUS.TBL_ITMDES t0 ORDER BY t0.DPLODR_NBR ASC 3725591 status TRACE [http-8080-3] openjpa.jdbc.SQL - <t 16080882, conn 21942248> [16 ms] spent 3732007 status TRACE [http-8080-3] openjpa.jdbc.SQL - <t 16080882, conn 26068553> executing prepstmnt 10680592 SELECT t0.ITMDES_ID, t0.DPLODR_NBR, t0.ITM_CDE, t0.ITM_DES FROM EBSTATUS.TBL_ITMDES t0 WHERE (t0.ITM_CDE = ?) [params=(String) AG]
Here's the SQL that runs for 1.1.0: 41425 status TRACE [http-8080-2] openjpa.jdbc.SQL - <t 32093323, conn 24359522> executing prepstmnt 17470437 SELECT t0.ITMDES_ID, t0.DPLODR_NBR, t0.ITM_CDE, t0.ITM_DES FROM EBSTATUS.TBL_ITMDES t0 WHERE (t0.ITM_CDE = ?) [params=(String) AG] 41425 status TRACE [http-8080-2] openjpa.jdbc.SQL - <t 32093323, conn 24359522> [0 ms] spent 41472 status TRACE [http-8080-2] openjpa.jdbc.SQL - <t 32093323, conn 24359522> executing prepstmnt 7416366 SELECT t0.TRKLNK_ID, t0.ITM_CDE, t0.ITMTYP_CDE, t2.ITMTYP_CDE, t2.VRS_NBR, t2.DPL_IND, t2.DPLODR_NBR, t2.ITMTYP_NME FROM EBSTATUS.TBL_TRKLNK t0 INNER JOIN EBSTATUS.TBL_ITMDES t1 ON t0.ITM_CDE = t1.ITM_CDE LEFT OUTER JOIN EBSTATUS.TBL_ITMTYP t2 ON t0.ITMTYP_CDE = t2.ITMTYP_CDE WHERE t1.ITMDES_ID = ? [params=(int) 882] 41487 status TRACE [http-8080-2] openjpa.jdbc.SQL - <t 32093323, conn 24359522> [15 ms] spent 41581 status TRACE [http-8080-2] openjpa.jdbc.SQL - <t 32093323, conn 11171851> executing prepstmnt 6381337 SELECT t0.ITMTYP_CDE, t0.VRS_NBR, t0.DPL_IND, t0.DPLODR_NBR, t0.ITMTYP_NME FROM EBSTATUS.TBL_ITMTYP t0 ORDER BY t0.DPLODR_NBR ASC 41597 status TRACE [http-8080-2] openjpa.jdbc.SQL - <t 32093323, conn 11171851> [16 ms] spent -- View this message in context: http://n2.nabble.com/Exception-in-SQLBuffer.java-on-OpenJPA-1.3.0-SNAPSHOT-tp1141997p1142007.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
