Hibernate后执行报错:Livell.UploadImage is not mapped ,是否哪里配置错了
Uploadimage.hbm.xml----------------------------------
<hibernate-mapping>
<class name="com.hycrm.bean.Uploadimage" table="LIVELL.UPLOADIMAGE" select-before-update="true">
<id name="imgid" type="integer">
<column name="IMGID" />
</id>
<property name="item" type="string">
<column name="ITEM" length="50" />
</property>
<property name="imgUrl" type="string">
<column name="IMG_URL" length="300"/>
</property>
<property name="imgLess" type="string">
<column name="IMG_LESS" length="300"/>
</property>
<property name="imgOrder" type="integer">
<column name="IMG_ORDER" precision="22" scale="0" />
</property>
<property name="imgSize" type="double">
<column name="IMG_SIZE" precision="126" scale="0" />
</property>
<property name="title" type="string">
<column name="TITLE" length="100"/>
</property>
<property name="hits" type="integer">
<column name="HITS" precision="22" scale="0" />
</property>
<property name="addtime" type="date">
<column name="ADDTIME" length="7" />
</property>
<property name="face" type="boolean">
<column name="FACE" precision="1" scale="0" />
</property>
<property name="userid" type="string">
<column name="USERID" length="50" />
</property>
<property name="adminid" type="string">
<column name="ADMINID" length="50" />
</property>
<property name="sno" type="string">
<column name="SNO" />
</property>
<property name="content" type="clob">
<column name="CONTENT" />
</property>
</class>
</hibernate-mapping>
Uploadimage.java----------------------------------------
import java.sql.Clob;
import java.util.Date;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
public class Uploadimage implements java.io.Serializable {
private static final long serialVersionUID = 1L;
private int imgid;
private String item;
private String imgUrl;
private String imgLess;
private int imgOrder;
private double imgSize;
private String title;
private int hits;
private Date addtime;
private boolean face;
private String userid;
private String adminid;
private String sno;
private Clob content;
getters & setters……
}
UploadimageDAO.java----------------------------------------
public List<Uploadimage> findBySNO(String strSNO) {
String strHQL="SELECT IMGID,IMG_URL,IMG_LESS,IMG_SIZE,TITLE,SNO FROM LIVELL.UPLOADIMAGE WHERE SNO='"+strSNO+"'";
return (List<Uploadimage>)this.getHibernateTemplate().find(strHQL);
}
}
执行返回结果--------------------------------------------------
LIVELL.UPLOADIMAGE is not mapped ; nested exception is org.hibernate.hql.ast.QuerySyntaxException: LIVELL.UPLOADIMAGE is not mapped
[解决办法]