Java org.hibernate.hql.internal.ast.QuerySyntaxException：未映射 [来自团队]
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21796190/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-08-13 10:41:22 来源:igfitidea点击:
org.hibernate.hql.internal.ast.QuerySyntaxException: is not mapped [from Team]
提问by Sobik
I'm working on little Spring MVC CRUD application. Got some strange problems:
我正在研究小型 Spring MVC CRUD 应用程序。遇到了一些奇怪的问题：
configuration class:
package sbk.spring.simplejc.config; import java.util.Properties; import javax.annotation.Resource; import javax.sql.DataSource; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.ComponentScan; import org.springframework.context.annotation.Configuration; import org.springframework.context.annotation.Import; import org.springframework.context.annotation.PropertySource; import org.springframework.core.env.Environment; import org.springframework.jdbc.datasource.DriverManagerDataSource; import org.springframework.orm.hibernate4.HibernateTransactionManager; import org.springframework.orm.hibernate4.LocalSessionFactoryBean; import org.springframework.transaction.annotation.EnableTransactionManagement; import org.springframework.web.servlet.config.annotation.EnableWebMvc; import org.springframework.web.servlet.config.annotation.ResourceHandlerRegistry; import org.springframework.web.servlet.config.annotation.WebMvcConfigurerAdapter; import org.springframework.web.servlet.view.JstlView; import org.springframework.web.servlet.view.UrlBasedViewResolver; @Configuration //Specifies the class as configuration @ComponentScan("sbk.spring.simplejc") //Specifies which package to scan //@Import({DataBaseConfig.class}) @EnableTransactionManagement @PropertySource("classpath:application.properties") @EnableWebMvc //Enables to use Spring's annotations in the code public class WebAppConfig extends WebMvcConfigurerAdapter{ private static final String PROPERTY_NAME_DATABASE_DRIVER = "db.driver"; private static final String PROPERTY_NAME_DATABASE_PASSWORD = "db.password"; private static final String PROPERTY_NAME_DATABASE_URL = "db.url"; private static final String PROPERTY_NAME_DATABASE_USERNAME = "db.username"; private static final String PROPERTY_NAME_HIBERNATE_DIALECT = "hibernate.dialect"; private static final String PROPERTY_NAME_HIBERNATE_SHOW_SQL = "hibernate.show_sql"; private static final String PROPERTY_NAME_ENTITYMANAGER_PACKAGES_TO_SCAN = "entitymanager.packages.to.scan"; @Resource private Environment env; @Bean public DataSource dataSource() { DriverManagerDataSource dataSource = new DriverManagerDataSource(); dataSource.setDriverClassName(env.getRequiredProperty(PROPERTY_NAME_DATABASE_DRIVER)); dataSource.setUrl(env.getRequiredProperty(PROPERTY_NAME_DATABASE_URL)); dataSource.setUsername(env.getRequiredProperty(PROPERTY_NAME_DATABASE_USERNAME)); dataSource.setPassword(env.getRequiredProperty(PROPERTY_NAME_DATABASE_PASSWORD)); return dataSource; } @Bean public LocalSessionFactoryBean sessionFactory() { LocalSessionFactoryBean sessionFactoryBean = new LocalSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource()); sessionFactoryBean.setPackagesToScan(env.getRequiredProperty(PROPERTY_NAME_ENTITYMANAGER_PACKAGES_TO_SCAN)); sessionFactoryBean.setHibernateProperties(hibProperties()); return sessionFactoryBean; } private Properties hibProperties() { Properties properties = new Properties(); properties.put(PROPERTY_NAME_HIBERNATE_DIALECT, env.getRequiredProperty(PROPERTY_NAME_HIBERNATE_DIALECT)); properties.put(PROPERTY_NAME_HIBERNATE_SHOW_SQL, env.getRequiredProperty(PROPERTY_NAME_HIBERNATE_SHOW_SQL)); return properties; } @Bean public HibernateTransactionManager transactionManager() { HibernateTransactionManager transactionManager = new HibernateTransactionManager(); transactionManager.setSessionFactory(sessionFactory().getObject()); return transactionManager; } @Override public void addResourceHandlers(ResourceHandlerRegistry registry) { registry.addResourceHandler("/resources/**").addResourceLocations("/resources/"); } @Bean public UrlBasedViewResolver setupViewResolver() { UrlBasedViewResolver resolver = new UrlBasedViewResolver(); resolver.setPrefix("/WEB-INF/views/"); resolver.setSuffix(".jsp"); resolver.setViewClass(JstlView.class); return resolver; } }application.properties:#DB properties: db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver db.url=jdbc:sqlserver://127.0.0.1:1433;databaseName=Examples db.username=sa db.password= #Hibernate Configuration: hibernate.dialect=org.hibernate.dialect.SQLServerDialect hibernate.show_sql=true entitymanager.packages.to.scan=sbk.spring.simplejc.entity@Entityclass:package sbk.spring.simplejc.entity; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; import javax.persistence.Table; @Entity @Table(name="Team") public class Team { @Id @GeneratedValue private Integer id; private String name; private Integer rating; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public Integer getRating() { return rating; } public void setRating(Integer rating) { this.rating = rating; } }Controller class:
package sbk.spring.simplejc.controller; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.servlet.ModelAndView; import sbk.spring.simplejc.service.ITeamService; @Controller public class TeamController { @Autowired ITeamService service; @RequestMapping(value="/") public ModelAndView goToHelloPage() { ModelAndView view = new ModelAndView(); view.addObject("teamList", service.listTeams()); return view; } }Error stack trace:
org.hibernate.hql.internal.ast.QuerySyntaxException: Team is not mapped [from Team] org.hibernate.hql.internal.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:180) org.hibernate.hql.internal.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:110) org.hibernate.hql.internal.ast.tree.FromClause.addFromElement(FromClause.java:93) org.hibernate.hql.internal.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:324) org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3420) org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3309) org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:706) org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:562) org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:299) org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:247) org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:248) org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183) org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136) org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:105) org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80) org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168) org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:221) org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:199) org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1777) sbk.spring.simplejc.dao.HibTeamDAO.listTeams(HibTeamDAO.java:23) sbk.spring.simplejc.service.TeamService.listTeams(TeamService.java:27)
配置类：
package sbk.spring.simplejc.config; import java.util.Properties; import javax.annotation.Resource; import javax.sql.DataSource; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.ComponentScan; import org.springframework.context.annotation.Configuration; import org.springframework.context.annotation.Import; import org.springframework.context.annotation.PropertySource; import org.springframework.core.env.Environment; import org.springframework.jdbc.datasource.DriverManagerDataSource; import org.springframework.orm.hibernate4.HibernateTransactionManager; import org.springframework.orm.hibernate4.LocalSessionFactoryBean; import org.springframework.transaction.annotation.EnableTransactionManagement; import org.springframework.web.servlet.config.annotation.EnableWebMvc; import org.springframework.web.servlet.config.annotation.ResourceHandlerRegistry; import org.springframework.web.servlet.config.annotation.WebMvcConfigurerAdapter; import org.springframework.web.servlet.view.JstlView; import org.springframework.web.servlet.view.UrlBasedViewResolver; @Configuration //Specifies the class as configuration @ComponentScan("sbk.spring.simplejc") //Specifies which package to scan //@Import({DataBaseConfig.class}) @EnableTransactionManagement @PropertySource("classpath:application.properties") @EnableWebMvc //Enables to use Spring's annotations in the code public class WebAppConfig extends WebMvcConfigurerAdapter{ private static final String PROPERTY_NAME_DATABASE_DRIVER = "db.driver"; private static final String PROPERTY_NAME_DATABASE_PASSWORD = "db.password"; private static final String PROPERTY_NAME_DATABASE_URL = "db.url"; private static final String PROPERTY_NAME_DATABASE_USERNAME = "db.username"; private static final String PROPERTY_NAME_HIBERNATE_DIALECT = "hibernate.dialect"; private static final String PROPERTY_NAME_HIBERNATE_SHOW_SQL = "hibernate.show_sql"; private static final String PROPERTY_NAME_ENTITYMANAGER_PACKAGES_TO_SCAN = "entitymanager.packages.to.scan"; @Resource private Environment env; @Bean public DataSource dataSource() { DriverManagerDataSource dataSource = new DriverManagerDataSource(); dataSource.setDriverClassName(env.getRequiredProperty(PROPERTY_NAME_DATABASE_DRIVER)); dataSource.setUrl(env.getRequiredProperty(PROPERTY_NAME_DATABASE_URL)); dataSource.setUsername(env.getRequiredProperty(PROPERTY_NAME_DATABASE_USERNAME)); dataSource.setPassword(env.getRequiredProperty(PROPERTY_NAME_DATABASE_PASSWORD)); return dataSource; } @Bean public LocalSessionFactoryBean sessionFactory() { LocalSessionFactoryBean sessionFactoryBean = new LocalSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource()); sessionFactoryBean.setPackagesToScan(env.getRequiredProperty(PROPERTY_NAME_ENTITYMANAGER_PACKAGES_TO_SCAN)); sessionFactoryBean.setHibernateProperties(hibProperties()); return sessionFactoryBean; } private Properties hibProperties() { Properties properties = new Properties(); properties.put(PROPERTY_NAME_HIBERNATE_DIALECT, env.getRequiredProperty(PROPERTY_NAME_HIBERNATE_DIALECT)); properties.put(PROPERTY_NAME_HIBERNATE_SHOW_SQL, env.getRequiredProperty(PROPERTY_NAME_HIBERNATE_SHOW_SQL)); return properties; } @Bean public HibernateTransactionManager transactionManager() { HibernateTransactionManager transactionManager = new HibernateTransactionManager(); transactionManager.setSessionFactory(sessionFactory().getObject()); return transactionManager; } @Override public void addResourceHandlers(ResourceHandlerRegistry registry) { registry.addResourceHandler("/resources/**").addResourceLocations("/resources/"); } @Bean public UrlBasedViewResolver setupViewResolver() { UrlBasedViewResolver resolver = new UrlBasedViewResolver(); resolver.setPrefix("/WEB-INF/views/"); resolver.setSuffix(".jsp"); resolver.setViewClass(JstlView.class); return resolver; } }application.properties：#DB properties: db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver db.url=jdbc:sqlserver://127.0.0.1:1433;databaseName=Examples db.username=sa db.password= #Hibernate Configuration: hibernate.dialect=org.hibernate.dialect.SQLServerDialect hibernate.show_sql=true entitymanager.packages.to.scan=sbk.spring.simplejc.entity@Entity班级：package sbk.spring.simplejc.entity; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; import javax.persistence.Table; @Entity @Table(name="Team") public class Team { @Id @GeneratedValue private Integer id; private String name; private Integer rating; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public Integer getRating() { return rating; } public void setRating(Integer rating) { this.rating = rating; } }控制器类：
package sbk.spring.simplejc.controller; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.servlet.ModelAndView; import sbk.spring.simplejc.service.ITeamService; @Controller public class TeamController { @Autowired ITeamService service; @RequestMapping(value="/") public ModelAndView goToHelloPage() { ModelAndView view = new ModelAndView(); view.addObject("teamList", service.listTeams()); return view; } }错误堆栈跟踪：
org.hibernate.hql.internal.ast.QuerySyntaxException: Team is not mapped [from Team] org.hibernate.hql.internal.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:180) org.hibernate.hql.internal.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:110) org.hibernate.hql.internal.ast.tree.FromClause.addFromElement(FromClause.java:93) org.hibernate.hql.internal.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:324) org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3420) org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3309) org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:706) org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:562) org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:299) org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:247) org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:248) org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183) org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136) org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:105) org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80) org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168) org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:221) org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:199) org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1777) sbk.spring.simplejc.dao.HibTeamDAO.listTeams(HibTeamDAO.java:23) sbk.spring.simplejc.service.TeamService.listTeams(TeamService.java:27)
I haven't got a clue about this issue.
我对这个问题一无所知。
Update
更新
DAO class:
package sbk.spring.simplejc.dao; import java.util.List; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Repository; import sbk.spring.simplejc.entity.Team; @Repository public class HibTeamDAO implements TeamDAO { @Autowired private SessionFactory sessionFactory; public void addTeam(Team team) { sessionFactory.getCurrentSession().save(team); } public void updateTeam(Team team) { sessionFactory.getCurrentSession().update(team); } @SuppressWarnings("unchecked") public List<Team> listTeams() { return sessionFactory.getCurrentSession().createQuery("from Team").list(); } @SuppressWarnings("unchecked") public Team getTeamById(Integer teamID) { Session session = sessionFactory.getCurrentSession(); List<Team> listTeam = session.createQuery("from Team t where t.id = :teamID") .setParameter("teamID", teamID) .list(); return listTeam.size() > 0 ? (Team)listTeam.get(0) : null; } public void removeTeam(Integer teamID) { Team team = (Team) sessionFactory.getCurrentSession().load(Team.class, teamID); if(team != null){ sessionFactory.getCurrentSession().delete(team); } } @Override public Integer count() { return (Integer) sessionFactory.getCurrentSession().createQuery("select count(t) from Team t").uniqueResult(); } }TeamControllerclass:package sbk.spring.simplejc.controller; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.servlet.ModelAndView; import sbk.spring.simplejc.service.ITeamService; @Controller public class TeamController { @Autowired ITeamService service; @RequestMapping(value="/") public ModelAndView goToHelloPage() { ModelAndView view = new ModelAndView(); view.addObject("teamList", service.listTeams()); return view; } }
DAO类：
package sbk.spring.simplejc.dao; import java.util.List; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Repository; import sbk.spring.simplejc.entity.Team; @Repository public class HibTeamDAO implements TeamDAO { @Autowired private SessionFactory sessionFactory; public void addTeam(Team team) { sessionFactory.getCurrentSession().save(team); } public void updateTeam(Team team) { sessionFactory.getCurrentSession().update(team); } @SuppressWarnings("unchecked") public List<Team> listTeams() { return sessionFactory.getCurrentSession().createQuery("from Team").list(); } @SuppressWarnings("unchecked") public Team getTeamById(Integer teamID) { Session session = sessionFactory.getCurrentSession(); List<Team> listTeam = session.createQuery("from Team t where t.id = :teamID") .setParameter("teamID", teamID) .list(); return listTeam.size() > 0 ? (Team)listTeam.get(0) : null; } public void removeTeam(Integer teamID) { Team team = (Team) sessionFactory.getCurrentSession().load(Team.class, teamID); if(team != null){ sessionFactory.getCurrentSession().delete(team); } } @Override public Integer count() { return (Integer) sessionFactory.getCurrentSession().createQuery("select count(t) from Team t").uniqueResult(); } }TeamController班级：package sbk.spring.simplejc.controller; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.servlet.ModelAndView; import sbk.spring.simplejc.service.ITeamService; @Controller public class TeamController { @Autowired ITeamService service; @RequestMapping(value="/") public ModelAndView goToHelloPage() { ModelAndView view = new ModelAndView(); view.addObject("teamList", service.listTeams()); return view; } }
Update
更新
Now I got rid from this problem by changing DAO method from
现在我通过改变 DAO 方法摆脱了这个问题
return sessionFactory.getCurrentSession().createQuery("from Team").list();
to
到
return sessionFactory.getCurrentSession().createQuery("from sbk.spring.simplejc.entity.Team").list();
But received another issue: every query return null despite of existing rows in Teamtable.
但收到另一个问题：尽管Team表中存在现有行，但每个查询都返回 null 。
Update
更新
Finally I noticed warning messages:
最后我注意到警告消息：
Feb 15, 2014 7:01:05 PM org.hibernate.hql.internal.QuerySplitter concreteQueries
WARN: HHH000183: no persistent classes found for query class: from sbk.spring.simplejc.entity.Team
Update
更新
At least I've sorted out this issue by adding next row of code in dataSourcebean definition in WebAppConfig:
至少我已经通过在dataSourcebean 定义中添加下一行代码解决了这个问题WebAppConfig：
public LocalSessionFactoryBean sessionFactory() {
LocalSessionFactoryBean sessionFactoryBean = new LocalSessionFactoryBean();
sessionFactoryBean.setDataSource(dataSource());
sessionFactoryBean.setAnnotatedClasses(new Class[]{Team.class});//new row!!!
sessionFactoryBean.setPackagesToScan(env.getRequiredProperty(PROPERTY_NAME_ENTITYMANAGER_PACKAGES_TO_SCAN));
sessionFactoryBean.setHibernateProperties(hibProperties());
return sessionFactoryBean;
}
回答by MolodecSerg
"No, in this instance I've got org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: * near line 1, column 8 [select * from Team] – Sobik Feb 15 at 10:29"
“不，在这种情况下，我有 org.hibernate.hql.internal.ast.QuerySyntaxException：意外标记：* 靠近第 1 行，第 8 列 [从团队中选择*] – Sobik 2 月 15 日 10:29”
Instead "Select * from Team" try write "from Team". Because Hibernate works with java entity.
相反，“从团队中选择*”尝试编写“来自团队”。因为 Hibernate 与 java 实体一起工作。
回答by Hari
In my case it was because I didn't have the hibernate packagesToScan property. I see that you have it. May be this comment will be useful for someone who missed it.
就我而言，这是因为我没有 hibernate packagesToScan 属性。我看到你有它。可能此评论对错过它的人有用。
