Re: [hibernate-dev] HHH-1123 - Cannot put more than 1000 elements in a InExpression
Also note that there is a limit for the query size globally in some vendors and that
people relieved from HHH-1123 cal fall into the second limit.
A solution would be for Hibernate to split one query into several but I'm not sure I
like the idea.
Emmanuel
On 29 nov. 2011, at 21:29, Łukasz Antoniak wrote:
Hi all!
Recently I had a closer look at HHH-1123 issue. This bug affects both -
Criteria API and HQL. I have introduced
Dialect#maximumInExpressionElements() method which returns maximum
number of allowed elements in a single SQL IN clause, or null treated as
infinite. The change of InExpression was very easy. However, fixing this
bug for HQL queries requires modification of ParameterMetadata
(namedDescriptorMap cannot remain unmodifiable), as well as
AbstractQueryImpl (queryString). As I don't see any other solution, I
wanted to ask you guys for suggestions. Is it the only possible way of
fixing this issue? Finally, shall we really fix this? This is a DB
vendor limitation, but 40 user gave their vote for it.
Regards,
Lukasz Antoniak
_______________________________________________
hibernate-dev mailing list
hibernate-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev