@Entity
@Inheritance(strategy = InheritanceType.JOINED)
@javax.persistence.Table(name = "BLC_PRODUCT")
@org.hibernate.annotations.Table(appliesTo = "BLC_PRODUCT", indexes = {
        @Index(name = "PRODUCT_URL_INDEX",
                columnNames = {"URL", "URL_KEY"}
        )
})
@Cache(usage = CacheConcurrencyStrategy.READ_WRITE, region = "blProducts")
public class ProductImpl implements Product{
    @Id
    @GeneratedValue(generator = "ProductId")
    @GenericGenerator(
            name = "ProductId",
            strategy = "org.broadleafcommerce.common.persistence.IdOverrideTableGenerator",
            parameters = {
                    @Parameter(name = "segment_value", value = "ProductImpl"),
                    @Parameter(name = "entity_name", value = "org.broadleafcommerce.core.catalog.domain.ProductImpl")
            })
public class ProductImpl implements Product{
    @Column(name = "PRODUCT_ID")
    protected Long id;

    @Column(name = "MANUFACTURE")
    protected String manufacturer;

    @Column(
        name = "URL_KEY"
    )
    protected String urlKey;

.....

}

        CriteriaBuilder builder = this.em.getCriteriaBuilder();
        CriteriaQuery<Product> criteria = builder.createQuery(Product.class);
        Root<ProductImpl> product = criteria.from(ProductImpl.class);
        FetchParent fetchParent = product.fetch("defaultSku", JoinType.LEFT);
        criteria.select(product);
        List<Predicate> restrictions = new ArrayList();
        restrictions.add(builder.equal(product.get("urlKey"), urlKey));
        restrictions.add(builder.or(builder.isNull(product.get("defaultSku").get("activeEndDate")), builder.greaterThan(product.get("defaultSku").get("activeEndDate").as(Date.class), this.getCurrentDateAfterFactoringInDateResolution())));
        criteria.where((Predicate[])restrictions.toArray(new Predicate[restrictions.size()]));
        TypedQuery<Product> query = this.em.createQuery(criteria);
        query.setHint("org.hibernate.cacheable", true);
        query.setHint("org.hibernate.cacheRegion", "query.Catalog");
        List<Product> results = query.getResultList();

//If the object is already loaded, return the loaded one
object = session.getEntityUsingInterceptor( key );
if ( object != null ) {
   //its already loaded so don't need to hydrate it
   instanceAlreadyLoaded(
         rs,
         i,
         persisters[i],
         key,
         object,
         lockModes[i],
         session
   );
}
else {
   object = instanceNotYetLoaded(
         rs,
         i,
         persisters[i],
         descriptors[i].getRowIdAlias(),
         key,
         lockModes[i],
         optionalObjectKey,
         optionalObject,
         hydratedObjects,
         session
   );
}