ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Poitras Christian" <Christian.Poit...@ircm.qc.ca>
Subject RE: output parameters (register output parameters failed).
Date Tue, 30 Jan 2007 14:58:50 GMT
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