manytoone relationship and faceting

pragnesh1 · **Joined:** Thu Sep 01, 2011 4:10 am **Posts:** 5

does maytoone relation ship work with hibernate search faceting?

I have two entity comany, and companyfacality ,
one campay have have multiple companyfacality , and i want to search based on companyfacality country,

I can see in index that company has multiple companyfacility field using luke, but when i try to do facating on that field it only conside one of that field,

Does any one have idea what coude be wrong?

sanne.grinovero · **Posted:** Thu Sep 01, 2011 8:40 am

Hi,
I'm not sure I understand, could you please create a *minimal* unit test?
thanks

pragnesh1 · **Joined:** Thu Sep 01, 2011 4:10 am **Posts:** 5

i have create minimal test in hibernate search codebase.

You can get file from following link,drop file into corrosponding package and test it.
http://dl.dropbox.com/u/31823287/facet_test.zip

Let me know if problem i am facing is still not clear.

sanne.grinovero · **Posted:** Sat Sep 03, 2011 3:36 pm

Hi, thank you for the example.
There are two errors in your code:

1) The "country" string should not be annotated as @IndexedEmbedded, but as @Field

Code:

   private int id;
   @ContainedIn
   @ManyToOne(fetch = FetchType.LAZY)
   @JoinColumn(name = "companyId", nullable = false)
   private Company company;
   @IndexedEmbedded // Make this @Field instead
   private String country;
   

2) you forgot to add the facilities to the set of facilities of the company
The CompanyFacility constructors should be:

Code:

   
   public Companyfacility() {
   }
   
   public Companyfacility(Company company,String country) {
      this.company = company;
      this.country = country;
      company.getCompanyfacilities().add( this );
   }

When dealing with relations in Hibernate, always make sure you update both directions of the relation:
Companyfacility.company
AND
Company.companyfacilities

pragnesh1 · **Joined:** Thu Sep 01, 2011 4:10 am **Posts:** 5

Thanks Sanne,

Both of my point solve my problem.

pragnesh1 · **Joined:** Thu Sep 01, 2011 4:10 am **Posts:** 5

Hi Sanne,

Thanks for reply,
Although it is giving correct facet item but facet count are still wrong, Can you take a look at it again?

I have update code with your suggestion and added count related test in minimal test case.
http://dl.dropbox.com/u/31823287/facet_test.zip

sanne.grinovero · **Posted:** Sun Sep 04, 2011 2:56 pm

Hi,
your code looks like correct now, so I think this is a bug with the Faceting implementation.
Could you please open a JIRA issue and attach your unit tests there?

thanks

pragnesh1 · **Joined:** Thu Sep 01, 2011 4:10 am **Posts:** 5

Thanks for reply,

I have opened jira issue , HSEARCH-900

-pragnesh

Elmer · **Joined:** Mon Apr 11, 2011 7:56 am **Posts:** 38

Probably related to Lucene's field cache only compatible with single valued fields. See also: viewtopic.php?f=9&t=1010472 (HSEARCH-726)