ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From nando.dev <nando....@gmail.com>
Subject Re: question with boolean types..
Date Sat, 23 Sep 2006 19:41:02 GMT
Hi Esperanza, the problem do you have is the type boolean of pl/sql isn´t
standard of JDBC, so do you have to write a wrapper to this function.

2006/6/26, Esperanza.Echeverria@steria.es <Esperanza.Echeverria@steria.es>:
>
>
> please, can anyone help me?
> my problem is calling a stored procedure in ibatis and this functioncalled in pl/sql
returns a boolean and i don´t know what are the correct
> types in this case to be put in for no obtain an error ...
>
> <parameterMap id="misParametros" class="java.util.HashMap" >
>     <parameter property="parametro1" jdbcType="VARCHAR" javaType="
> java.lang.Boolean" mode="OUT"/>
>     <parameter property="parametro2" jdbcType="VARCHAR" javaType="
> java.lang.String" mode="IN"/>
>     <parameter property="parametro3" jdbcType="VARCHAR" javaType="
> java.lang.String" mode="IN"/>
>     <parameter property="parametro4" jdbcType="VARCHAR" javaType="
> java.lang.String" mode="IN"/>
>     <parameter property="parametro5" jdbcType="VARCHAR" javaType="
> java.lang.String" mode="IN"/>
>   </parameterMap>
>  <procedure id="ejecutaTieneDuplicados" parameterMap="misParametros" >
>     {? = call report.tiene_duplicados(?,?,?,?)}
>   </procedure>
>
> the out parameter tells me an error :
> DEBUG - {conn-100021} Connection
> DEBUG - {pstm-100022} PreparedStatement: {? = call report.tiene_duplicados
> (?,?,?,?)}
> DEBUG - {pstm-100022} Parameters: [JOSELUIS, sip97.rep, VCENTRO=90101,
> 19-06-2006]
> DEBUG - {pstm-100022} Types: [java.lang.String, java.lang.String,
> java.lang.String, java.lang.String]
> DEBUG - Initializing, config='org.apache.struts.action.LocalStrings',
> returnNull=true
> 06/06/26 08:47:37 DaoException
> ERROR - Ha ocurrido un error con la base de datos
> com.ibatis.dao.client.DaoException: Failed to execute queryForObject - id
> [ejecutaTieneDuplicados], parameterObject [{parametro4=VCENTRO=90101,
> parametro2=JOSELUIS, parametro3=sip97.rep, parametro1=true,
> parametro5=19-06-2006}].  Cause:
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in
> com/ibatis/sip/persistence/sqlmapdao/sql/Lis.xml.
> --- The error occurred while applying a parameter map.
> --- Check the Lis.misParametros.
> --- Check the statement (update procedure failed).
> --- Cause: java.sql.SQLException: ORA-06550: línea 1, columna 13:
> PLS-00382: el tipo de la expresión no es correcto
> ORA-06550: línea 1, columna 7:
> PL/SQL: Statement ignored
>
>
>
>
>   *Esperanza Echeverría de Miguel*
> Steria España *http://www.steria.es* <http://www.steria.es/>
> C/Menéndez y Pelayo,3 bis 46010 Valencia
> Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
> esperanza.echeverria@steria.es
>
>
>
>
>
>

Mime
  • Unnamed multipart/related (inline, None, 0 bytes)
View raw message