首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > JAVA > J2EE开发 >

Hibernate后执行报错:Livell.UploadImage is not 地图ped ,是否哪里配置错了

2012-07-26 
Hibernate后执行报错:Livell.UploadImage is not mapped ,是否哪里配置错了Uploadimage.hbm.xml----------

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

[解决办法]

探讨
String strHQL="SELECT IMGID,IMG_URL,IMG_LESS,IMG_SIZE,TITLE,SNO FROM LIVELL.UPLOADIMAGE WHERE SNO='"+strSNO+"'";

[解决办法]
public List<Uploadimage> findBySNO(String strSNO) {
String strHQL="SELECT imgid,imgUrl,imgLess,imgSize,title FROM Uploadimage WHERE sno='"+strSNO+"'";
return (List<Uploadimage>)this.getHibernateTemplate().find(strHQL);
}

热点排行