ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <larry.mead...@gmail.com>
Subject Re: Problems with Dynamic SQL
Date Wed, 22 Oct 2008 16:34:59 GMT
If you put xml tags in a cdata section, they are ignored...that's the
point of the cdata section...

Larry


On Wed, Oct 22, 2008 at 10:19 AM, Yamil Bracho <yamilbracho@hotmail.com> wrote:
> Hi.
> I have this mapping
>
>     <select id="SolAfi.findAllByBancoRif"
>             parameterClass="java.util.HashMap"
>             resultMap="mapSolAfi">
>             <![CDATA[
>                 SELECT co_afiliacion,
>                         nu_rif,
>                         nb_empresa,
>                         cce.solicitud_afiliacion.co_sector,
>                         cce.sector.nb_sector,
>                         cce.solicitud_afiliacion.co_banco,
>                         cce.banco.nb_banco,
>                         ti_solicitud,
>                         st_solicitud,
>                         fe_registro,
>                         co_usuario,
>                         fe_respuesta,
>                         co_funcionario,
>                         nb_nota
>                FROM cce.solicitud_afiliacion, cce.banco, cce.sector
>                WHERE cce.solicitud_afiliacion.co_banco = #codigoBanco# AND
>                      cce.solicitud_afiliacion.co_banco = cce.banco.co_banco
> AND
>                      cce.solicitud_afiliacion.co_sector =
> cce.sector.co_sector AND
>             <dynamic prepend=" nu_rif IN ">
>             <iterate property="rifList" open="('" close="')" conjunction=",
> ">
>                  #rifList[]#
>             </iterate>
>             </dynamic>
>             ]]>
>     </select>
>
> Where nu_rif is a String field and rifList is an array o String.
> In java I did:
>
>         Map parameters = new HashMap();
>         parameters.put("codigoBanco", codigoBanco);
>
>         parameters.put("rifList",  rifList.split(","));
>
>         return
> getSqlMapClientTemplate().queryForList("SolAfi.findAllByBancoRif",
> parameters);
>
> However I am getting  Error getting ordinal list from JavaBean. Cause
> java.lang.NumberFormatException: For input string: ""
> nu_rif are string like 'E12345', 'J4567', etc
>
> When I take out the dynamic part the code works OK but I need the dynamic
> part..
>
> Any hint ?
>
> TIA
>
> Yamil
>
>
> ________________________________
> ¡Trónchate de risa con los mejores capítulos de South Park en MSN Vídeo!

Mime
View raw message