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: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org