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
