cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Binding Array in SQLTemplate
Date Fri, 11 Dec 2009 12:51:26 GMT
Ah good catch. Looking at the BindDirective code, it doesn't properly  
support arrays, only collections. I guess we need to change that and  
treat arrays the same way.

Andrus

On Dec 11, 2009, at 5:42 AM, Evgeny Ryabitskiy wrote:

> No answer...
> But history  points to Andrus :)
>
> Evgeny.
>
> 10 декабря 2009 г. 10:55 пользователь Рябицкий Евгений
> <eryabitskiy@diasoft.ru> написал:
>> Hello!
>> I try to use array (like String[]) as a bind parameter.
>>
>> In follow lines:
>>
>>        String[] artistNames = new String[2];
>>        artistNames[0] = "Artist1";
>>        artistNames[1] = "Artist3";
>>        String sql = "SELECT * FROM ARTIST WHERE ARTIST_NAME in  
>> (#bind($ARTISTNAMES))";
>>        SQLTemplate query = new SQLTemplate(Artist.class, sql);
>>        query.setParameters(Collections.singletonMap("ARTISTNAMES",  
>> artistNames));
>>        List result =  
>> getDomain().createDataContext().performQuery(query);
>>
>> I got this query in logs:
>>
>> INFO: SELECT * FROM ARTIST WHERE ARTIST_NAME in (?) [bind: 1:<  
>> 'Artist1','Artist3'>]
>> 10.12.2009 10:48:09 org.apache.cayenne.access.QueryLogger  
>> logSelectCount
>> INFO: === returned 0 rows. - took 0 ms.
>>
>>
>> So... What does it mean? [bind: 1:< 'Artist1','Artist3'>] ?
>> I mean what is a purpose of using array in bind? For what queries  
>> it should be used?
>>
>> Evgeny.
>>
>


Mime
View raw message