Hibernate-Search: IdClass composite pk

FlavioTroja · **Joined:** Tue Oct 09, 2012 4:46 am **Posts:** 1

I've configurated with hibernate-search annotation (4.1.1 version library) my class Intervento. So, I'm using jpa and in my case i can omit @DocumentId but I have a composite primary key...

Code:

@IdClass(it.domain.InterventoPK.class)
@Entity
@Indexed
@AnalyzerDef(name = "interventongram", tokenizer = @TokenizerDef(factory = StandardTokenizerFactory.class),
filters = {
    @TokenFilterDef(factory = LowerCaseFilterFactory.class),
    @TokenFilterDef(factory = StopFilterFactory.class, params = {
       @Parameter(name = "words", value = "lucene/dictionary/stopwords.txt"),
       @Parameter(name = "ignoreCase", value = "true"),
       @Parameter(name = "enablePositionIncrements", value = "true")
    }),
    @TokenFilterDef(factory = ItalianLightStemFilterFactory.class),
    @TokenFilterDef(factory = SynonymFilterFactory.class, params = {
       @Parameter(name = "synonyms", value = "lucene/dictionary/synonyms.txt"),
       @Parameter(name = "expand", value = "true")
    }),
    @TokenFilterDef(factory = SnowballPorterFilterFactory.class, params = {
         @Parameter(name = "language", value = "Italian")
    })
})
@Table(name = "intervento", catalog = "gestionale")
@XmlAccessorType(XmlAccessType.FIELD)
@XmlType(namespace = "Clinigo/it/domain", name = "Intervento")
@XmlRootElement(namespace = "Clinigo/it/domain")
public class Intervento implements Serializable {
   private static final long serialVersionUID = 1L;

   /**
    */
   
   @Column(name = "idintervento", nullable = false)
   @Basic(fetch = FetchType.EAGER)
   @Id
   @XmlElement
   Integer idintervento;
   /**
    */

   @Column(name = "lingua_idlingua", nullable = false)
   @Basic(fetch = FetchType.EAGER)
   @Id
   @XmlElement
   Integer linguaIdlingua;
   /**
    */
   @Temporal(TemporalType.TIMESTAMP)
   @Column(name = "version", nullable = false)
   @Basic(fetch = FetchType.EAGER)
   @XmlElement
   Calendar version;

...

I'm getting....can you help me?

ERROR: HSEARCH000058: HSEARCH000116: Unexpected error during MassIndexer operation
java.lang.ClassCastException: it.domain.InterventoPK cannot be cast to java.lang.Integer
at org.hibernate.type.descriptor.java.IntegerTypeDescriptor.unwrap(IntegerTypeDescriptor.java:36)
at org.hibernate.type.descriptor.sql.IntegerTypeDescriptor$1.doBind(IntegerTypeDescriptor.java:57)
at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:92)
at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:305)
at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:300)
at org.hibernate.loader.Loader.bindPositionalParameters(Loader.java:1891)
at org.hibernate.loader.Loader.bindParameterValues(Loader.java:1862)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1737)
at org.hibernate.loader.Loader.doQuery(Loader.java:828)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289)
at org.hibernate.loader.Loader.doList(Loader.java:2447)
at org.hibernate.loader.Loader.doList(Loader.java:2433)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2263)
at org.hibernate.loader.Loader.list(Loader.java:2258)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:122)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1535)
at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
at org.hibernate.search.batchindexing.impl.IdentifierConsumerEntityProducer.loadList(IdentifierConsumerEntityProducer.java:150)
at org.hibernate.search.batchindexing.impl.IdentifierConsumerEntityProducer.loadAllFromQueue(IdentifierConsumerEntityProducer.java:117)
at org.hibernate.search.batchindexing.impl.IdentifierConsumerEntityProducer.run(IdentifierConsumerEntityProducer.java:94)
at org.hibernate.search.batchindexing.impl.OptionallyWrapInJTATransaction.run(OptionallyWrapInJTATransaction.java:84)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)

sanne.grinovero · **Posted:** Tue Oct 09, 2012 5:13 am

Hi Flavio,

IdClass is not handled automatically, Hibernate Search can't access the id type with this mapping. We can try improve on this, can you please open an issue on JIRA?
https://hibernate.onjira.com/browse/HSEARCH

You can change your mapping slightly to make it work: don't use the IdClass combined with two @Id fields, but use the mapping style having a single @Id element on a field of type InterventoPK and mark this as embeddable.

For an example see:
5.1.2.1.1. id as a property using a component type

in http://docs.jboss.org/hibernate/core/4.1/manual/en-US/html_single/

Then on the Id field you can define a TwoWayFieldBridge to define how you want this field to be indexed.

sanne.grinovero · **Posted:** Tue Oct 09, 2012 9:12 am

An alternative to changing your mapping is that you add add a @DocumentId on some getter, and return any object - maybe even a string - which is a unique composite of the two ids components.

When using JPA you can avoid specifying the @DocumentId but you don't have to, you can still use the annotation to override the definition of indentity to apply on the index mapping.

maheshksd · **Joined:** Fri Nov 07, 2014 1:02 am **Posts:** 1

Hi Sanne,
I am trying to work with composite key with hibernate search as you suggested(I have thousands of exiting code).I have created a method to convert composite key to a unique string as given below(like we do in TwoWayFieldBridge). I have annotated a method with @DocumentId as given below. Storing objects is fine. But If I search a entity,Hibernate search tries to assign value to a field which is not existing. In the below case Hibernate tries to set key value to "documentId". If I had a setter to reassign the field companyId and userId it was great, But how can tell hibernarte to call a setDocumentId() ,such that I can recover the composite keys.

Code:

@IdClass(UserId.class)
public class User{
@Id
private int companyId;
@Id
private int userId;
@DocumentId
     public String getDocumentId(){
      return companyId+"|"+userId;
     }
}

public class UserId implements Serializable{
private int companyId;
private int userId;
}

Thanks...

sanne.grinovero · **Posted:** Fri Nov 07, 2014 6:57 am

Hi,
I'm surprised, I think I did similar mappings in the past but I need to look it up as I forgot the details. It's possible that what I did doesn't work anymore, or best case it's an important missing point in the documentation.

I've created an issue to track this:
https://hibernate.atlassian.net/browse/HSEARCH-1715

We'll have a look soon, if you find the trick in the meantime please let me know :)

ioantiba · **Joined:** Tue Oct 18, 2016 5:06 am **Posts:** 1

Hello,

I have the same problem... I want to integrate Hibernate Search in existing project with hundreds of entities but at least half of entities use @IdClass annotation as composed key.
Can I solve the problem using the annotation @IdClass?

I have the following example:

entity class:

Code:

@Entity
@Table(name="FAKVS_DB")
@IdClass(value=PK_FAKVS_DB.class)
@Audited
@Indexed
public class FAKVS_DB implements Serializable {

   @Id
   @Column(name="Key_FAM", length=10, nullable=false)l
   private String keyFam;
   
   @Id
   @Column(name="Komponentennr", nullable=false)
   private Integer komponentenNr;
   
   @Id
   @Column(name="Hinweis", nullable=true, length=4)
   private String hinweis;

        //getters and setters
}

and composed key:

Code:

public class PK_FAKVS_DB implements Serializable {

   private String keyFam;
   private Integer komponentenNr;
   private String hinweis;

        //getters and setters
}

If I can not use @IdClass annotation can you tell me what are the alternatives?

Thank you very much in advance.