Dashboard > iBATIS DataMapper > 2005 > December > 27 > error in parameter mapping for java.util.Date using oracle
error in parameter mapping for java.util.Date using oracle
Added by Fishel Gonzalez Berenstein, last edited by Fishel Gonzalez Berenstein on Dec 27, 2005
Labels: 
(None)

Hi i am using this parameterMap

<parameterMap id="licenciaParametros" class="map">
<parameter property="fechaInicio" jdbcType="Date" javaType="java.util.Date" mode="IN"/>
<parameter property="fechaFin" jdbcType="Date" javaType="java.util.Date" mode="IN"/>
<parameter property="IdtipoServicio" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="Idcentro" jdbcType="INTEGER" javaType="java.lang.Integer" mode="IN"/>
<parameter property="Idclase" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="Idcategoria" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
</parameterMap>

and i am getting an exception
aused by: com.ibatis.dao.client.DaoException: Failed to queryForList - id [PLCT_LICENCIA.LISTAR_NUEVAS_LICENCIAS], parameterObject [

Unknown macro: {Idcentro=1, fechaFin=Tue Dec 27 09}
]. Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in gob/pe/mtc/siict/dat/licencias/ibatis/sqlmapdao/sql/PLCT_LICENCIA.xml.
— The error occurred while applying a parameter map.
— Check the Licencia.licenciaParametros.
— Check the parameter mapping for the 'fechaInicio' property.
— Cause: java.sql.SQLException: Índice de columna no válido
Caused by: java.sql.SQLException: Índice de columna no válido
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in gob/pe/mtc/siict/dat/licencias/ibatis/sqlmapdao/sql/PLCT_LICENCIA.xml.
— The error occurred while applying a parameter map.
— Check the Licencia.licenciaParametros.
— Check the parameter mapping for the 'fechaInicio' property.
— Cause: java.sql.SQLException: Índice de columna no válido
Caused by: java.sql.SQLException: Índice de columna no válido

i suppose it is the mapping but i dont know what is wrong any help will be welcome


Site running on a free Atlassian Confluence Open Source Project License granted to OSS. Evaluate Confluence today.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.5.5 Build:#811 Jul 25, 2007) - Bug/feature request - Contact Administrators