Chào mọi người , mình đang làm thực hành làm website về bán hàng bằng Spring MVC. Mình có thực hiện câu truy vấn để lấy ra các sản phẩm của từng danh mục bằng Hibernate.

Đây là lớp entities của mình:

package com.dnweb.springmvcshoeshop.entities;
// Generated Apr 30, 2017 10:28:13 AM by Hibernate Tools 4.3.5.Final

import java.util.HashSet;
import java.util.Set;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.Id;
import javax.persistence.OneToMany;
import javax.persistence.Table;


@Entity
@Table(name = "category")
public class Category implements java.io.Serializable {

	private static final long serialVersionUID = -192560943260065434L;
	
	private String id;
	private String name;
	private Set<Product> products = new HashSet<Product>(0);

	@Id

	@Column(name = "id", unique = true, nullable = false, length = 11)
	public String getId() {
		return this.id;
	}

	public void setId(String id) {
		this.id = id;
	}

	@Column(name = "name", nullable = false)
	public String getName() {
		return this.name;
	}

	public void setName(String name) {
		this.name = name;
	}

	@OneToMany(fetch = FetchType.LAZY, mappedBy = "category")
	public Set<Product> getProducts() {
		return this.products;
	}

	public void setProducts(Set<Product> products) {
		this.products = products;
	}

}

package com.dnweb.springmvcshoeshop.entities;
// Generated Apr 30, 2017 10:28:13 AM by Hibernate Tools 4.3.5.Final

import java.util.Date;
import java.util.HashSet;
import java.util.Set;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

/**
 * Product generated by hbm2java
 */
@Entity
@Table(name = "product")
public class Product implements java.io.Serializable {


	private static final long serialVersionUID = 6621430703439619229L;
	
	private String id;
	private Category category;
	private String name;
	private double price;
	private String description;
	private Float discount;
	private Date created;
	private byte[] image;
	private Set<OrderDetail> orderdetails = new HashSet<OrderDetail>(0);

	@Id
	@Column(name = "id", unique = true, nullable = false, length = 11)
	public String getId() {
		return this.id;
	}

	public void setId(String id) {
		this.id = id;
	}

	@ManyToOne(fetch = FetchType.LAZY)
	@JoinColumn(name = "categoryid")
	public Category getCategory() {
		return this.category;
	}

	public void setCategory(Category category) {
		this.category = category;
	}

	@Column(name = "name", nullable = false)
	public String getName() {
		return this.name;
	}

	public void setName(String name) {
		this.name = name;
	}

	@Column(name = "price", nullable = false, precision = 22, scale = 0)
	public double getPrice() {
		return this.price;
	}

	public void setPrice(double price) {
		this.price = price;
	}

	@Column(name = "description", length = 65535)
	public String getDescription() {
		return this.description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	@Column(name = "discount", precision = 12, scale = 0)
	public Float getDiscount() {
		return this.discount;
	}

	public void setDiscount(Float discount) {
		this.discount = discount;
	}

	@Temporal(TemporalType.DATE)
	@Column(name = "created", nullable = false, length = 10)
	public Date getCreated() {
		return this.created;
	}

	public void setCreated(Date created) {
		this.created = created;
	}

	@Column(name = "image", nullable = false)
	public byte[] getImage() {
		return this.image;
	}

	public void setImage(byte[] image) {
		this.image = image;
	}

	@OneToMany(fetch = FetchType.LAZY, mappedBy = "product")
	public Set<OrderDetail> getOrderdetails() {
		return this.orderdetails;
	}

	public void setOrderdetails(Set<OrderDetail> orderdetails) {
		this.orderdetails = orderdetails;
	}

}

Còn đây là câu truy vấn trong lớp DAO

// Query san pham theo category
	public PaginationResult<ProductInfo> queryProductsCategory(int page, int maxResult, int maxNavigationPage,
			String categoryId, String likeName) {

		String sql = "Select new " + ProductInfo.class.getName()
				+ "((p.id, p.name, p.price, p.description, p.discount, p.category.id)) " + " from "
				+ Product.class.getName() + " p " + "inner join " 
				+ Category.class.getName() + " c " + " on "
				+ "p.category.id = c.id";

		if (likeName != null && likeName.length() > 0) {
			sql += " Where lower(p.name) like :likeName ";
		}
		sql += " order by p.created desc ";

		Session session = sessionFactory.getCurrentSession();

		// Co duoc doi tuong Query
		Query query = session.createQuery(sql);
		if (likeName != null && likeName.length() > 0) {
			query.setParameter("likeName", "%" + likeName.toLowerCase() + "%");
		}

		return new PaginationResult<ProductInfo>(query, page, maxResult, maxNavigationPage);
	}

Lớp ProductInfo

package com.dnweb.springmvcshoeshop.model;

import org.springframework.web.multipart.commons.CommonsMultipartFile;

import com.dnweb.springmvcshoeshop.entities.Product;

public class ProductInfo {

	private String id;
	private String name;
	private double price;
	private String description;
	private Float discount;
	private String categoryId;
	
	private boolean newProduct = false;

	// Upload file.
	private CommonsMultipartFile fileData;

	
	public ProductInfo() {
		
	}

	public ProductInfo(Product product) {
		this.id = product.getId();
		this.name = product.getName();
		this.price = product.getPrice();
		this.description = product.getDescription();
		this.discount = product.getDiscount();
		this.categoryId = product.getCategory().getId();
	}

	//Dung de truy van trong Hibernate
	public ProductInfo(String id, String name, double price) {
		super();
		this.id = id;
		this.name = name;
		this.price = price;
	}
	
	public ProductInfo(String id, String name, double price, String description, Float discount, String categoryId) {
		this.id = id;
		this.name = name;
		this.price = price;
		this.description = description;
		this.discount = discount;
		this.categoryId = categoryId;
	}

	public String getId() {
		return id;
	}

	public void setId(String id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public double getPrice() {
		return price;
	}

	public void setPrice(double price) {
		this.price = price;
	}
	
	public CommonsMultipartFile getFileData() {
		return fileData;
	}

	public void setFileData(CommonsMultipartFile fileData) {
		this.fileData = fileData;
	}

	public boolean isNewProduct() {
		return newProduct;
	}

	public void setNewProduct(boolean newProduct) {
		this.newProduct = newProduct;
	}

	public String getDescription() {
		return description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public Float getDiscount() {
		return discount;
	}

	public void setDiscount(Float discount) {
		this.discount = discount;
	}

	public String getCategoryId() {
		return categoryId;
	}

	public void setCategoryId(String categoryId) {
		this.categoryId = categoryId;
	}
	
	
	
}

Thông báo lỗi

type Exception report

message Request processing failed; nested exception is java.lang.IllegalStateException: DOT node with no left-hand-side!

description The server encountered an internal error that prevented it from fulfilling this request.

vậy trong câu truy vấn HQL của ình sai đoạn nào mà bị lỗi như vậy ạ? mình có tra trên stack rồi nhưng vẫn chưa sửa được. Mong mọi người giúp đỡ. Xin cảm ơn mọi người!