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: Ibator..
Date Tue, 03 Feb 2009 16:39:40 GMT
That will work, but it's a pretty complex solution for a simple problem.

I think that you could do an override in your configuration to set the
JDBC type to VARCHAR:

<table tableName="ATECO">
  <columnOverride column="DESCR" jdbcType="VARCHAR"/>
</table>

Jeff Butler




On Tue, Feb 3, 2009 at 9:42 AM, Iwao AVE! <harawata@gmail.com> wrote:
> Hi Eugenio,
>
> LONGVARCHAR is translated as a BLOB type by ibator.
> To overcome this behavior, create a subclass of IntrospectedColumn
> and specify it in the ibatorContext element.
>
> - MySqlIntrospectedColumn.java
> package yourpkg;
>
> import org.apache.ibatis.ibator.api.IntrospectedColumn;
>
> public class MySqlIntrospectedColumn extends IntrospectedColumn
> {
>  @Override
>  public boolean isBLOBColumn()
>  {
>    boolean result = super.isBLOBColumn();
>    return result && !"LONGVARCHAR".equals(getJdbcTypeName());
>  }
> }
>
> - ibatorConfig.xml
> <ibatorContext
>  introspectedColumnImpl="yourpkg.MySqlIntrospectedColumn"
>  ... >
>
> HTH,
> Iwao
>
> on 09.2.3 11:16 PM Riccetti Eugenio said the following:
>> Hi,
>> I used ibator to create mapper. I have a table:
>>
>> ATECO having CHIAVE and DESCR. DESCR is a mediumtext datatype.
>> I use MySql.
>>
>> Ibator has generated:
>>
>> <sqlMap namespace="ATECO" >
>>
>> <resultMap id="abatorgenerated_AtecoResult"
>> class="it.pitagora.bignet.common.data.Ateco" >
>>
>> <result column="CHIAVE" property="chiave" jdbcType="VARCHAR" />
>>
>> </resultMap>
>>
>> <resultMap id="abatorgenerated_Ateco02ResultWithBLOBs"
>> class="it.pitagora.bignet.common.data.Ateco"
>> extends="ATECO02.abatorgenerated_Ateco02Result" >
>>
>> <result column="DESCR" property="descr" jdbcType="LONGVARCHAR" />
>>
>> </resultMap
>>
>> ......
>>
>> But the class AtecoExample not contain the methods for the column DESCR.
>>
>> Why ibator not create the methods?
>>
>> Thanks for your help,
>>
>> Eugenio
>>
>
>

Mime
View raw message