Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 2701 invoked from network); 22 Aug 2006 17:59:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 22 Aug 2006 17:59:19 -0000 Received: (qmail 73641 invoked by uid 500); 22 Aug 2006 17:59:18 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 73406 invoked by uid 500); 22 Aug 2006 17:59:17 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 73395 invoked by uid 99); 22 Aug 2006 17:59:17 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Aug 2006 10:59:17 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [64.14.54.239] (HELO ext-nj2ut-9.online-age.net) (64.14.54.239) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Aug 2006 10:59:15 -0700 Received: from int-nj2ut-1.online-age.net (int-nj2ut-1.online-age.net [3.159.237.70]) by ext-nj2ut-9.online-age.net (8.13.6/8.13.6/20051114-SVVS-TLS-DNSBL) with ESMTP id k7MHwpPN011690 for ; Tue, 22 Aug 2006 13:58:51 -0400 Received: from cinmlef06.e2k.ad.ge.com (int-nj2ut-1.online-age.net [3.159.237.70]) by int-nj2ut-1.online-age.net (8.13.6/8.13.6/20050510-SVVS) with ESMTP id k7MHwo4N026924 for ; Tue, 22 Aug 2006 13:58:51 -0400 Received: from FTWMLVEM04.e2k.ad.ge.com ([3.159.81.48]) by cinmlef06.e2k.ad.ge.com with Microsoft SMTPSVC(6.0.3790.2499); Tue, 22 Aug 2006 13:58:50 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6C614.9FBED221" Subject: RE: stored procedures Date: Tue, 22 Aug 2006 13:58:43 -0400 Message-ID: In-Reply-To: <5820E7E2A928DB46824297946AC2024A9A5F70@pandore.ircm.priv> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: stored procedures Thread-Index: AcbE0zJBuVi4he6KSWKGyXfFf1OfogBO4gSAAAEAFNAAAEAG8A== From: "Celaya, Tina \(GE Indust, ConsInd\)" To: X-OriginalArrivalTime: 22 Aug 2006 17:58:50.0520 (UTC) FILETIME=[9F8E8180:01C6C614] X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------_=_NextPart_001_01C6C614.9FBED221 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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:Christian.Poitras@ircm.qc.ca] Sent: Martes, 22 de Agosto de 2006 12:47 p.m. To: user-java@ibatis.apache.org Subject: RE: stored procedures 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? =20 Christian _____ =20 From: Celaya, Tina (GE Indust, ConsInd) [mailto:tina.celaya@ge.com]=20 Sent: Tuesday, 22 August 2006 13:27 To: user-java@ibatis.apache.org Cc: clinton.begin@gmail.com Subject: stored procedures I have this for my stored procedure =20 =20 =20 =20 {call ld..getExtractoSales(?)} =20 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=B4m getting this error =20 com.ibatis.common.jdbc.exception.NestedSQLException: =20 --- The error occurred in persistence/salesMX.xml. =20 --- The error occurred while applying a result map. =20 --- Check the SalesMX.salesmxRM. =20 --- The error happened while setting a property on the result object. =20 --- Cause: com.ibatis.common.exception.NestedRuntimeException: Error = setting properties of 'Classes.SalesMX@174aa60'. Cause: = java.lang.IllegalArgumentException =20 can anyone help me? i=B4m new at this, and im trying to call a procedure = with ibatis in different ways but i can get it to work.... i=B4m 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 ------_=_NextPart_001_01C6C614.9FBED221 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
In my=20 class SalesMX i only have Strings an floats, but first i had in SalesMX = a=20 variable declared as int, but de stored procedure returned a String, and = the=20 error told me specifically the name of the property than did not match = on the=20 SalesMX class and i change it, and then this error presented, but is not = telling=20 me the property that can not be set.... so i dont know what it is, but i = think=20 that if it was a type error it would tell me type mismatched error or = something=20 like that....
-----Original Message-----
From: Poitras Christian=20 [mailto:Christian.Poitras@ircm.qc.ca]
Sent: Martes, 22 de = Agosto de=20 2006 12:47 p.m.
To: = user-java@ibatis.apache.org
Subject:=20 RE: stored procedures

At first it seems to be an error when calling = the=20 insert. Maybe a String is set = into a Integer or=20 something...
Is=20 there any List/Array in your SalesMX?
 
Christian

From: Celaya, Tina (GE Indust, = ConsInd)=20 [mailto:tina.celaya@ge.com]
Sent: Tuesday, 22 August 2006=20 13:27
To: user-java@ibatis.apache.org
Cc:=20 clinton.begin@gmail.com
Subject: stored=20 procedures

I=20 have this for my stored procedure
 
  <resultMap id=3D"salesmxRM"=20 class=3D"Classes.SalesMX">
    <result = property=3D"anio"=20 column=3D"ano"/>
    <result property=3D"mes"=20 column=3D"mes"/>
    <result = property=3D"transaccion"=20 column=3D"transaccion"/>
    <result=20 property=3D"documento" column=3D"documento"/>
    = <result=20 property=3D"cliente" column=3D"cliente"/>
    = <result=20 property=3D"fecha" column=3D"fecha"/>
    = <result=20 property=3D"vencimiento" = column=3D"vencimiento"/>
   =20 <result property=3D"producto" = column=3D"producto"/>
   =20 <result property=3D"cantidad" = column=3D"cantidad"/>
   =20 <result property=3D"precio_unitario"=20 column=3D"precio_unitario"/>
    <result=20 property=3D"subtotal" column=3D"subtotal"/>
    = <result=20 property=3D"iva" column=3D"iva"/>
    <result=20 property=3D"fecha_pago" = column=3D"fecha_pago"/>
   =20 <result property=3D"pago" = column=3D"pago"/>
    <result=20 property=3D"moneda" column=3D"moneda"/>
    = <result=20 property=3D"tipocambio" = column=3D"tipocambio"/>
   =20 <result property=3D"transaccion_re"=20 column=3D"transaccion_re"/>
    <result=20 property=3D"documento_ref" = column=3D"documento_ref"/>
   =20 <result property=3D"picklist" = column=3D"picklist"/>
   =20 <result property=3D"programacion"=20 column=3D"programacion"/>
    <result=20 property=3D"distribucion" = column=3D"distribucion"/>
   =20 <result property=3D"sininv" = column=3D"sininv"/>
   =20 <result property=3D"credithold"=20 column=3D"credithold"/>
    <result = property=3D"entered"=20 column=3D"entered"/>    
    = <result property=3D"cantidad_so"=20 column=3D"cantidad_so"/>
    <result = property=3D"estatus"=20 column=3D"estatus"/>
  = </resultMap>
 
  <parameterMap id=3D"salesMxMap"=20 class=3D"map">
    <parameter property=3D"id"=20 jdbcType=3D"INTEGER" javaType=3D"java.lang.Integer" mode=3D"IN" = />
 =20 </parameterMap>
 
  <procedure = id=3D"salesReportDetail"=20 parameterMap=3D"salesMxMap" = resultMap=3D"salesmxRM">
   =20 {call ld..getExtractoSales(?)}
 =20 </procedure>
 
I=20 have the class SalesMX that contains all the properties listed in the=20 salesmxRM resultMap with the getter and setter method for each one, = but i=B4m=20 getting this error
 
com.ibatis.common.jdbc.exception.NestedSQLExce= ption:  =20
--- The error occurred in persistence/salesMX.xml. 
--- = The error=20 occurred while applying a result map. 
--- Check the=20 SalesMX.salesmxRM. 
--- The error happened while setting a = property=20 on the result object. 
--- Cause:=20 com.ibatis.common.exception.NestedRuntimeException: Error setting = properties=20 of 'Classes.SalesMX@174aa60'.&= nbsp;=20 Cause: java.lang.IllegalArgumentException
 
can=20 anyone help me? i=B4m new at this, and im trying to call a procedure = with ibatis=20 in different ways but i can get it to work.... i=B4m working with = microsft sql=20 so the parameterMap OUT ORACLECURSOR does not work for me, and i = tried to=20 upgrade to 2.2.0 and i had the Can't start a cloned connection while in manual transaction = mode error,=20 so i went back and tried to do it with the resultMap and parameterMap = but i=20 need help with this setting a property = error
Thanks
Tina
------_=_NextPart_001_01C6C614.9FBED221--