exception « Search « JPA Q&A

  1. JPA Q&A
  2. Search
  3. exception




1. org.hibernate.exception.GenericJDBCException on Too Many Search Criteria    coderanch.com

Hi! I'm running a search using Hibernate DAO. I pass a list of ids (orgIds) into the SearchCriteria. It seems to run without problems if I have under approximately 500 ids. But if I have > 500 ids I get a GenericJDBCException. I'm pasting stack below. *************************Criteria*************** FacilitySearchResultCriteria criteria = new FacilitySearchResultCriteria(); criteria.add(criteria.createConditionList() .in(FacilitySearchResult.PROP_ORG_ID, orgIds) .like(FacilitySearchResult.PROP_FACILITY_NUMBER, StringUtil.clean(getFacilityNumber()), LikeImplyPattern.END) .eq(FacilitySearchResult.PROP_FACILITY_TYPE, getFacilityType()) .eq(FacilitySearchResult.PROP_FACILITY_STATUS, ...

2. Hibernate Search Exception for Cote d'Ivoire    coderanch.com

Hi all, Both the below codes do the same operation, a country is got , and once we determine that the country is not null. a criteria is added. Code Fragment 1 Works, But in this i am actually appending a SQL reason Code 1 was done, Code 2 did not work for One Country " Cote d'Ivoire, EVen after escaping ...

3. hibernate Search String with special char gives an exception    forum.hibernate.org