ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Maves <Nathan.Ma...@Sun.COM>
Subject Re: When to use jdbcType or javaType
Date Thu, 03 Aug 2006 22:08:27 GMT
I would suggest that you do use the jdbcType attribute.  This always  
helps with inserting null values into a table.

Nathan

On Aug 3, 2006, at 3:02 PM, jaybytez wrote:

>
> I have been using both jdbcType and javaType everytime when creating a
> parameterMap or resultMap.  Is this necessary?  I am using standard  
> drivers
> for Oracle 9i.  I read the documentation, but was not totally clear  
> if there
> are performance issues or scalability issues by not doing this?  I  
> am just
> trying to figure out whether its always necessary so I can simplify  
> the sql
> map files for developers and so they don't have to add unnecessary
> configuration.  Is it only necessary when a value maybe null or  
> using a type
> handler?
>
>   <resultMap id="zipCodeRegion" class="providerZipCodeTO">
>     <result property="zipCode" column="zrl_zip_code"  
> jdbcType="VARCHAR"
> javaType="string"/>
>     <result property="region" column="zrl_region_cd"  
> jdbcType="VARCHAR"
> javaType="string"/>
>     <result property="state" column="zrl_state" jdbcType="CHAR"
> javaType="string"/>
>     <result property="tprZipCode" column="zrl_tpr_zip_flag"  
> jdbcType="CHAR"
> javaType="string"/>
>   </resultMap>
>
>   <parameterMap id="loadLogParameters" class="java.util.Map">
>     <parameter property="startTime" jdbcType="TIMESTAMP"
> javaType="java.sql.Timestamp"/>
>     <parameter property="userId" jdbcType="VARCHAR"  
> javaType="string"/>
>   </parameterMap>
>
> Thanks,
>
> Jay
> -- 
> View this message in context: http://www.nabble.com/When-to-use- 
> jdbcType-or-javaType-tf2048046.html#a5640671
> Sent from the iBATIS - User - Java forum at Nabble.com.
>


Mime
View raw message