MailNoInfo is not mapped [ select o from MailNoInfo o where o.mailNo in(:mailNo)]-CSDN博客

本文链接：https://blog.csdn.net/zhaoyingjiao/article/details/51011437

本文讨论了在使用Hibernate进行数据库操作时遇到的错误：MailNoInfo类未被映射到数据库表。通过分析错误信息并采取正确措施（如确保类已编译并包含在项目构建路径中），作者解决了查询失败的问题。本文强调了在开发过程中确保项目构建正确性和类可见性的关键性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

添加了一个pojo类，在查询时却报了下面的错误：

Exception in thread "main" java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: MailNoInfo is not mapped [ select  o  from  MailNoInfo   o   where  o.mailNo in(:mailNo)]
	at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1679)
	at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)
	at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1608)
	at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:294)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:344)
	at com.sun.proxy.$Proxy29.createQuery(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:293)
	at com.sun.proxy.$Proxy29.createQuery(Unknown Source)
	at com.fd.dao.base.impl.BaseDao.getList(BaseDao.java:673)
	at com.fd.dao.base.impl.BaseDao.getListByCondition(BaseDao.java:657)
	at Test.testCalRate(Test.java:712)
	at Test.main(Test.java:266)
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: MailNoInfo is not mapped [ select  o  from  MailNoInfo   o   where  o.mailNo in(:mailNo)]
	at org.hibernate.hql.internal.ast.QuerySyntaxException.generateQueryException(QuerySyntaxException.java:79)
	at org.hibernate.QueryException.wrapWithQueryString(QueryException.java:103)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:218)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:142)
	at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:115)
	at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:76)
	at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:150)
	at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:298)
	at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
	at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1825)
	at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:291)
	... 16 more
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: MailNoInfo is not mapped
	at org.hibernate.hql.internal.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:171)
	at org.hibernate.hql.internal.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:91)
	at org.hibernate.hql.internal.ast.tree.FromClause.addFromElement(FromClause.java:76)
	at org.hibernate.hql.internal.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:321)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3678)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3567)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:708)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:564)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:249)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:262)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:190)
	... 24 more

查看到一篇文章（），不过还是没有解决我的问题，因为 pojo 是一个单独的项目，故想可能没有编译，就打包了一下，打包时才想到，测试时需要在 /target/lib 目录下加上这个 jar 包，不然就找不到新添加的这个类。之前新加类的时候遇到这个问题，可是今天却没有报找不到类的错误，而是报上面的错误，我的注解配置如下：

@Entity
@Table(name = "T_MAIL_NO_INFO", catalog = "fruitday_tms")
public class MailNoInfo implements Serializable {

包括 Dao， service 都跟其他pojo类是一致的，刚开始时莫名其妙，到打包时才想起我运行的是测试类。故打包放到 /target/lib 目录下就可以查询和修改成功了。