openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From egoosen <egoos...@metropolitan.co.za>
Subject Re: Exception in SQLBuffer.java on OpenJPA 1.3.0-SNAPSHOT
Date Fri, 03 Oct 2008 13:50:31 GMT

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.


Mime
View raw message