一个一对多双向自身关联的异常，求大家帮忙解答一下，非常感谢！！！

mysql> select * from t_orgnization;
+----+------+------+-------------+------+
| id | name | sn | description | pid |
+----+------+------+-------------+------+
| 1 | org1 | NULL | NULL | NULL |
| 2 | org4 | NULL | NULL | 1 |
| 3 | org3 | NULL | NULL | 1 |
| 4 | org2 | NULL | NULL | 1 |
+----+------+------+-------------+------+
4 rows in set (0.00 sec)
这里是向数据表中添加一个父机构和3个子机构，这种情况没问题。
mysql> select * from t_orgnization;
+----+------+------+-------------+------+
| id | name | sn | description | pid |
+----+------+------+-------------+------+
| 1 | org1 | NULL | NULL | NULL |
| 2 | org4 | NULL | NULL | 1 |
| 3 | org3 | NULL | NULL | 1 |
| 4 | org2 | NULL | NULL | 1 |
| 5 | org1 | NULL | NULL | NULL |
| 6 | org4 | NULL | NULL | 5 |
| 7 | org3 | NULL | NULL | 5 |
| 8 | org2 | NULL | NULL | 5 |
+----+------+------+-------------+------+
这里是向数据表中添加两个父机构及其子机构，这种情况，异常为：

HTTP Status 500 -

[b]问题补充：[/b]
mysql> select * from t_orgnization;
+----+------+------+-------------+------+
| id | name | sn | description | pid |
+----+------+------+-------------+------+
| 1 | org1 | NULL | NULL | NULL |
| 2 | org4 | NULL | NULL | 1 |
| 3 | org3 | NULL | NULL | 1 |
| 4 | org2 | NULL | NULL | 1 |
+----+------+------+-------------+------+
4 rows in set (0.00 sec)
这里是向数据表中添加一个父机构和3个子机构，这种情况没问题。
mysql> select * from t_orgnization;
+----+------+------+-------------+------+
| id | name | sn | description | pid |
+----+------+------+-------------+------+
| 1 | org1 | NULL | NULL | NULL |
| 2 | org4 | NULL | NULL | 1 |
| 3 | org3 | NULL | NULL | 1 |
| 4 | org2 | NULL | NULL | 1 |
| 5 | org1 | NULL | NULL | NULL |
| 6 | org4 | NULL | NULL | 5 |
| 7 | org3 | NULL | NULL | 5 |
| 8 | org2 | NULL | NULL | 5 |
+----+------+------+-------------+------+
这里是向数据表中添加两个父机构及其子机构，这种情况，异常为：

HTTP Status 500 -

type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /org/index.jsp at line 105
102: ${org.sn }
103: </td>
104: <td align="center" vAlign="center">
105: ${org.parent.name}
106: </td>
107: <td align="center" vAlign="center">
108: <a href="#"
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:435)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:78)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)
root cause
javax.el.ELException: Error reading 'name' on type com.oa.model.Orgnization$$EnhancerByCGLIB$$ec9313ca
javax.el.BeanELResolver.getValue(BeanELResolver.java:66)
javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
org.apache.el.parser.AstValue.getValue(AstValue.java:97)
org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:923)
org.apache.jsp.org.index_jsp._jspx_meth_c_005fforEach_005f0(index_jsp.java:274)
org.apache.jsp.org.index_jsp._jspx_meth_c_005fif_005f0(index_jsp.java:218)
org.apache.jsp.org.index_jsp._jspService(index_jsp.java:165)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:78)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)
root cause
org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.oa.model.Orgnization#0]
org.hibernate.impl.SessionFactoryImpl$1.handleEntityNotFound(SessionFactoryImpl.java:375)
org.hibernate.proxy.AbstractLazyInitializer.checkTargetState(AbstractLazyInitializer.java:79)
org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:68)
org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:111)
org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.invoke(CGLIBLazyInitializer.java:172)
com.oa.model.Orgnization$$EnhancerByCGLIB$$ec9313ca.getName(<generated>)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
javax.el.BeanELResolver.getValue(BeanELResolver.java:62)
javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
org.apache.el.parser.AstValue.getValue(AstValue.java:97)
org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:923)
org.apache.jsp.org.index_jsp._jspx_meth_c_005fforEach_005f0(index_jsp.java:274)
org.apache.jsp.org.index_jsp._jspx_meth_c_005fif_005f0(index_jsp.java:218)
org.apache.jsp.org.index_jsp._jspService(index_jsp.java:165)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:78)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.14 logs.

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

name="com.cenc.infopublish.model.Organization">

HTTP Status 500 -

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
<class table="T_Organization"
name="com.cenc.infopublish.model.Organization">
<id name="id">
<generator class="native" />
</id>
<property name="name" />
<property name="sn" />
<property name="description" />
<many-to-one column="pid" name="parent" />
<set lazy="false" inverse="true" name="children">
<key column="pid" />
<one-to-many class="com.cenc.infopublish.model.Organization" />
</set>
</class>
</hibernate-mapping>

[b]问题补充：[/b]
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

name="com.cenc.infopublish.model.Organization">

[b]问题补充：[/b]

试过了，这种方式还是行不通！！
[b]问题补充：[/b]
package com.cenc.infopublish.model;

import java.util.Set;

/**

@author Administrator
*/
public class Organization {

private Integer id;

private String name;

private String sn;

private String description;

private Organization parent;

private Set children;

public Set getChildren() {
return children;
}

public void setChildren(Set children) {
this.children = children;
}

public String getDescription() {
return description;
}

public void setDescription(String description) {
this.description = description;
}

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 Organization getParent() {
return parent;
}

public void setParent(Organization parent) {
this.parent = parent;
}

public String getSn() {
return sn;
}

public void setSn(String sn) {
this.sn = sn;
}

@Override
public String toString() {
return "id=" + id;
}

}

[b]问题补充：[/b]
action:

public class OrgAction extends BaseAction {

private OrgManager orgManager;

/**
 * 打开机构管理主界面
 */
@Override
protected ActionForward unspecified(ActionMapping mapping, ActionForm form,
        HttpServletRequest request, HttpServletResponse response)
        throws Exception {

    OrgActionForm oaf = (OrgActionForm) form;

    request.setAttribute("pm", orgManager.findOrgs(oaf.getParentId()));

    PagerModel pm = orgManager.findOrgs(oaf.getParentId());

    int ppid = 0;
    if (oaf.getParentId() != 0) {
        Organization org = orgManager.findOrg(oaf.getParentId());
        Organization parent = org.getParent();
        if (parent != null) {
            ppid = parent.getId();
        }
    }

    request.setAttribute("ppid", ppid);

    if (oaf.isSelect()) {
        return mapping.findForward("select");
    }

    return mapping.findForward("index");
}

}

public class OrgManagerImpl extends AbstractManager implements OrgManager {
public PagerModel findOrgs(int parentId) {

    // 如果parentId＝0，则查找顶级机构列表
    if (parentId == 0) {
        return searchPaginated("from Organization o where o.parent is null");
    }
    return searchPaginated("from Organization o where o.parent.id = ?",
            parentId);
}

}

public class AbstractManager extends HibernateDaoSupport {
public PagerModel searchPaginated(String hql){
return searchPaginated(hql,null,SystemContext.getOffset(),SystemContext.getPagesize());

public PagerModel searchPaginated(String hql,Object[] params,int offset,int pagesize){

    //获取记录总数
    String countHql = getCountQuery(hql);
    Query query = getSession().createQuery(countHql);
    if(params != null && params.length > 0){
        for(int i=0; i<params.length; i++){
            query.setParameter(i, params[i]);
        }
    }
    int total = ((Long)query.uniqueResult()).intValue();

    //获取当前页的结果集
    query = getSession().createQuery(hql);
    if(params != null && params.length > 0){
        for(int i=0; i<params.length; i++){
            query.setParameter(i, params[i]);
        }
    }

    query.setFirstResult(offset);
    query.setMaxResults(pagesize);
    List datas = query.list();

    PagerModel pm = new PagerModel();
    pm.setTotal(total);
    pm.setDatas(datas);
    return pm;
}

/**
 * 根据HQL语句，获得查找总记录数的HQL语句
 * 如：
 * select ... from Orgnization o where o.parent is null
 * 经过转换，可以得到：
 * select count(*) from Orgnization o where o.parent is null
 * @param hql
 * @return
 */
private String getCountQuery(String hql){
    int index = hql.indexOf("from");
    if(index != -1){
        return "select count(*) " + hql.substring(index);
    }

    throw new SystemException("无效的HQL查询语句！");
}

}
}

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

4条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
「已注销」 2008-11-22 18:07
关注
${org.parent.name}

怎么没看到页面是如何去到org对象的

本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

查看更多回答(3条)

报告相同问题？

关注问题

一个一对多双向自身关联的异常，求大家帮忙解答一下，非常感谢！！！ hibernate
2008-11-22 00:01

回答 4 已采纳 ${org.parent.name} 怎么没看到页面是如何去到org对象的
Hibernate框架如何处理双向多对多且有附加属性的关联? hibernate java mysql
2017-06-22 07:01

回答 1 已采纳很简单啊，Student one to many SelctCourse,Course 也是one to many SelectCourse。他们都是一对多SelectCourse就行了
一对多双向关联，级联删除，sql语句优化问题 hibernate
2008-12-03 22:50

回答 1 已采纳不知道具体您的数据量有多少? 系统的优化需要考虑很多方面,虽然采用类似in (...)来处理，就着一次执行来说，性能有一定的提高。但如果DB是Oracle(其他DB也应该类似)，delete f
Java的Hibernate框架中一对多的单向和双向关联映射
2020-09-02 03:33

建立对SQL语句的映射是Hibernate框架操作数据库的主要手段,这里我们列举实例来为大家讲解Java的Hibernate框架中一对多的单向和双向关联映射
Hibernate 双向多对多关联的问题，更新一主表字段，关联表就会删除该记录在关联表中的对应 hibernate
2012-06-21 12:13

回答 4 已采纳把XML 里的级联关系去掉呢？？
hibernate一对多关联list无法更新 hibernate
2010-04-20 10:14

回答 5 已采纳 [code="java"] public class Item3 { @Id @GeneratedValue(strategy = GenerationType.AU
hibernate 一对多 自动建表语句生成两个外键列 hibernate
2012-09-30 03:57

回答 1 已采纳 1、确认下log不是配置重复，造成打印两次； 2、配置inverse="true"试试，表示关系维护由另一端维护即多端
Hibernate ORM - 一对多双向关联关系
2019-03-28 01:10

NULL 博文链接：https://dreamzhong.iteye.com/blog/1200915
Hibernate多对多集合对象关联查询的问题 hibernate
2009-08-14 10:00

回答 4 已采纳 select p.groups from Person p where p.name=?
one to mang 延迟加载问题! hibernate
2010-01-25 12:01

回答 3 已采纳你把[quote]syso.out.println(sc.getStudentses()); [/quote][quote]if(Hibernate.isInitialized(stuClass.ge
hibernate 关联保存的困惑 hibernate
2009-10-14 17:55

回答 3 已采纳如果使用单向关联，或者不使用Hibernate二级缓存、且同一个一级缓存中进行增加后不再进行查询操作，就没必要了。
JPA 一对多单向关联和双向关联（没有外键的情况）
2019-09-25 19:37

夜风_BLOG的博客假设我有两个表，一个机构表A，一个机构详情表B，表A为主表...1jpa一对多单向关联的设置 class A{ /** * A表id */ @Id @GeneratedValue @Column(name = "a_id") private Long aId; /** * B集合 */ @OneTo...
hibernate 延迟加载异常（无法获取lazy对象） hibernate
2010-03-24 10:38

回答 18 已采纳 select h.xx,p.xx from Hospitalization as h left join fetch h.patient p where h.code=?1 p.xx是patient
SSH一对多（两表双向关联查询）
2012-01-17 15:24

SSH一对多（两表双向关联查询：person表、organisation‘组织'表）数据库：Mysql 里面有现成的测试方法，直接在java中就可以看到效果
Hibernate中的双向多对一关联以及 inverse属性、cascade属性的用法
2016-05-19 15:51

葡萄干是个程序员的博客上回说了 Hibernate中的单向一对多关联和 Hibernate中的单向多对一关联。这次针对这两个“单向”进行整合即可实现双向的多对一关联。如：学生与班级的关系。在Grade类中需要添加 Set集合保存Student对象，并且...
没有解决我的问题, 去提问

悬赏问题

¥60 版本过低apk如何修改可以兼容新的安卓系统
¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
¥50 有数据，怎么建立模型求影响全要素生产率的因素
¥50 有数据，怎么用matlab求全要素生产率
¥15 TI的insta-spin例程
¥15 完成下列问题完成下列问题
¥15 C#算法问题, 不知道怎么处理这个数据的转换
¥15 YoloV5 第三方库的版本对照问题
¥15 请完成下列相关问题！
¥15 drone 推送镜像时候 purge: true 推送完毕后没有删除对应的镜像,手动拷贝到服务器执行结果正确在样才能让指令自动执行成功删除对应镜像，如何解决？

一个一对多双向自身关联的异常，求大家帮忙解答一下，非常感谢！！！

HTTP Status 500 -

HTTP Status 500 -

HTTP Status 500 -

4条回答 默认 最新

悬赏问题

4条回答默认最新