Why is my Hibernate Search query not working?

[Nina Anderson]

My working search does not working on associated objects. I'm trying to find a business in a given city (ex. "Pizza Hut" in "Florida). I have 3 tables BUSINESS, ADDRESS and BUSINESS_ADDRESS, where Business_Address is the intermediate table. The primary key in the BUSINESS_ADDRESS table is "Business_Address_Id" and "business_Id" and "address_Id" are foreign keys.

Can you tell me what I'm doing wrong in my 3 class configuration:

BUSINESS table

 
@Entity
@Inheritance(strategy=InheritanceType.SINGLE_TABLE)
@Table(name = "Busines")
@Indexed(index="indexes/businesses")
public abstract class AbstractBusinessCbo  implements java.io.Serializable {
 

    // Fields    
@Id
@DocumentId
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "BUSINESS_ID", nullable = false)
     private Integer businessId;
     
  @Column(name = "BUSINESS_NAME")
@Field(index=Index.TOKENIZED)
     private String businessName;
     
     @ContainedIn
   @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER) 
     @JoinTable(name="BUSINESS_ADDRESS",
              joinColumns={@JoinColumn(name = "BUSINESS_ID")},
              inverseJoinColumns={@JoinColumn(name = "ADDRESS_ID")})
     @IndexedEmbedded 
     private Set businessAddresses = new HashSet(0);
 

ADDRESS table:

@Entity
@Inheritance(strategy=InheritanceType.SINGLE_TABLE)
@Table(name = "Address")
@Indexed(index="indexes/addresses")
public abstract class AbstractAddressCbo  implements java.io.Serializable {
 
@Id
@DocumentId
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "ADDRESS_ID", nullable = false)
     private Integer addressId;

     private Integer countryId;
     private String addressLine1;
     private String addressLine2;
     
 @Column(name = "CITY_NAME")
@Field(index=Index.TOKENIZED)
     private String cityName;
 
@Column(name = "STATE")
@Field(index=Index.TOKENIZED)
     private String state;
     
     @ContainedIn
     @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER) 
          @JoinTable(name="BUSINESS_ADDRESS",
              joinColumns={@JoinColumn(name = "ADDRESS_ID")},
              inverseJoinColumns={@JoinColumn(name = "BUSINESS_ID")})
     @IndexedEmbedded 
     private Set businessAddresses = new HashSet(0);

BUSINESS_ADDRESS table:

@Entity
@Inheritance(strategy=InheritanceType.SINGLE_TABLE)
@Table(name = "BusinessAddress")
@Indexed(index="indexes/businessAddresses")
public abstract class AbstractBusinessAddress  implements java.io.Serializable {
 

    // Fields  

@javax.persistence.Id
@EmbeddedId 
@DocumentId
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "BUSINESS_ADDRESS_ID", nullable = false)
     private Integer businessAddressId;


    @Embeddable 
    public static class Id implements java.io.Serializable { 
 
       @Column(name = "BUSINESS_ID") 
       private Integer businessId; 
 
       @Column(name = "ADDRESS_ID") 
       private Integer addressId; 
 
      public Id() {} 
 
      public Id( Integer businessId, Integer addressId) { 
 
         this.businessId = businessId; 
         this.addressId = addressId; 
      } 
 
    } 
 
    @EmbeddedId 
    private Id id = new Id(); 
 
     
    @ManyToOne 
    @JoinColumn(name="ADDRESS_ID", insertable = false, updatable = false) 
     private AddressCbo address;
     
    @ManyToOne 
    @JoinColumn(name="BUSINESS_ID", insertable = false, updatable = false) 
     private BusinessCbo busines;

FULLTEXT QUERY:

 
            FullTextSession fullTextSession = Search.createFullTextSession( session );
            QueryParser parser = new QueryParser("businessId", new StandardAnalyzer());
            
            org.apache.lucene.search.Query query = parser.parse("businessName:" + keywords + "~");
            query = parser.parse("businessAddresses.address.cityName:" + criteria_.cityName + "~");
            
            searchQry = fullTextSession.createFullTextQuery(query, BusinessCbo.class);
countQry = searchQry;
result = paginator.getPaginatdResult(session,countQry,searchQry,paginationControl_);