Hi Guys,
I found a kind of annoying bug, which took me a few minutes to track down...
If I do a query for map on this, it returns an empty map.
<select id="select_asncount" parameterClass="java.util.Map">
SELECT spriden_pidm
FROM spriden,
spbpers
WHERE spriden_pidm = spbpers_pidm
AND spbpers_vetc_file_number = '760429944'
AND spriden_change_ind IS NULL
</select>
If I do it on this, it works just fine.
<select id="select_asncount" parameterClass="java.util.Map"
resultClass="java.util.Hashtable">
SELECT spriden_pidm
FROM spriden,
spbpers
WHERE spriden_pidm = spbpers_pidm
AND spbpers_vetc_file_number = '760429944'
AND spriden_change_ind IS NULL
</select>
If it is an error to not have a resultXXX attribute, then it should throw an
exception, not return an empty list. I am using a maven dependency...
<dependency>
<groupId>org.apache.ibatis</groupId>
<artifactId>ibatis-sqlmap</artifactId>
<version>2.3.4.726</version>
</dependency>
Trenton D. Adams
Systems Analyst/Web Software Engineer
Navy Penguins at your service!
Athabasca University
(780) 675-6195
:wq!
__
This communication is intended for the use of the recipient to whom it
is addressed, and may contain confidential, personal, and or privileged
information. Please contact us immediately if you are not the intended
recipient of this communication, and do not copy, distribute, or take
action relying on it. Any communications received in error, or
subsequent reply, should be deleted or destroyed.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
