PBWDP项目未解决问题总结

1. 持久层实体注解@Entity中增加name属性导致HQL查询异常

??? @Entity(name="greenpages.jpa.model.Listing")
??? @Table(name="LISTING")
??? public class Listing implements Serializable{

? ? ...... ??

??? }

?

??? String queryString = "select l from Listing l where upper(l.lastName) like ?";
??? List<Listing> list = this.getHibernateTemplate().find(queryString,new Object[]{"%" +

??? term.toUpperCase() + "%"});

?

??? 说明：当@Entity注解指定name属性时，上述查询语句：queryString或写成：

??? select l from greenpages.jpa.model.Listing l where upper(l.lastName) like ?，

??? 都将产生异常：

??? org.hibernate.QueryException: in expected: l [select l from Listing l where upper(l.lastName)

??? like ?]，

??? 若不指定该属性，则查询语句：queryString也可写成：

??? select l from greenpages.jpa.model.Listing l where upper(l.lastName) like ?，查询均成功。

2.

?

?