ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Maves <Nathan.Ma...@Sun.COM>
Subject Re: [Fwd: ibatis and oracle 7.]
Date Tue, 24 Jan 2006 20:16:30 GMT
Here is a little bit more info on this issue.

The database is run by cards....  Yes Oracle 7!

Notice in the query that we alias the columns... yet in the result  
set log you only see a few of them.  Right now the result class is a  
HashMap for debugging purposes.

Could the JDBC 10g drivers be causing the issue?

Nathan


On Jan 24, 2006, at 1:06 PM, Diran Ayandele wrote:

> 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