In my
class SalesMX i only have Strings an floats, but first i had in SalesMX a
variable declared as int, but de stored procedure returned a String, and the
error told me specifically the name of the property than did not match on the
SalesMX class and i change it, and then this error presented, but is not telling
me the property that can not be set.... so i dont know what it is, but i think
that if it was a type error it would tell me type mismatched error or something
like that....
-----Original Message-----
From: Poitras Christian [mailto:[EMAIL PROTECTED]
Sent: Martes, 22 de Agosto de 2006 12:47 p.m.
To: [email protected]
Subject: RE: stored proceduresAt first it seems to be an error when calling the insert. Maybe a String is set into a Integer or something...Is there any List/Array in your SalesMX?Christian
From: Celaya, Tina (GE Indust, ConsInd) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 22 August 2006 13:27
To: [email protected]
Cc: [EMAIL PROTECTED]
Subject: stored proceduresI have this for my stored procedure<resultMap id="salesmxRM" class="Classes.SalesMX">
<result property="anio" column="ano"/>
<result property="mes" column="mes"/>
<result property="transaccion" column="transaccion"/>
<result property="documento" column="documento"/>
<result property="cliente" column="cliente"/>
<result property="fecha" column="fecha"/>
<result property="vencimiento" column="vencimiento"/>
<result property="producto" column="producto"/>
<result property="cantidad" column="cantidad"/>
<result property="precio_unitario" column="precio_unitario"/>
<result property="subtotal" column="subtotal"/>
<result property="iva" column="iva"/>
<result property="fecha_pago" column="fecha_pago"/>
<result property="pago" column="pago"/>
<result property="moneda" column="moneda"/>
<result property="tipocambio" column="tipocambio"/>
<result property="transaccion_re" column="transaccion_re"/>
<result property="documento_ref" column="documento_ref"/>
<result property="picklist" column="picklist"/>
<result property="programacion" column="programacion"/>
<result property="distribucion" column="distribucion"/>
<result property="sininv" column="sininv"/>
<result property="credithold" column="credithold"/>
<result property="entered" column="entered"/>
<result property="cantidad_so" column="cantidad_so"/>
<result property="estatus" column="estatus"/>
</resultMap><parameterMap id="salesMxMap" class="map">
<parameter property="id" jdbcType="INTEGER" javaType="java.lang.Integer" mode="IN" />
</parameterMap><procedure id="salesReportDetail" parameterMap="salesMxMap" resultMap="salesmxRM">
{call ld..getExtractoSales(?)}
</procedure>I have the class SalesMX that contains all the properties listed in the salesmxRM resultMap with the getter and setter method for each one, but i´m getting this errorcom.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in persistence/salesMX.xml.
--- The error occurred while applying a result map.
--- Check the SalesMX.salesmxRM.
--- The error happened while setting a property on the result object.
--- Cause: com.ibatis.common.exception.NestedRuntimeException: Error setting properties of '[EMAIL PROTECTED]'. Cause: java.lang.IllegalArgumentExceptioncan anyone help me? i´m new at this, and im trying to call a procedure with ibatis in different ways but i can get it to work.... i´m working with microsft sql so the parameterMap OUT ORACLECURSOR does not work for me, and i tried to upgrade to 2.2.0 and i had the Can't start a cloned connection while in manual transaction mode error, so i went back and tried to do it with the resultMap and parameterMap but i need help with this setting a property errorThanksTina
