I'm also seeing this problem on queryForList, but I don't know how to resolve
it.
<select id="select_asn" parameterClass="java.util.Map"
resultClass="java.util.ArrayList">
SELECT spriden_pidm
FROM spriden,
spbpers
WHERE spriden_pidm = spbpers_pidm
AND spbpers_vetc_file_number = #asn#
AND spriden_change_ind IS NULL
</select>
This returns an empty list, but it should not. It should either be throwing an
error, or returning my list.
What can I do to resolve this one? This is what I'm doing...
parameters.put("asn", "2323232");
result = sqlMapper.queryForList("select_asn", parameters);
System.out.println("map: " + result);
Thanks.
Trenton D. Adams
Systems Analyst/Web Software Engineer
Navy Penguins at your service!
Athabasca University
(780) 675-6195
:wq!
----- "Trenton D. Adams" <[email protected]> wrote:
> From: "Trenton D. Adams" <[email protected]>
> To: [email protected]
> Sent: Tuesday, July 28, 2009 12:13:39 PM GMT -07:00 US/Canada Mountain
> Subject: queryForMap bug
>
> 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 = '2323232'
> 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 = '2323232'
> 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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
