关于映射is not mapped问题

lihao1129 2013-08-06 08:49:25
xml
<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

	xmlns:jaxws="http://cxf.apache.org/jaxws"

	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd

	http://cxf.apache.org/jaxws http://cxf.apache.org/schemas/jaxws.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">









	<bean id="placeholderConfig"

		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

		<property name="location">

			<value>classpath:qiantai.properties</value>

		</property>

	</bean>

	<!--

		<bean id="DBConn" class="com.gtom.wapcms.system.util.DBConn"

			lazy-init="false">

			<property name="m_dbConn">

				<bean class="com.gtom.wapcms.system.util.DatasourceDBConn">

					<property name="datasource">

						<ref bean="dataSource" />

					</property>

				</bean>

			</property>

		</bean> -->

	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"

		destroy-method="close">

		<property name="driverClassName">

			<value>oracle.jdbc.driver.OracleDriver</value>

		</property>

		<property name="url">

			<value>${jdbc.url}</value>

		</property>

		<property name="username">

			<value>${jdbc.user}</value>

		</property>

		<property name="password">

			<value>${jdbc.password}</value>

		</property>

		<property name="initialSize">

			<value>${jdbc.initPoolSize}</value>

		</property>

		<property name="maxActive">

			<value>${jdbc.maxPoolSize}</value>

		</property>

		<property name="minIdle">

			<value>2</value>

		</property>

	</bean>





	



	<!-- 数据库配置 事务stat-->

	<bean id="sessionFactory"

		class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"

		lazy-init="false">

		<property name="dataSource">

			<ref bean="dataSource" />

		</property>

		<property name="hibernateProperties">

			<props>

				<prop key="hibernate.show_sql">false</prop>

				<prop key="hibernate.format_sql">true</prop>

				<prop key="hibernate.use_sql_comments">true</prop>

				<prop key="hibernate.generate_statistics">false</prop>

				<prop key="hibernate.hbm2ddl.auto">false</prop>

				<prop key="hibernate.dialect"> org.hibernate.dialect.Oracle9Dialect </prop>

			</props>

		</property>

		<!--<property name="mappingDirectoryLocations">

			property name="mappingLocations"



				<list>

					<value>WEB-INF/mappings</value>

					<value>classpath:/com/lh/bdqn/web/vo/FoodModel</value>

				</list>

			</property>-->

	</bean>

	<!--

	<bean id="transactionManager"

		class="org.springframework.orm.hibernate3.HibernateTransactionManager">

		<property name="sessionFactory">

			<ref local="sessionFactory" />

		</property>

	</bean>

	

	<tx:advice id="txAdvice" transaction-manager="transactionManager">

        <tx:attributes>

            <tx:method name="upd*" propagation="REQUIRED" read-only="false" />

            <tx:method name="del*" propagation="REQUIRED" read-only="false" />

            <tx:method name="add*" propagation="REQUIRED" read-only="false" />

            <tx:method name="insert*" propagation="REQUIRED" read-only="false" />

            <tx:method name="find*" propagation="SUPPORTS" read-only="true" />

            <tx:method name="query*" propagation="SUPPORTS" read-only="true" />

            <tx:method name="*" propagation="SUPPORTS" read-only="true" />

        </tx:attributes>

    </tx:advice>

	-->

	

	<!--声明事务代理模板-->

	<bean id="txProxyTemplate" abstract="true"

		class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">



		<property name="transactionManager">

			<ref bean="transactionManager" />

		</property>

		<property name="transactionAttributes">

			<props>

				<prop key="find*">PROPAGATION_SUPPORTS,readOnly</prop>

				<prop key="get*">PROPAGATION_SUPPORTS,readOnly</prop>

				<prop key="create*">PROPAGATION_REQUIRED</prop>

				<prop key="save*">PROPAGATION_REQUIRED</prop>

				<prop key="remove*">PROPAGATION_REQUIRED</prop>

				<prop key="update*">PROPAGATION_REQUIRED</prop>

				<prop key="delete*">PROPAGATION_REQUIRED</prop>

				<prop key="insert*">PROPAGATION_REQUIRED</prop>

				<prop key="*">PROPAGATION_SUPPORTS,readOnly</prop>

			</props>

		</property>

	</bean>

	<bean id="transactionManager"

		class="org.springframework.orm.hibernate3.HibernateTransactionManager">

		<property name="sessionFactory">

			<ref bean="sessionFactory" />

		</property>

	</bean>

	<!-- 事务控制end -->

</beans>


映射的实体类
package com.lh.bdqn.web.vo;



import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.Table;



/**

 * @param id id

 * @param FOOD_TYPE_ID 食物类型ID

 * @param foddName 食物名称

 * @param foodPrice 价格

 * @author lihao

 *

 */

@Entity

@Table(name = "T_FOOD_NAME")

public class FoodNameModel {

	@Id   

	@GeneratedValue(strategy = GenerationType.AUTO)

	private String ID;

	@Column(name="FOOD_TYPE_ID",nullable=false,length=10)

	private String FOOD_TYPE_ID;

	@Column(name="FOOT_NAME",nullable=false,length=10)

	private String FOOT_NAME;

	@Column(name="FOOT_PRICE",nullable=false,length=10)

	private String FOOT_PRICE;

	public String getID() {

		return ID;

	}

	public void setID(String iD) {

		ID = iD;

	}

	public String getFOOD_TYPE_ID() {

		return FOOD_TYPE_ID;

	}

	public void setFOOD_TYPE_ID(String fOODTYPEID) {

		FOOD_TYPE_ID = fOODTYPEID;

	}

	public String getFOOT_NAME() {

		return FOOT_NAME;

	}

	public void setFOOT_NAME(String fOOTNAME) {

		FOOT_NAME = fOOTNAME;

	}

	public String getFOOT_PRICE() {

		return FOOT_PRICE;

	}

	public void setFOOT_PRICE(String fOOTPRICE) {

		FOOT_PRICE = fOOTPRICE;

	}

	

}




org.springframework.orm.hibernate3.HibernateQueryException: T_FOOD_NAME is not mapped [FROM T_FOOD_NAME t where t.FOOT_TYPE_ID = 1]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: T_FOOD_NAME is not mapped [FROM T_FOOD_NAME t where t.FOOT_TYPE_ID = 1]

	at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:657)

	at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)

	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)

	at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)

	at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:921)

	at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:913)

	at com.lh.bdqn.web.dao.impl.BaseDaoImpl.query(BaseDaoImpl.java:18)

	at com.lh.bdqn.web.service.impl.FoodDaoImpl.queryFoodById(FoodDaoImpl.java:39)

	at com.lh.bdqn.web.action.StrutsAction.execute(StrutsAction.java:48)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

	at java.lang.reflect.Method.invoke(Method.java:597)

	at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)

	at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)

	at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)

	at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
...全文
7105 11 打赏 收藏 转发到动态 举报
写回复
用AI写文章
11 条回复
切换为时间正序
请发表友善的回复…
发表回复
花谢尊前不敢香 2013-08-06
  • 打赏
  • 举报
 回复
hql查询的是实体，sql查询是表名。
chenchenchenliu 2013-08-06
  • 打赏
  • 举报
 回复 
@SuppressWarnings("all")
	@Override
	public List queryFoodById(String id) {
		List<FoodNameModel> list = new ArrayList<FoodNameModel>();
		try {
			
			//String hql = "FROM T_FOOD_NAME t where t.FOOT_TYPE_ID = "+id;
                        String hql = "FROM FoodNameModel  t where t.FOOT_TYPE_ID = "+id;//from后面跟的是实体类的名字而不是数据库中表的名字
			list = ibasedao.query(hql);
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
		return list;
	}
lihao1129 2013-08-06
  • 打赏
  • 举报
 回复
引用 7 楼 fangmingshijie 的回复:
<prop key="hibernate.hbm2ddl.auto">false</prop>你这配个false算怎么回事呀，要么none，要么update | create | create-drop
@Entity @Table(name = "T_FOOD_NAME") 是这个只需要跟表的名称一样就够了吧,别的东西还需要怎么样去映射的么？
lihao1129 2013-08-06
  • 打赏
  • 举报
 回复
引用 7 楼 fangmingshijie 的回复:
<prop key="hibernate.hbm2ddl.auto">false</prop>你这配个false算怎么回事呀，要么none，要么update | create | create-drop
我改为了update 效果还是一样的...
花谢尊前不敢香 2013-08-06
  • 打赏
  • 举报
 回复
<prop key="hibernate.hbm2ddl.auto">false</prop>你这配个false算怎么回事呀，要么none，要么update | create | create-drop
lihao1129 2013-08-06
  • 打赏
  • 举报
 回复
引用 5 楼 fangmingshijie 的回复:
[quote=引用 4 楼 lihao1129 的回复:] [quote=引用 2 楼 fangmingshijie 的回复:] 没有扫描到注解的东西，在datasourse内加上 <property name="packagesToScan"> <list> <value>com.lh.bdqn.web.*</value> </list> </property>
这句加到 datasourse 的bean内会报错，，， Configuration problem: Failed to import bean definitions from relative location [app-db.xml] 

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
		destroy-method="close">
		<property name="driverClassName">
			<value>oracle.jdbc.driver.OracleDriver</value>
		</property>
		<property name="url">
			<value>${jdbc.url}</value>
		</property>
		<property name="username">
			<value>${jdbc.user}</value>
		</property>
		<property name="password">
			<value>${jdbc.password}</value>
		</property>
		<property name="initialSize">
			<value>${jdbc.initPoolSize}</value>
		</property>
		<property name="maxActive">
			<value>${jdbc.maxPoolSize}</value>
		</property>
		<property name="minIdle">
			<value>2</value>
		</property>
		<property name="packagesToScan">
			<list>
				<value>com.lh.bdqn.web.*</value>
			</list>
		</property>
	</bean>
[/quote]<bean id="sessionFactory"加到这个下面。。。[/quote] 我加到了 sessionFactory 内也是报一样的错误， org.springframework.orm.hibernate3.HibernateQueryException: T_FOOD_NAME is not mapped [FROM T_FOOD_NAME t where t.FOOT_TYPE_ID = 1]; n
花谢尊前不敢香 2013-08-06
  • 打赏
  • 举报
 回复
引用 4 楼 lihao1129 的回复:
[quote=引用 2 楼 fangmingshijie 的回复:] 没有扫描到注解的东西，在datasourse内加上 <property name="packagesToScan"> <list> <value>com.lh.bdqn.web.*</value> </list> </property>
这句加到 datasourse 的bean内会报错，，， Configuration problem: Failed to import bean definitions from relative location [app-db.xml] 

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
		destroy-method="close">
		<property name="driverClassName">
			<value>oracle.jdbc.driver.OracleDriver</value>
		</property>
		<property name="url">
			<value>${jdbc.url}</value>
		</property>
		<property name="username">
			<value>${jdbc.user}</value>
		</property>
		<property name="password">
			<value>${jdbc.password}</value>
		</property>
		<property name="initialSize">
			<value>${jdbc.initPoolSize}</value>
		</property>
		<property name="maxActive">
			<value>${jdbc.maxPoolSize}</value>
		</property>
		<property name="minIdle">
			<value>2</value>
		</property>
		<property name="packagesToScan">
			<list>
				<value>com.lh.bdqn.web.*</value>
			</list>
		</property>
	</bean>
[/quote]<bean id="sessionFactory"加到这个下面。。。
lihao1129 2013-08-06
  • 打赏
  • 举报
 回复
引用 2 楼 fangmingshijie 的回复:
没有扫描到注解的东西，在datasourse内加上 <property name="packagesToScan"> <list> <value>com.lh.bdqn.web.*</value> </list> </property>
这句加到 datasourse 的bean内会报错，，， Configuration problem: Failed to import bean definitions from relative location [app-db.xml] 

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
		destroy-method="close">
		<property name="driverClassName">
			<value>oracle.jdbc.driver.OracleDriver</value>
		</property>
		<property name="url">
			<value>${jdbc.url}</value>
		</property>
		<property name="username">
			<value>${jdbc.user}</value>
		</property>
		<property name="password">
			<value>${jdbc.password}</value>
		</property>
		<property name="initialSize">
			<value>${jdbc.initPoolSize}</value>
		</property>
		<property name="maxActive">
			<value>${jdbc.maxPoolSize}</value>
		</property>
		<property name="minIdle">
			<value>2</value>
		</property>
		<property name="packagesToScan">
			<list>
				<value>com.lh.bdqn.web.*</value>
			</list>
		</property>
	</bean>
lihao1129 2013-08-06
  • 打赏
  • 举报
 回复
引用 2 楼 fangmingshijie 的回复:
没有扫描到注解的东西，在datasourse内加上 <property name="packagesToScan"> <list> <value>com.lh.bdqn.web.*</value> </list> </property>
<!-- 数据库配置 事务stat-->
	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"
		lazy-init="false">
		<property name="dataSource">
			<ref bean="dataSource" />
		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.show_sql">false</prop>
				<prop key="hibernate.format_sql">true</prop>
				<prop key="hibernate.use_sql_comments">true</prop>
				<prop key="hibernate.generate_statistics">false</prop>
				<prop key="hibernate.hbm2ddl.auto">false</prop>
				<prop key="hibernate.dialect"> org.hibernate.dialect.Oracle9Dialect </prop>
			</props>
		</property>
		<property name="packagesToScan">
			<list>
				<value>com.lh.bdqn.web.*</value>
			</list>
		</property>
		<!--<property name="mappingDirectoryLocations">
			property name="mappingLocations"

				<list>
					<value>WEB-INF/mappings</value>
					<value>classpath:/com/lh/bdqn/web/vo/FoodModel</value>
				</list>
			</property>-->
	</bean>
我加成了这样，还是报一样的错误。。。。
花谢尊前不敢香 2013-08-06
  • 打赏
  • 举报
 回复
没有扫描到注解的东西，在datasourse内加上 <property name="packagesToScan"> <list> <value>com.lh.bdqn.web.*</value> </list> </property>
lihao1129 2013-08-06
  • 打赏
  • 举报
 回复 
@SuppressWarnings("all")
	@Override
	public List queryFoodById(String id) {
		List<FoodNameModel> list = new ArrayList<FoodNameModel>();
		try {
			
			String hql = "FROM T_FOOD_NAME t where t.FOOT_TYPE_ID = "+id;
			list = ibasedao.query(hql);
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
		return list;
	}
执行HQL的时候报错，说是没有映射到实体类的modle，但是我已经有了@Table(name = "T_FOOD_NAME")，是xml还需要配置<mapping class = "com/lh/bdqn/web/vo/FoodNameModel"/>吗？ 但是我加上好像总是不行
映射 is not mapped的问题
报了这个错 映射 is not mapped的问题  大小写也改过了 还是不行 原来是实体类  没有映射注解 这亏吃爆！添上之后 走起
Hibernate出现表名is not mapped问题
排查这三点，完美解决Hibernate出现表名is not mapped问题。
hibernate 出现 is not mapped 问题
在用hibernate框架时，  运行时报org.hibernate.hql.ast.QuerySyntaxException:tab_user is not mapped [select u.username from tab_user u where u.username=? and and password=?] 错误：  上面的错误是因为自己写了错误的HQL语句：       Str
解决Hibernate使用HQL查询出现is not mapped问题
环境：Hibernate 5.1.0.Final，IntelliJ IDEA 2016.2.2 检查实体Bean配置一切正常，检查映射配置文件和hibernate.cfg.xml配置文件也是正常的。 通过百度搜索都说是HQL查询根据的是实体名而不是表名查找的，那个我也是对的，实在想不通会出现is not mapped问题。异常信息如下：Exception in thread "main" org
flask 错误 'Class 'XXX' is not mapped'（类没有映射）
flask 错误 ‘Class ‘XXX’ is not mapped’（类没有映射） 首先这个错误是指：该类没有被映射到，或者说是没有被绑定 错误代码： #这一行是通过一个主键ID查到对应的所有的明细行 track_details = Track_Details.query.filter_by(track_id=params.get("id")).all() #这一行是把所有的明细行拿过来进行删...
Java EE

67,513

社区成员

225,878

社区内容

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器，保护我们的业务核心组件（中间件），以延续它的生命力，而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章