Anyone get a chance to look at this yet?
On Jan 25, 2005, at 3:36 PM, Nathan Maves wrote:
Here is our sqlmap query
<select id="getShipped" resultClass="java.util.HashMap">
select al1.parts__t as part, SUM(al1.qty_despatched) as shipped
from despatch AL1, despatch_header AL2
where AL1.despatch_note__T = al2.despatch_note__T and
trunc(AL2.despatch_date,'MON') = add_months(trunc(sysdate,'MON'),-1)
AND AL1.request_orig in ('BRR','CM')
group by al1.parts__t
</select>
And the logs....
DEBUG 01-25 13:32:39 Created connection 23667197. (SimpleDataSource.java:480)
DEBUG 01-25 13:32:39 {conn-100000} Connection (ConnectionLogProxy.java:24)
DEBUG 01-25 13:32:39 {pstm-100001} PreparedStatement: select al1.parts__t as part, SUM(al1.qty_despatched) as shipped
from despatch AL1, despatch_header AL2 where AL1.despatch_note__T = al2.despatch_note__T and trunc(AL2.despatch_date,'MON') = add_months(trunc(sysdate,'MON'),-1) AND AL1.request_orig in ('BRR','CM') group by al1.parts__t (PreparedStatementLogProxy.java:30)
DEBUG 01-25 13:32:39 {pstm-100001} Parameters: [] (PreparedStatementLogProxy.java:31)
DEBUG 01-25 13:32:39 {pstm-100001} Types: [] (PreparedStatementLogProxy.java:32)
DEBUG 01-25 13:36:20 {rset-100002} ResultSet (ResultSetLogProxy.java:25)
DEBUG 01-25 13:36:21 {rset-100002} Header: [, PART] (ResultSetLogProxy.java:45)
DEBUG 01-25 13:36:21 {rset-100002} Result: [100-6889, 44] (ResultSetLogProxy.java:49)
DEBUG 01-25 13:36:21 {rset-100002} Result: [100-7192, 1] (ResultSetLogProxy.java:49)
DEBUG 01-25 13:36:21 {rset-100002} Result: [100-7270, 7] (ResultSetLogProxy.java:49)
Why is the first field null in the Header of the ResultSet? "PART" should be the first element in the header.
Nathan
