HIBERNATE 3 .0 查询select 视图(含有虚拟列)后自动 update 如何禁止

teameuro 2008-07-31 11:51:55

环境:
开发环境:Eclipse 3.3.2 MyEclipse 6.0(可能为:Struts 1.2 Spring 2.0 Hibernate 3.0)
WEB服务器:Tomcat 6.0
数据库:Oracle 10g
开发框架:SSH

问题:
1.在数据库建有一张含有虚拟列的视图用于只读查询
select a.METER_GUID,a.CHANGE_NO,a.CUSTOMER_ID,a.CUSTOMER_NAME,a.METER_ID,a.METER_NO,a.BUY_DATE,a.BUY_MONEY,a.AVG_PRICE,a.BUY_ENERGY,
--虚拟列--
(case nvl(a.CLEAR_FLAG,'0')
when '1' then '销帐'
else (case nvl(a.MAKE_CARD_FLAG,'0')
when '2' then '无效'
else '正常'
end)
end) NUM_STATUS_REMARK,

2.Hibernate映射此视图,采用和表一样的映射方式
VStatisticsBuyDetails.hbm.xml
<hibernate-mapping>
<class name="com.wasion.statistics.model.VStatisticsBuyDetails" table="V_STATISTICS_BUY_DETAILS" schema="WASION" >
<composite-id>
<key-property name="meterGuid" type="java.lang.String">
<column name="METER_GUID" length="40" />
</key-property>
<key-property name="buyDate" type="java.util.Date">
<column name="BUY_DATE" length="7" />
</key-property>
</composite-id>
--虚拟列--
<property name="numStatusRemark" type="java.lang.String">
<column name="NUM_STATUS_REMARK" length="4" />
</property>
<property name=" .....

VStatisticsBuyDetails.java
public class VStatisticsBuyDetails implements java.io.Serializable {
private Long customerId;
--虚拟列--
private String numStatusRemark;
private Long changeNo;
private String custGuid;
private String customerNo;
private String customerName;
...

3.在DAOImpl中进行查询,可以返回正常的List
DAOImpl.java
public List getStatisticsBuyDetailsList() {
String queryString;
List list;
try {
queryString = "from VStatisticsBuyDetails ";
list = getHibernateTemplate().find(queryString);
} catch (RuntimeException re) {
throw re;
}
--通过调试变量窗口可以看到已经取到了4个VStatisticsBuyDetails对象--
return list;
}

控制台窗口输出:
Hibernate: select vstatistic0_.METER_GUID as METER1_, vstatistic0_.CHANGE_NO as CHANGE2_, vstatistic0_.METER_ID as METER3_,....

4.在返回到Action的代码前时出现异常:
//在此处调用service 通过service调用DAO
List dataList = service.getStatisticsBuyDetailsList();
//在返回此处前出现异常
String sDataTable = tbService.createDataTable(headArr, bodyArr, dataList);

控制台窗口输出:
Hibernate: update WASION.V_STATISTICS_BUY_DETAILS set NUM_STATUS_REMARK=?, CUSTOMER_NO=?, CUSTOMER_NAME=?, ...
Hibernate: update WASION.V_STATISTICS_BUY_DETAILS set NUM_STATUS_REMARK=?, CUSTOMER_NO=?, CUSTOMER_NAME=?, ...
Hibernate: update WASION.V_STATISTICS_BUY_DETAILS set NUM_STATUS_REMARK=?, CUSTOMER_NO=?, CUSTOMER_NAME=?, ...
Hibernate: update WASION.V_STATISTICS_BUY_DETAILS set NUM_STATUS_REMARK=?, CUSTOMER_NO=?, CUSTOMER_NAME=?, ...
2008-07-31 11:44:45,625 WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 1733, SQLState: 42000
2008-07-31 11:44:45,625 ERROR [org.hibernate.util.JDBCExceptionReporter] - ORA-01733: 此处不允许虚拟列

在Hibernate输出调试信息中select语句之后,自动出现了4条(List中返回了4个POJO)update语句,异常抛出在spring或hibernate内部

如何解决?请各位大虾米明示!
1.在slect后我没有更新任何pojo为什么会自动update?
2.请不要建议我去掉视图中虚拟列,否则我就不用提问了!
3.如何使hibernate支持虚拟列?
4.如何在hibernate中设定视图为只读方式?

...全文

1290 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

fosjos 2008-07-31

打赏
举报

[Quote=引用 2 楼 Landor2004 的回复:]
String sDataTable = tbService.createDataTable(headArr, bodyArr, dataList); 这个函数是怎么写的
[/Quote]
pojo不可能自动更新，其他的问题也不存在
hibernate只要你配置view和table一样就可以了，框架本身并无识别能力

Landor2004 2008-07-31

打赏
举报

String sDataTable = tbService.createDataTable(headArr, bodyArr, dataList); 这个函数是怎么写的

qlrhoo 2008-07-31

打赏
举报

formula 进行模型转换
有两个 formula 应用场景：
1. formula 用于评估结果的场合。在 discriminator、element、map-key、map-key-many-to-many以及 property 元素中注入 formula。
2. formula 用于连接目的的场合。在 many-to-one、one-to-one 以及 many-to-many 元素中注入 formula。

teameuro 2008-07-31

打赏
举报

虽无满意帖子,但是散分啦

teameuro 2008-07-31

打赏
举报

问题已解决:
但还是不知道理由...
谢谢各位关注,努力中

在第二步中在hbm中只需要将虚拟列的映射改为:
<property name="numStatusRemark" formula="NUM_STATUS_REMARK"/>

2.Hibernate映射此视图,采用和表一样的映射方式
VStatisticsBuyDetails.hbm.xml
<hibernate-mapping>
<class name="com.wasion.statistics.model.VStatisticsBuyDetails" table="V_STATISTICS_BUY_DETAILS" schema="WASION" >
<composite-id>
<key-property name="meterGuid" type="java.lang.String">
<column name="METER_GUID" length="40" />
</key-property>
<key-property name="buyDate" type="java.util.Date">
<column name="BUY_DATE" length="7" />
</key-property>
</composite-id>

<property name="numStatusRemark" formula="NUM_STATUS_REMARK"/>

弃用了struts，用spring mvc框架做了几个项目，感觉都不错，而且使用了注解方式，可以省掉一大堆配置文件。本文主要介绍使用注解方式配置的spring mvc，之前写的spring3.0 mvc和rest小例子没有介绍到数据层的内容，现在这一篇补上。下面开始贴代码。文中用的框架版本：spring 3,hibernate 3,没有的，自己上网下。先说web.xml配置： [java] view plaincopy 01.<?xml version="1.0" encoding="UTF-8"?> 02. 03. s3h3 04. 05. contextConfigLocation 06. classpath:applicationContext*.xml 07. 08. 09. org.springframework.web.context.ContextLoaderListener 10. 11. 12. 13. spring 14. org.springframework.web.servlet.DispatcherServlet 15. 1 16. 17. 18. spring  19. *.do 20. 21. 22. index.jsp 23. 24. spring-servlet,主要配置controller的信息 [java] view plaincopy 01.<?xml version="1.0" encoding="UTF-8"?> 02. 09. 10. 11.  12. 13.  14. 15. 16.  17. 19. 20. 23. applicationContext.xml代码 [java] view plaincopy 01.<?xml version="1.0" encoding="UTF-8"?> 02. 11. 12. 13.  14. 15. 16. 17. 19. 20. 21. 22. ${dataSource.dialect} 23. ${dataSource.hbm2ddl.auto} 24. update 25. 26. 27. 28. 29. com.mvc.entity 30. 31. 32. 33. 34. 36. 37. 38. 39. 40. 42. 43. 44. 45. 46. 47.  48. 49. 50. 51. 52. 53. 54. 55. hibernate.properties数据库连接配置 [java] view plaincopy 01.dataSource.password=123 02.dataSource.username=root 03.dataSource.databaseName=test 04.dataSource.driverClassName=com.mysql.jdbc.Driver 05.dataSource.dialect=org.hibernate.dialect.MySQL5Dialect 06.dataSource.serverName=localhost:3306 07.dataSource.url=jdbc:mysql://localhost:3306/test 08.dataSource.properties=user=${dataSource.username};databaseName=${dataSource.databaseName};serverName=${dataSource.serverName};password=${dataSource.password} 09.dataSource.hbm2ddl.auto=update 配置已经完成，下面开始例子先在数据库建表，例子用的是mysql数据库 [java] view plaincopy 01.CREATE TABLE `test`.`student` ( 02. `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 03. `name` varchar(45) NOT NULL, 04. `psw` varchar(45) NOT NULL, 05. PRIMARY KEY (`id`) 06.) 建好表后，生成实体类 [java] view plaincopy 01.package com.mvc.entity; 02. 03.import java.io.Serializable; 04. 05.import javax.persistence.Basic; 06.import javax.persistence.Column; 07.import javax.persistence.Entity; 08.import javax.persistence.GeneratedValue; 09.import javax.persistence.GenerationType; 10.import javax.persistence.Id; 11.import javax.persistence.Table; 12. 13.@Entity 14.@Table(name = "student") 15.public class Student implements Serializable { 16. private static final long serialVersionUID = 1L; 17. @Id 18. @Basic(optional = false) 19. @GeneratedValue(strategy = GenerationType.IDENTITY) 20. @Column(name = "id", nullable = false) 21. private Integer id; 22. @Column(name = "name") 23. private String user; 24. @Column(name = "psw") 25. private String psw; 26. public Integer getId() { 27. return id; 28. } 29. public void setId(Integer id) { 30. this.id = id; 31. } 32. 33. public String getUser() { 34. return user; 35. } 36. public void setUser(String user) { 37. this.user = user; 38. } 39. public String getPsw() { 40. return psw; 41. } 42. public void setPsw(String psw) { 43. this.psw = psw; 44. } 45.} Dao层实现 [java] view plaincopy 01.package com.mvc.dao; 02. 03.import java.util.List; 04. 05.public interface EntityDao { 06. public List<Object> createQuery(final String queryString); 07. public Object save(final Object model); 08. public void update(final Object model); 09. public void delete(final Object model); 10.} [java] view plaincopy 01.package com.mvc.dao; 02. 03.import java.util.List; 04. 05.import org.hibernate.Query; 06.import org.springframework.orm.hibernate3.HibernateCallback; 07.import org.springframework.orm.hibernate3.support.HibernateDaoSupport; 08. 09.public class EntityDaoImpl extends HibernateDaoSupport implements EntityDao{ 10. public List<Object> createQuery(final String queryString) { 11. return (List<Object>) getHibernateTemplate().execute( 12. new HibernateCallback<Object>() { 13. public Object doInHibernate(org.hibernate.Session session) 14. throws org.hibernate.HibernateException { 15. Query query = session.createQuery(queryString); 16. List<Object> rows = query.list(); 17. return rows; 18. } 19. }); 20. } 21. public Object save(final Object model) { 22. return getHibernateTemplate().execute( 23. new HibernateCallback<Object>() { 24. public Object doInHibernate(org.hibernate.Session session) 25. throws org.hibernate.HibernateException { 26. session.save(model); 27. return null; 28. } 29. }); 30. } 31. public void update(final Object model) { 32. getHibernateTemplate().execute(new HibernateCallback<Object>() { 33. public Object doInHibernate(org.hibernate.Session session) 34. throws org.hibernate.HibernateException { 35. session.update(model); 36. return null; 37. } 38. }); 39. } 40. public void delete(final Object model) { 41. getHibernateTemplate().execute(new HibernateCallback<Object>() { 42. public Object doInHibernate(org.hibernate.Session session) 43. throws org.hibernate.HibernateException { 44. session.delete(model); 45. return null; 46. } 47. }); 48. } 49.} Dao在applicationContext.xml注入 Dao只有一个类的实现，直接供其它service层调用，如果你想更换为其它的Dao实现，也只需修改这里的配置就行了。开始写view页面，WEB-INF/view下新建页面student.jsp，WEB-INF/view这路径是在spring-servlet.xml文件配置的，你可以配置成其它，也可以多个路径。student.jsp代码 [xhtml] view plaincopy 01.<%@ page language="java" contentType="text/html; charset=UTF-8" 02. pageEncoding="UTF-8"%> 03.<%@ include file="/include/head.jsp"%> 04. 05.<html> 06.<head> 07.<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> 08.<title>添加</title> 09. 11.// --><style mce_bogus="1">table{ border-collapse:collapse; } 16.td{ border:1px solid #f00; }</style> 17. 47. 48. 序号 49. 姓名 50. 密码 51. 操作 52. 53. 54. "> 55. 56. 57. 58. 59. <input type="button" value="编辑"/> 60. <input type="button" value="${student.id}"/>')" value="删除"/> 61. 62. 63. 64. 65. 66.</body> 67.</html> student_add.jsp [xhtml] view plaincopy 01.<%@ page language="java" contentType="text/html; charset=UTF-8" 02. pageEncoding="UTF-8"%> 03.<%@ include file="/include/head.jsp"%> 04. 05.<html> 06.<head> 07.<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> 08.<title>学生添加</title> 09. 17.

18. 19. 20. 21. 22.

姓名	<input id="user" name="user" type="text" /></td>
密码	<input id="psw" name="psw" type="text" /></td>
<input type="submit" value="提交"/><input type="button" value="返回" />