ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: javaTypes and jdbcTypes in result maps
Date Fri, 27 Jul 2007 03:14:10 GMT
I did a fairly extensive test on this a year or so ago.  I found no
discernable performance difference either way.

As with all performance claims - your milage may vary.  It's best to try it
out in your environment to verify.

Jeff Butler



On 7/26/07, Tom Henricksen <TomH@a-t-g.com> wrote:
>
>  A co-worker who uses the .Net version of iBatis mentioned that it is
> strongly suggested to add javaTypes and jdbcTypes in resultMaps.  I presume
> this is the same for Java?
>
>
>
> This:
>
> <result property="provider.rowVersion" column="H_PRVDRID" jdbcType="int"
> javaType="java.lang.Integer" />
>
>
>
> instead of this:
>
> <result property="provider.rowVersion" column="H_PRVDRID" />
>
>
>
> They said that doing this in Java they noticed a faster initial response
> than without.  I imagine the reflection used to determine the types is time
> consuming.  Then after that they run the same.  I presume the types are
> cached somehow?  Also how long does it cache?  Is that determined on
> available memory or some other setting?
>
>
>
>
> http://www.nabble.com/When-to-use-jdbcType-or-javaType-tf2048046.html#a5748022
>
>
>
> According to this they may help performance and are useful in resultMaps,
> correct?
>
>
>
>
>
> Thanks,
>
>
>
> *Tom Henricksen*
> Consultant
> Advanced Technologies Group, Inc.
>

Mime
View raw message