thanks Jeff for your time
1. Blob
2. In my bean I used java.sql.Blob
surfing a while in the internet I found a solution for this
1. use a resultMap
2. specify for imagen property
javaType="[B"
jdbcType="BLOB"
On Wed, Dec 3, 2008 at 17:02, Jeff Butler <[EMAIL PROTECTED]> wrote:
> The error message states that the database type and the java type are
> not compatible with iBATIS default type handling.
>
> 1. What is the DB field type for IMAGEN?
> 2. What is the Java type for the imagen property in the result class?
>
> Jeff Butler
>
> On Wed, Dec 3, 2008 at 8:17 AM, Betto McRose Gamarra <[EMAIL PROTECTED]>
> wrote:
>> hi all
>> this is the error trace:
>> ==============
>> 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-AutoResultMap.
>> --- 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.
>> at
>> com.ibatis.sqlmap.engine.mapping.result.loader.EnhancedLazyResultLoader$EnhancedLazyResultLoaderImpl.loadObject(EnhancedLazyResultLoader.java:139)
>> at
>> com.ibatis.sqlmap.engine.mapping.result.loader.EnhancedLazyResultLoader$EnhancedLazyResultLoaderImpl.invoke(EnhancedLazyResultLoader.java:120)
>> at $java.util.Set$$EnhancerByCGLIB$$b291e667.iterator(<generated>)
>>
>> this is sql statement:
>> =============
>> <sql id="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 = SGC.ID
>> AND SGC.ESTADO = INFO.ID
>> </sql>
>>
>> <select id="getRevisionDocumentoByDocumentoSgcId"
>> resultClass="revisionDocumento"
>> parameterClass="java.lang.Long" >
>> <include refid="RevisionDocumento.searchAll"/>
>> AND SGC.ID = #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 ?
>>
>>
>> --
>> Betto McRose Gamarra
>> IcarusDB
>> "Soluciones Informáticas"
>> Cel.: +595 992 686947
>>
>
--
Betto McRose Gamarra
IcarusDB
"Soluciones Informáticas"
Cel.: +595 992 686947
