ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Diran Ayandele <Adediran.Ayand...@Sun.COM>
Subject [Fwd: ibatis and oracle 7.]
Date Tue, 24 Jan 2006 20:06:37 GMT
Hi,

   I have an old database that I need to extract some information 
from.  When the query runs it appears to work fine, but the result set 
is bizarre.  It seems to repeat the first columnm and the headers don't 
align.

DEBUG 01-24 10:38:27 {pstm-100001} PreparedStatement:              
SELECT AL1.EXTERNAL_CALL_NO one,                 AL1.PARTS__T 
two,                 (SUM(AL1.QTY_DESPATCHED)) qtyfoo,                 
AL1.REQUEST_ORIG three ,                 AL4.RESPONSE_TYPE_DFLT__C 
four,                 trunc(AL2.DESPATCH_DATE) orddate,                 
(STD_PRICE_FN(AL1.PARTS__T, AL1.REVISION, 
AL2.DESPATCH_DATE,AL2.DESPATCH_DATE)) COST,                 
AL5.PART_DESC five             FROM DESPATCH AL1, DESPATCH_HEADER AL2, 
EMPLOYEES AL3, ENG_REQUEST_HDR AL4,                 PARTS_DESCRIPTION 
AL5             WHERE ( AL1.TO_LOC = AL3.EMPLOYEES__KEY (+)   AND 
AL1.DESPATCH_NOTE__T=AL2.DESPATCH_NOTE__T   AND 
AL1.REQUEST__T=AL4.ENG_REQUEST__T)   AND (AL4.REQUEST_ORIG IN ('BRR', 
'CM', 'MTM15', 'MTM5')         AND AL1.EXTERNAL_CALL_NO 
IN(                 '64835683'         ,                 
'64839087'         )   ) AND AL1.PARTS__T = AL5.PARTS__T   AND 
AL2.DESPATCH_DATE >= sysdate-180             GROUP BY 
AL1.EXTERNAL_CALL_NO, AL1.PARTS__T,AL1.REQUEST_ORIG,                 
AL4.RESPONSE_TYPE_DFLT__C,trunc(AL2.DESPATCH_DATE),                 
STD_PRICE_FN(AL1.PARTS__T, AL1.REVISION,                 
AL2.DESPATCH_DATE,AL2.DESPATCH_DATE),AL5.PART_DESC       
(PreparedStatementLogProxy.java:30)
DEBUG 01-24 10:38:27 {pstm-100001} Parameters: []  
(PreparedStatementLogProxy.java:31)
DEBUG 01-24 10:38:27 {pstm-100001} Types: []  
(PreparedStatementLogProxy.java:32)
DEBUG 01-24 10:38:27 {rset-100002} ResultSet  (ResultSetLogProxy.java:25)
DEBUG 01-24 10:38:28 {rset-100002} Header: [, , ONE, TWO, , QTYFOO, , ]  
(ResultSetLogProxy.java:45)
DEBUG 01-24 10:38:28 {rset-100002} Result: [60000000, 60000000, 1, BRR, 
60000000, 2005-12-09 00:00:00.0, 60000000, 60000000]  
(ResultSetLogProxy.java:49)
DEBUG 01-24 10:38:28 {rset-100002} Result: [60000001, 60000001, 1, BRR, 
60000001, 2005-12-08 00:00:00.0, 60000001, 60000001]  
(ResultSetLogProxy.java:49)

Anyone encounter anything like this before?

Diran



Mime
View raw message