ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: output parameters (register output parameters failed).
Date Tue, 30 Jan 2007 16:57:35 GMT
According to this:

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#34_05

Oracle JDBC does not support, and does not ever plan to support, the BOOLEAN
datatype.

Jeff Butler



On 1/30/07, Poitras Christian <Christian.Poitras@ircm.qc.ca> wrote:
>
>  Does anyone know if it is possible to have a parameterMap with OUT
> parameters and a resultMap for the same procedure?
>
> Christian
>
>  ------------------------------
> *From:* Diego Umpierre [mailto:diego@umpierre.com.br]
> *Sent:* Monday, 29 January 2007 16:16
> *To:* user-java@ibatis.apache.org
> *Subject:* output parameters (register output parameters failed).
>
>
>  Hi all,
>
>
> My problem is:
>
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in
> br/com/lojasrenner/logistica/legadoebs/dao/integra_nt/mapping/ProcExecEbsDAOintegra_nt.xml.
>
> --- The error occurred while executing query procedure.
> --- Check the {call RN_AR_001_P(?,?,?, ?)}.
> --- Check the output parameters (register output parameters failed).
> --- Cause: java.sql.SQLException: Tipo de coluna inválido (column type not
> valid)
> Caused by: java.sql.SQLException: Tipo de coluna inválido
>
> my xml register and call is:
>
>     <parameterMap id="parameters" class="Map" >
>         <parameter property="codEmitenteSessao" jdbcType="INT"
> javaType=" java.lang.Integer"  mode="IN"/>
>         <parameter property="data"              jdbcType="DATE"
> javaType="java.util.Date"     mode="IN"/>
>                 <parameter property="numIdentificador"  jdbcType="INT"
> javaType=" java.lang.Integer"   mode="IN"/>
>         <parameter property="paramOut"          jdbcType="BOOLEAN"
> javaType="java.lang.Boolean"   mode="OUT"/>
>
>     </parameterMap>
>
>         <resultMap id="result_consome" class="ProcExecEbs">
>             <result property="executeErro" />
>         </resultMap>
>
>     <procedure id="consome" resultMap="result_consome"
> parameterMap="parameters">
>         {call RN_AR_001_P(?,?,?, ?)}
>     </procedure>
>
> the procedure in oracle is:
>
> create or replace PROCEDURE rn_ar_001_p
>   (P_ORIGEM_NF          In   NUMBER
>   ,P_DAT_PADRAO_EMI_NF  In   DATE
>   ,P_NUMERO_PLANILHA    In   NUMBER
>   ,P_RESULTADO          OUT  Boolean)
> AS
>    BEGIN
>       P_RESULTADO := TRUE;
>    END RN_AR_001_P;
>
>
>
> So anyone can help me ?
>
>
> --
> Diego Umpierre
>
>

Mime
View raw message