You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Clinton Begin (JIRA)" <ib...@incubator.apache.org> on 2005/02/12 23:15:15 UTC
[jira] Closed: (IBATIS-21) Fixed JDBC types being ignored for hashmap result map
[ http://issues.apache.org/jira/browse/IBATIS-21?page=history ]
Clinton Begin closed IBATIS-21:
-------------------------------
Assign To: Clinton Begin
Resolution: Cannot Reproduce
Can't reproduce, nobody confirmed. This looks like a platform or JDBC driver issue. My recommendation: Don't use maps if you care about type safety.
> Fixed JDBC types being ignored for hashmap result map
> -----------------------------------------------------
>
> Key: IBATIS-21
> URL: http://issues.apache.org/jira/browse/IBATIS-21
> Project: iBatis for Java
> Type: Bug
> Components: SQL Maps
> Versions: 2.0.8
> Environment: JDK 1.4, Tomcat 5.0.27, Spring 1.1, Oracle 9i
> Reporter: Harold Neiper
> Assignee: Clinton Begin
> Priority: Minor
>
> I am populating a Map instance [HashMap] and trying to set the java type for the return value of the first column in my result map. The column type in the DB is Number and is currently returning as java type BigDecimal. However, I would prefer that it be set to a String type in my result map.
> In the developer guide the javaType is listed as optional. However, it is unclear as to whether these options are only available for Result Maps that are mapping to JavaBean properities or for the likes of all types of Result Maps (in this case a Map instance).
> Here is my result map below:
> <resultMap id="authenticatedUserResult" class="java.util.HashMap">
> <result property="_userId" column="app_user_objid" javaType="string"/>
> <result property="_userAuthInfoId" column="app_user_auth_info_objid"/>
> <result property="_userName" column="user_id"/>
> <result property="_userPassword" column="encrypted_pwd_txt"/>
> <result property="_userValidFlag" column="valid_flag"/>
> </resultMap>
> Here is the mapped statement:
> <select id="getAuthenticatedUser"
> parameterClass="java.util.Map"
> resultMap="authenticatedUserResult">
> select au.app_user_objid
> , auai.app_user_auth_info_objid
> , au.user_id
> , auai.encrypted_pwd_txt
> , auai.valid_flag
> from app_user au
> , app_user_auth_info auai
> where au.user_id = #_userName#
> and auai.app_user_fk = au.app_user_objid
> </select>
> And the dao code:
> public Map getAuthenticatedUser(Map userMap)
> throws DataAccessException {
>
> return (HashMap) getSqlMapClientTemplate().queryForObject(SQL_MAP_GET_AUTHENTICATED_USER, userMap);
> }
> thx - harold
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira