我的错误提示为
org.hibernate.hql.ast.QuerySyntaxException: LIBRARY is not mapped [select l from LIBRARY as l order by l.id]
at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:181)数据库的表叫LIBRARY,有三个字段ID,TITLE,CONTENT,其中ID为主键
关键代码为
model.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="hbm.DVDItem" table="LIBRARY">
<id name="id" type="int" column="ID" >
<generator class="native"/>
</id>
<property name="title" column="TITLE"/>
<property name="content" column="CONTENT" />
</class>
</hibernate-mapping>javabean放在hbm包内
package hbm;
public class DVDItem {
private int id;
private String title;
private String content; public DVDItem(){} public int getId() {
return id;
} public void setId(int id) {
this.id = id;
} public String getTitle() {
return title;
} public void setTitle(String title) {
this.title = title;
} public String getContent() {
return content;
} public void setContent(String content) {
this.content = content;
}}
在代码中用到了查询语句为select l from LIBRARY as l order by l.id
不知道哪映射错了,麻烦大家帮我看看 谢谢
org.hibernate.hql.ast.QuerySyntaxException: LIBRARY is not mapped [select l from LIBRARY as l order by l.id]
at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:181)数据库的表叫LIBRARY,有三个字段ID,TITLE,CONTENT,其中ID为主键
关键代码为
model.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="hbm.DVDItem" table="LIBRARY">
<id name="id" type="int" column="ID" >
<generator class="native"/>
</id>
<property name="title" column="TITLE"/>
<property name="content" column="CONTENT" />
</class>
</hibernate-mapping>javabean放在hbm包内
package hbm;
public class DVDItem {
private int id;
private String title;
private String content; public DVDItem(){} public int getId() {
return id;
} public void setId(int id) {
this.id = id;
} public String getTitle() {
return title;
} public void setTitle(String title) {
this.title = title;
} public String getContent() {
return content;
} public void setContent(String content) {
this.content = content;
}}
在代码中用到了查询语句为select l from LIBRARY as l order by l.id
不知道哪映射错了,麻烦大家帮我看看 谢谢
解决方案 »
- EJB + jboss开发 java.lang.NoSuchMethodError
- jsp编码过虑
- 在线等...jquery 的html 方法问题。。
- ACTION 取不到隐藏域hidden的值!!!
- 关于一个IP配置多个服务器的问题
- String str = session.getId();这样得到的是sessionid吗?
- 有没有把Jar转换为exe可执行文件的办法? [基础知识]
- JSP怎样能把链接的地址作为参数传递
- Axis里面部署的webservice想要返回自定义类型应该如何写wsdd
- JTree控件如何利用鼠标右键弹出Popup菜单
- 求petstore(Struts+EJB3)的图片
- 高分求助hibernate通用dao问题。求解!
在form后面跟的是类名。不是表名
<hibernate-mapping>
<class name="hbm.DVDItem" table="LIBRARY">
<id name="id" type="int" column="ID" >
<generator class="native"/>
</id>
<property name="title" column="TITLE"/>
<property name="content" column="CONTENT" />
</class>
</hibernate-mapping> <class name="hbm.DVDItem" table="LIBRARY">
<id name="id" type="java.lang.Long">
<column name="ID" precision="22" scale="0" />
<generator class="native" />
</id>
<property name="title" type="java.lang.String">
<column name="TITLE" />
</property>
<property name="content" type="java.lang.String">
<column name="CONTENT" />
</property>
</class>
你用的session.createSQLQuery()就得用数据库中表名了
很明显 这个类LIBRARY 没有被映射
还有就是在HQL语句里面 用的不是数据库表的名字 而是与之相对应的Entity,属性也是 也应该是Entity的属性 不是数据库列的名字