Hey all,
I'm using Hibernate Search to do some nice analytical/searching work, but ran into a bug.

Using facets, I get back all the information I originally need based on a lucene query, but when I try to get the associated objects (javax.persistence.Query.getResultList()) I get "Prepared or callable statement has more than 2000 parameter markers." on sql server/jtds.

Trimming for smaller results under 2k works fine, but since I'm using hibernate search intentionally on larger results (because, hey, it's faster than the RDBMS for string style searching/analytics) I was hoping it would be easy to then use the results in a normal/standard (JPA/entity list) way. Paginating the results does not seem to matter, as it appears it is more the size of the resulting SQL query based on the results of the Search query.

I see a https://hibernate.onjira.com/browse/HHH-1123 that has been open since 2005 related to Oracle issue, with references to similar problem on sql server. Has anyone had luck overcoming this problem?

HibSearch 3.4.1.final, hibernate-entitymanager 3.6.7.final

thanks,
-D

Hi,

could you provide a full stack trace and the search you are trying to execute? Maybe also the SQL which should be executed. This would help to track down the code path. Obviously you are hitting a limitation of your database and there is of course the Hibernate Core issue you are mentioning. However, I thought we do some batching on the Search side, but I need some more information to track this down.

Have you considered using projections as solution/workaround?

--Hardy

I created a new issue for that - https://hibernate.onjira.com/browse/HSEARCH-962

BTW fixing the code should be fairly trivial, it is all in https://github.com/hibernate/hibernate- ... lizer.java

If you want to give it a try let us know and jump to your GitHub fork :)