I have a query:
SELECT COUNT(*) FROM Organization as org, CompanyProperty as prop WHERE org.id != :orgId AND LOWER(prop.value) IN (:orgNames)

And i want invoke LOWER function on :orgNames list.
That sql query become like this:

select count(*) as x0_0_ from organization organizati0_, multilanguage_property companypro1_ where companypro1_.disc='comp' and ((organizati0_.org_id!=16 )and(LOWER(companypro1_.value)in(lower('bonas') , lower('maxim fr')))

Now i put in orgNames values : LOWER('maxim fr') and etc. but as i understand hibernate makes this as string parameter and i got
... LOWER(companypro1_.value) in ('lower('bonas')' , 'lower('maxim fr')' ...

Use java to do the force lower case on the agument list rather than the DB.

Thank's. But if i want to invoke special function not so simple as LOWER ?

You will have to pass them in individually wrapped by the function rather than as a collection.