ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Trenton D. Adams" <tre...@athabascau.ca>
Subject queryForMap bug
Date Tue, 28 Jul 2009 18:13:39 GMT
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-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message