I am not sure that the error will show the name of the
property. Especially if it's a NestedSQLException (I think iBatis will show
property names only when validating the xml file against java classes, not jdbc
types).
First, you should check these.
Is your SalesMX an abstract class or interface? This
could also be a cause...
Can you post your java class?
Christian
From: Celaya, Tina (GE Indust, ConsInd) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 22 August 2006 14:09
To: [email protected]
Subject: RE: stored procedures
And in
the action i have this
HashMap hm = new HashMap();
hm.put("id",new Integer(id));
List reg=d.getList("salesReportDetail",hm);
hm.put("id",new Integer(id));
List reg=d.getList("salesReportDetail",hm);
I want
to receive a List of SalesMX objects....
-----Original Message-----
From: Celaya, Tina (GE Indust, ConsInd)
Sent: Martes, 22 de Agosto de 2006 12:59 p.m.
To: [email protected]
Subject: RE: stored proceduresIn 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
