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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] *Sent:* Monday, 29 January 2007 16:16 *To:* [email protected] *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
