At 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 procedures
I 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>
<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>
<parameter property="id" jdbcType="INTEGER" javaType="java.lang.Integer" mode="IN" />
</parameterMap>
<procedure id="salesReportDetail" parameterMap="salesMxMap"
resultMap="salesmxRM">
{call ld..getExtractoSales(?)}
</procedure>
{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
error
com.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.IllegalArgumentException
--- 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.IllegalArgumentException
can
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 error
Thanks
Tina
