You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Diego Umpierre <di...@umpierre.com.br> on 2007/01/29 22:16:20 UTC
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
Re: output parameters (register output parameters failed).
Posted by Jeff Butler <je...@gmail.com>.
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 <Ch...@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
>
>
RE: output parameters (register output parameters failed).
Posted by Poitras Christian <Ch...@ircm.qc.ca>.
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