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 keyProperty null
Date Tue, 28 Jul 2009 18:38:24 GMT
Hi Guys,

I'm curious about something.  When I call queryForMap, and set the keyProperty to something,
and it is lower case, when using oracle, the key is being set to null.

result = sqlMapper.queryForMap("select_asn", parameters, "pidm");
System.out.println("map: " + result);

output...
map: {null={PIDM=216330}}

But, if I use uppercase, as what happens with oracle results anyhow, it works just fine.
result = sqlMapper.queryForMap("select_asn", parameters, "PIDM");
System.out.println("map: " + result);

output...
map: {216330={PIDM=216330}}


So, I'm wondering, is it a universal SQL thing that column names end up as upper case?  If
not, perhaps iBatis should be forcing them to uppercase, as well as the key property?

Thanks.
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