ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Javier Leyba" <xle...@gmail.com>
Subject Re: query inside a query
Date Sun, 07 May 2006 15:55:45 GMT
Hi

I'm trying to do my best following the examples but I'm doing
something wrong because I couldn't see what I want.

I've this

<typeAlias alias="participes"
        type="org.jl.meriden.listados.dao.Participes" />

<resultMap id="resultParticipes" class="participes">
		<result property="nroCuenta" column="nroCuenta" />
		<result property="nombreParticipe" column="G09APE"
select="getNombreParticipe" />
		<result property="suscriptas" column="suscriptas" />
		<result property="rembolsadas"	column="rembolsadas" />
		<result property="saldoParticipe" column="saldoParticipe" />
		<result property="saldoPignorado" column="saldoPignorado" />
		<result property="saldoSuscripto" column="saldoSuscripto" />
		<result property="saldoRembolsado" column="saldoRembolsado" />
		<result property="saldoCosteMedio" column="saldoCosteMedio" />		
	</resultMap>


where nombreparticipe come from another select. Then I added the
corresponding select

<statement id="getNombreParticipe" parameterClass="java.lang.String"
resultMap="resultParticipes">
		<![CDATA[
		select G09CO.G09APE as nombreParticipe from G09CO where G09CO.G09COD = #value#
		]]>
	</statement>


When I run the program I can see all Participes properties except the
one that should come from the second select. As I didn't received an
error, I don't know if my mistake is passing parameter to second
select or retrieving data from it.

Could someone help me please ?

Thanks in advance

J

Mime
View raw message