Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of icarusdb@gmail.com designates
 74.125.44.152 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:mime-version:content-type
         :content-transfer-encoding:content-disposition;
        b=XEkoYl8i5jd9KhPRmtDUN9zpO1P6UcZI88tkOr6PAw+M0Fof0PaqEjS4W//a3zCsUf
         gDKSkm7uIiQjssJdjSNRqD3txL/ywsFbb0w5XyT4KgZL8pTutSSgiqyPOhIv9kKdEPCt
         nyOiBs6MiNveBAMQenKlFlxiymid7QyCsJ5ok=
Message-ID: <66e1c2180812030617t4c278976j6cdf48ae98913e97@mail.gmail.com>
Date: Wed, 3 Dec 2008 10:17:03 -0400
From: "Betto McRose Gamarra" <icarusdb@gmail.com>
To: "ibatis java users" <user-java@ibatis.apache.org>
Subject: blob type support...
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

hi all
this is the error trace:
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Caused by: java.lang.RuntimeException: Error lazy loading result.
Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
py/com/sif/dna/sgc/persistence/sqlmap/sql/RevisionDocumento.xml.
--- The error occurred while applying a result map.
--- Check the RevisionDocumento.getRevisionDocumentoByDocumentoSgcId-AutoRe=
sultMap.
--- Check the result mapping for the 'imagen' property.
--- Cause: com.ibatis.sqlmap.client.SqlMapException: No type handler
could be found to map the property 'imagen' to the column 'IMAGEN'.
One or both of the types, or the combination of types is not
supported.
=09at com.ibatis.sqlmap.engine.mapping.result.loader.EnhancedLazyResultLoad=
er$EnhancedLazyResultLoaderImpl.loadObject(EnhancedLazyResultLoader.java:13=
9)
=09at com.ibatis.sqlmap.engine.mapping.result.loader.EnhancedLazyResultLoad=
er$EnhancedLazyResultLoaderImpl.invoke(EnhancedLazyResultLoader.java:120)
=09at $java.util.Set$$EnhancerByCGLIB$$b291e667.iterator(<generated>)

this is sql statement:
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
    <sql id=3D"searchAll">
        SELECT
            RD.ID                AS id,
            RD.ID_DOCUMENTO      AS idDocumento,
            RD.REVISION          AS revision,
            RD.FECHA_INGRESO     AS fechaIngreso,
            RD.FECHA_INICIO_VIG  AS fechaInicioVigencia,
            RD.IMAGEN            AS imagen,
            RD.APROBADO          AS aprobado,
            RD.ID_ULTIMO_USUARIO AS idUltimoUsuario,
            RD.FECHA_ULTIMA_ACT  AS fechaUltimaAct,
            RD.TRN               AS trn,
            SGC.NOMBRE           AS nombreDocumento,
            SGC.ESTADO           AS estadoCode,
            INFO.ABREVIATURA     AS estadoAbreviatura,
            INFO.DESCRIPCION     AS estadoDescripcion

        FROM REVISION_DOCUMENTO RD,
             DOCUMENTO_SGC SGC,
             INFO_REF_OPC INFO

        WHERE RD.ID_DOCUMENTO =3D SGC.ID
          AND SGC.ESTADO =3D INFO.ID
    </sql>

    <select id=3D"getRevisionDocumentoByDocumentoSgcId"
resultClass=3D"revisionDocumento"
            parameterClass=3D"java.lang.Long" >
            <include refid=3D"RevisionDocumento.searchAll"/>
            AND SGC.ID =3D #id#
    </select>

everything else not showed like class name are correctly defined

as you can see in my <select /> I use resultClass and not resultMap

so, What do I do ?


--=20
Betto McRose Gamarra
IcarusDB
"Soluciones Inform=E1ticas"
Cel.: +595 992 686947