org.hibernate.QueryException:无法解析属性:filename [英] org.hibernate.QueryException: could not resolve property: filename
问题描述
我正在使用Hibernate Criteria从表contaque_recording_log中的列filename中获取值.
I am using Hibernate Criteria to get values from column filename in my table contaque_recording_log.
但是当我得到结果时，它会引发异常
But when I'm getting the result, it throws an exception
org.hibernate.QueryException:无法解析属性:com.contaque.hibernateTableMappings.contaque_recording_log的文件名
org.hibernate.QueryException: could not resolve property: filename of: com.contaque.hibernateTableMappings.contaque_recording_log
我的食用豆是:
import java.util.Date;
import javax.persistence.*;
@Entity
@Table(name="contaque_recording_log")
public class contaque_recording_log implements java.io.Serializable{
private static final long serialVersionUID = 1111222233334404L;
@Id
@Column(name="logId", insertable=true, updatable=true, unique=false)
private Integer logId;
@Column(name="userName", insertable=true, updatable=true, unique=false)
private String userName;
@Column(name="ext", insertable=true, updatable=true, unique=false)
private String ext;
@Column(name="phoneNumber", insertable=true, updatable=true, unique=false)
private String phoneNumber;
@Column(name="callerId", insertable=true, updatable=true, unique=false)
private String callerId;
@Column(name="fileName", insertable=true, updatable=true, unique=false)
private String fileName;
@Column(name="campName", insertable=true, updatable=true, unique=false)
private String campName;
@Temporal(javax.persistence.TemporalType.TIMESTAMP)
@Column(name="eventDate", insertable=true, updatable=true, unique=false)
private Date eventDate;
@Column(name="disposition", insertable=true, updatable=true, unique=false)
private String disposition;
@Column(name="duration", insertable=true, updatable=true, unique=false)
private String duration;
@Column(name="calltype", insertable=true, updatable=true, unique=false)
private String calltype;
public Date getEventDate() {
return eventDate;
}
public void setEventDate(Date eventDate) {
this.eventDate = eventDate;
}
public String getCallerId() {
return callerId;
}
public void setCallerId(String callerId) {
this.callerId = callerId;
}
public String getExt() {
return ext;
}
public void setExt(String ext) {
this.ext = ext;
}
public String getFileName() {
return fileName;
}
public void setFileName(String fileName) {
this.fileName = fileName;
}
public String getPhoneNumber() {
return phoneNumber;
}
public void setPhoneNumber(String phoneNumber) {
this.phoneNumber = phoneNumber;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public Integer getLogId() {
return logId;
}
public void setLogId(Integer logId) {
this.logId = logId;
}
public String getCampName() {
return campName;
}
public void setCampName(String campName) {
this.campName = campName;
}
public String getDisposition() {
return disposition;
}
public void setDisposition(String disposition) {
this.disposition = disposition;
}
public String getDuration() {
return duration;
}
public void setDuration(String duration) {
this.duration = duration;
}
public String getCalltype() {
return calltype;
}
public void setCalltype(String calltype) {
this.calltype = calltype;
}
}
我从中获取hibernate-session的hibernateUtil类:
MY hibernateUtil class from where I'm getting hibernate-session:
public enum HibernateUtilSpice {
INSTANCE;
public static SessionFactory sessionFactory = null;
private synchronized SessionFactory getSessionFactory(){
if(sessionFactory == null){
Configuration config = new Configuration();
config.addAnnotatedClass(contaque_recording_log.class);
config.addAnnotatedClass(contaque_servers.class);
config.configure();
//get the properties from Hibernate configuration file
Properties configProperties = config.getProperties();
ServiceRegistryBuilder serviceRegisteryBuilder = new ServiceRegistryBuilder();
ServiceRegistry serviceRegistry = serviceRegisteryBuilder.applySettings(configProperties).buildServiceRegistry();
sessionFactory = config.buildSessionFactory(serviceRegistry);
}
return sessionFactory;
}
public Session getSession(){
return getSessionFactory().openSession();
}
}
我从表中获取数据的方法:
My method where I'm getting the data from table:
public String getFileName() {
try{
hibernateSession = HibernateUtilSpice.INSTANCE.getSession();
Criteria criteria = hibernateSession.createCriteria(contaque_recording_log.class);
criteria.add(Restrictions.eq("campname", "spice"));
criteria.add(Restrictions.eq("disposition", "WN"));
criteria.setProjection(Projections.property("filename"));
List list = criteria.list();
for (Object object : list) {
System.out.println("List obj: " + object);
}
} catch (Exception e){
e.printStackTrace();
} finally {
hibernateSession.flush();
hibernateSession.close();
}
return filename;
}
如果我打印criteria.toString()，则O/P为:
If I print the criteria.toString(), the O/P is:
CriteriaImpl(com.contaque.hibernateTableMappings.contaque_recording_log:this[][campname=spice, disposition=WN]filename)
我要去哪里错了，如何从表格中获取数据?
where am I going wrong, how do I get the data from my Table?
推荐答案
休眠查询的属性名称区分大小写(因为它们最终依赖于@Entity上的getter/setter方法).
Hibernate queries are case sensitive with property names (because they end up relying on getter/setter methods on the @Entity).
确保在条件"查询中，而不是在"filename"中，将属性称为"fileName".
Make sure you refer to the property as fileName in the Criteria query, not filename.
具体来说，Hibernate在执行该Criteria查询时将调用filename属性的getter方法，因此它将寻找一个名为getFilename()的方法.但是该属性称为FileName和吸气剂getFileName().
Specifically, Hibernate will call the getter method of the filename property when executing that Criteria query, so it will look for a method called getFilename(). But the property is called FileName and the getter getFileName().
因此，像这样更改投影:
So, change the projection like so:
criteria.setProjection(Projections.property("fileName"));
这篇关于org.hibernate.QueryException:无法解析属性:filename的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
