ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "guillen olmos, angel (ext)" <guillen.olmos.an...@servexternos.repsol.com>
Subject Help with HashMap mapping column name with point character
Date Wed, 01 Apr 2009 11:29:40 GMT
Hello,

I have a sqlMap (iBatis version = 2.3.0.677) with a procedure, the results are mapped to a
java.util.HashMap (java 1.4.2). It work fine.

<procedure id="select" parameterClass="java.util.Map" resultClass="java.util.HashMap" remapResults="true">
                {call  [dbo].[proc_MANTENIMIENTO_SELECT_ConsultaGenerica] (     #usuario:VARCHAR#,
                                                                                        #tabla:VARCHAR#,
                                                                                        #chrTipoOperacion:VARCHAR#,
                                                                                        #xml:TEXT#)}
</procedure>

But if the column names that the stored procedure returns include alias with the ('.') point
character it returns the following exception.

intIdEstablecimiento as [E.intIdEstablecimiento] , chrCAE, chrDescEstablecimiento

The data base server is a SQLServer 2000.

¿Alias with point character arre supported when working with HashMap or not? ¿Can I do something
different than remove that alias?

Thank you very much.

The exception:

org.springframework.jdbc.UncategorizedSQLException: Acceso a datos devolvió excepción no
controlada en la consulta, causa: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient
operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in com/repsolypf/sigefi/sigc/mantenimiento/dominio/MantenimientoGenerico.xml.
--- The error occurred while applying a result map.
--- Check the MantenimientoGenerico.selectCombo-AutoResultMap.
--- Check the result mapping for the 'chrDescEstablecimiento' property.
--- Cause: com.ibatis.common.beans.ProbeException: There is no WRITEABLE property named 'intIdEstablecimiento'
in class 'java.lang.Object'; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/repsolypf/sigefi/sigc/mantenimiento/dominio/MantenimientoGenerico.xml.
--- The error occurred while applying a result map.
--- Check the MantenimientoGenerico.selectCombo-AutoResultMap.
--- Check the result mapping for the 'chrDescEstablecimiento' property.
--- Cause: com.ibatis.common.beans.ProbeException: There is no WRITEABLE property named 'intIdEstablecimiento'
in class 'java.lang.Object' SqlMapClient operation; uncategorized SQLException for SQL [];
SQL state [null]; error code [0];
--- The error occurred in com/repsolypf/sigefi/sigc/mantenimiento/dominio/MantenimientoGenerico.xml.
--- The error occurred while applying a result map.
--- Check the MantenimientoGenerico.selectCombo-AutoResultMap.
--- Check the result mapping for the 'chrDescEstablecimiento' property.
--- Cause: com.ibatis.common.beans.ProbeException: There is no WRITEABLE property named 'intIdEstablecimiento'
in class 'java.lang.Object'; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/repsolypf/sigefi/sigc/mantenimiento/dominio/MantenimientoGenerico.xml.
--- The error occurred while applying a result map.
--- Check the MantenimientoGenerico.selectCombo-AutoResultMap.
--- Check the result mapping for the 'chrDescEstablecimiento' property.
--- Cause: com.ibatis.common.beans.ProbeException: There is no WRITEABLE property named 'intIdEstablecimiento'
in class 'java.lang.Object'
sentencia= MantenimientoGenerico.selectCombo
 - objeto de entrada = class: class java.util.HashMap
; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; 21004; nested exception
is java.sql.SQLException: 21004
Caused by: java.sql.SQLException: 21004
        at com.repsolypf.sigefi.soporte.dao.DAOGenericoIbatisImpl.find(DAOGenericoIbatisImpl.java:107)
        at com.repsolypf.sigefi.sigc.mantenimiento.dao.DAOMantenimientosImpl.selectCombo(DAOMantenimientosImpl.java:88)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:280)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Refl

Thanks



Thanks


Mime
View raw message