index « Property « JPA Q&A





1. How to generate an index over multiple properties?    forum.hibernate.org

Hi, I need to generate an index over multiple properties across possibly multiple classes. I only managed to find the index attribute on the property element, but that doesn't suffice. Of course I can use a component/property-ref and set the unique attribute to true, but that only enables me to generate unique indices, and I also need to generate non-unique indices. ...

3. 'unable to resolve property to corresponding index' error    forum.hibernate.org

I have the following code in a DAO String selectStatement = "select {campaignFinishedProduct.*}, {finishedProduct.*} " + "from gpmq.pack_compliance campaignFinishedProduct " + " join gpmq.products finishedProduct on " + " campaignFinishedProduct.manf_id_n = finishedProduct.manf_id_n and " + " campaignFinishedProduct.upc_c = finishedProduct.upc_c and " + " campaignFinishedProduct.upc_sufx_c = finishedProduct.upc_sufx_c " + " left outer join gpmq.sap_resc_upc_xref_v b on " + " campaignFinishedProduct.gcm_id = b.gcm_id ...