Hello,
I have another typical issue of a beginner!!!!!
I have two tables:
ELEM: id, name, atrib_id
ATRIB: id, name, value
In Elem java class I´ve defined
private ArrayList<Atrib> atrib_ = new ArrayList<Atrib>();
public void setAtrib_ (Atrib atrib) {atrib_.add(atrib);}
and in sqlMap I´ve defined:
<resultMap id="mapAtributos" class="atributo">
<result property="id" column="ID"/>
<result property="name" column="NAME"/>
<result property="value" column="VALUE"/>
</resultMap>
<resultMap id="mapElementos" class="elemento">
<result property="id" column="ID"/>
<result property="name" column="NAME"/>
<result property="atrib_id" column="ATRIB_ID" select="getAtributos"
/>
</resultMap>
<select id="getElementosTransaccion" resultMap="mapElementos">
select * from ELEM where ATRIB_ID=#value#
</select>
<select id="getAtributos" resultMap="mapAtributos">
select * from ATRIB oat_oet_id=#oet_id#
</select>
All this works properly if I have only one attribute for every element, but
if there are two attribute for any element, the I obtain the error:
Cause: java.sql.SQLException: Error: executeQueryForObject returned too many
results.
I understand the error, but I am not able to find the solution!!! How could
I solve it? Thanks
From: "Francisco Exposito Aguilera" <[EMAIL PROTECTED]>
Reply-To: [email protected]
To: [email protected]
Subject: RE: Issue in dynamic select
Date: Thu, 19 Jul 2007 07:22:17 +0000
I can´t remove the null-option but using the wrapper class it works
properly! Really thanks for solve this not-iBatis issue :)
From: "Niels Beekman" <[EMAIL PROTECTED]>
Reply-To: [email protected]
To: <[email protected]>
Subject: RE: Issue in dynamic select
Date: Wed, 18 Jul 2007 23:45:33 +0200
The ideal solution would be to either remove the null-option on the column
or to use a wrapper class (i.e. Integer instead of int). If you do not
want to make either modifications, you could use the nullValue-attribute
which puts a "magic" value into your bean.
Niels
-----Original Message-----
From: Francisco Exposito Aguilera [mailto:[EMAIL PROTECTED]
Sent: woensdag 18 juli 2007 22:29
To: [email protected]
Subject: RE: Issue in dynamic select
Yes, I know that the value, in this case, is a null. Sometimes the value
is
null and sometimes the value is not null, it depends and it is right.
Then,
what I want is obtain and set this value when it is not null and avoid it
when it is null. Is there any way to do it? Is it possible?
>From: "Niels Beekman" <[EMAIL PROTECTED]>
>Reply-To: [email protected]
>To: <[email protected]>
>Subject: RE: Issue in dynamic select
>Date: Wed, 18 Jul 2007 20:52:57 +0200
>
>Either you are throwing the exception yourselves from the setter, or you
>are trying to map a null value into a primitive field...
>
>Hope this helps,
>
>Niels
>
>-----Original Message-----
>From: Francisco Exposito Aguilera [mailto:[EMAIL PROTECTED]
>Sent: woensdag 18 juli 2007 17:42
>To: [email protected]
>Subject: Issue in dynamic select
>
>Hello,
>
>I have a table where the attribute OET_Padre is a FK which sometimes is
>null.
>
>I want to create a dynamic select which show all fields when OET_Padre
is
>not null and all fields but this one when is null.
>
>I´ve created a result map:
>
><resultMap id="mapElementosTransaccion"
>class="ads.orquestador.modelo.Elemento">
> <result property="oetID_" column="OET_ID"/>
> <result property="oetItemId_" column="OET_ITEMID"/>
> <result property="oetClase_" column="OET_CLASE"/>
> <result property="oetVersion_" column="OET_VERSION"/>
> <result property="oetOrqId_" column="OET_ORQ_ID"/>
> <result property="oetPadre_" column="OET_PADRE"/>
></resultMap>
>
>and the select:
>
><select id="getElementosTransaccion" resultMap="mapElementosTransaccion"
>remapResults="true">
> SELECT
> OET_ID,
> OET_ItemID,
> OET_Clase,
> OET_Version,
> OET_ORQ_ID,
> OET_PADRE
> FROM ORQ_TRANS, ORQ_ELEM_TMP
> WHERE OTR_ID=#oetOrqId_#
>
>but when the OET_PADRE is null I receive the error
>
>--- Cause: java.lang.RuntimeException: Error setting property
>'setOetPadre_'
>of '[EMAIL PROTECTED]'. Cause:
>java.lang.IllegalArgumentException
>
>Can anybody help me? Thanks a lot.
>
>_________________________________________________________________
>Acepta el reto MSN Premium: Protección para tus hijos en internet.
>Descárgalo y pruébalo 2 meses gratis.
>http://join.msn.com?XAPID=1697&DI=1055&HL=Footer_mailsenviados_proteccioninfantil
>
_________________________________________________________________
Grandes éxitos, superhéroes, imitaciones, cine y TV...
http://es.msn.kiwee.com/ Lo mejor para tu móvil.
_________________________________________________________________
Descubre la descarga digital con MSN Music. Más de un millón de canciones.
http://music.msn.es/
_________________________________________________________________
Dale rienda suelta a tu tiempo libre. Mil ideas para exprimir tu ocio con
MSN Entretenimiento. http://entretenimiento.msn.es/
