You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Tomáš Procházka <t....@centrum.cz> on 2010/04/12 07:58:30 UTC
Re: return simple String[] or List
Hi.
But what I must specify to resulType if I want return List<String> as
return value from query?
--------------------------- Původní zpráva ---------------------------
Odesilatel: Guy Rouillier <gu...@burntmail.com>
Předmět: return simple String[] or List<String>
Datum: 25. března 2010, 15:27:31 (GMT -0400)
Přílohy: <none>
G> Sure, that will work, but what is the point? That result map doesn't
G> really buy you anything. Why not just specify a resultType in your
G> select instead of a resultMap?
G> On 3/25/2010 7:43 AM, Tomáš Procházka wrote:
>> I found solution i have this in xml mapping file
>> <resultMap type="java.lang.String" id="domainsResult">
>> <result property="" column="domain"/>
>> </resultMap>
>> <select id="selectAvailableDomains" resultMap="domainsResult">
>> SELECT domain FROM queue WHERE ended IS NULL GROUP BY domain
>> </select>
>> and this in Mapper class
>> List<String> selectAvailableDomains();
>> and it works
>> ______________________________________________________________
>>> Od: "Guy Rouillier"<gu...@burntmail.com>
>>> Komu: user-java@ibatis.apache.org
>>> Datum: 24.03.2010 18:10
>>> Předmět: Re: return simple String[] or List<String>
>>> On 3/24/2010 10:30 AM, Tomáš Procházka wrote:
>>>> It's possible return simple String[] or List<String> with ibatis maping?
>>> You don't mention which version of iBATIS you are using, so I'm assuming version 3. This works:
>>> <select id="selectBundleId" resultType="string" parameterType="string">
>>>> In documentation is only 'int' 'hashmap' and collection of own class.
>>>> Itried resultType="java.util.String[]" or resultMap="java.util.String" and it doesn't work
>>> The documentation says this: "Note that in the case of collections, this should be the type that the collection contains, not the type of the collection itself." The type that the collection contains is string.
>>> -- Guy Rouillier
------------------------ Konec původní zprávy ------------------------
--
---------------------------------------------------------------------
Tomáš Procházka
E-mail: t.prochazka@centrum.cz
WWW: http://www.atomsoft.cz
ICQ: 87147320
---------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: return simple String[] or List
Posted by Nathan Maves <na...@gmail.com>.
Tomas,
I am assuming that you have not read the developers guide and I just
giving things a go. You need to read the guide completely.
In this case Guy was saying that if your query only returns a string
then set the resultType to String. Then use the ibatis queryForList()
to compile your results into a List<String>.
Nathan
2010/4/11 Tomáš Procházka <t....@centrum.cz>:
> Hi.
>
> But what I must specify to resulType if I want return List<String> as
> return value from query?
>
>
> --------------------------- Původní zpráva ---------------------------
> Odesilatel: Guy Rouillier <gu...@burntmail.com>
> Předmět: return simple String[] or List<String>
> Datum: 25. března 2010, 15:27:31 (GMT -0400)
> Přílohy: <none>
>
> G> Sure, that will work, but what is the point? That result map doesn't
> G> really buy you anything. Why not just specify a resultType in your
> G> select instead of a resultMap?
>
> G> On 3/25/2010 7:43 AM, Tomáš Procházka wrote:
>
>>> I found solution i have this in xml mapping file
>
>>> <resultMap type="java.lang.String" id="domainsResult">
>>> <result property="" column="domain"/>
>>> </resultMap>
>
>>> <select id="selectAvailableDomains" resultMap="domainsResult">
>>> SELECT domain FROM queue WHERE ended IS NULL GROUP BY domain
>>> </select>
>
>>> and this in Mapper class
>
>>> List<String> selectAvailableDomains();
>
>>> and it works
>
>
>>> ______________________________________________________________
>>>> Od: "Guy Rouillier"<gu...@burntmail.com>
>>>> Komu: user-java@ibatis.apache.org
>>>> Datum: 24.03.2010 18:10
>>>> Předmět: Re: return simple String[] or List<String>
>
>>>> On 3/24/2010 10:30 AM, Tomáš Procházka wrote:
>
>>>>> It's possible return simple String[] or List<String> with ibatis maping?
>
>>>> You don't mention which version of iBATIS you are using, so I'm assuming version 3. This works:
>
>>>> <select id="selectBundleId" resultType="string" parameterType="string">
>
>
>>>>> In documentation is only 'int' 'hashmap' and collection of own class.
>>>>> Itried resultType="java.util.String[]" or resultMap="java.util.String" and it doesn't work
>
>>>> The documentation says this: "Note that in the case of collections, this should be the type that the collection contains, not the type of the collection itself." The type that the collection contains is string.
>
>>>> -- Guy Rouillier
>
>
>
>
>
> ------------------------ Konec původní zprávy ------------------------
>
> --
> ---------------------------------------------------------------------
> Tomáš Procházka
>
>
> E-mail: t.prochazka@centrum.cz
> WWW: http://www.atomsoft.cz
> ICQ: 87147320
> ---------------------------------------------------------------------
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org