HQL 异常 org.hibernate.ObjectNotFoundExcep No row with the given identifier exists

0 0

HQL 异常 org.hibernate.ObjectNotFoundExcep No row with the given identifier exists5

程序查询出错，中文外键hql执行错误的问题No row with the given identifier exists: [com.ly.dao.Role#教师]，如果把role表中教师修改为英文字符，可以正常运行。
表结构：
--------
红色的就是中文外键，如果换成英文就没有问题

user表
user_name           姓名
0000000100001       孙幸

user_role表
user_name          role_name
0000000100001      教师

role表
role_name          role_type
教师         教师

问题补充：package com.ly.dao;

/**
* UserRole entity. @author MyEclipse Persistence Tools
*/

public class UserRole implements java.io.Serializable {

// Fields

private UserRoleId id;
private Role role;
private User user;

// Constructors

/** default constructor */
public UserRole() {
}

/** full constructor */
public UserRole(UserRoleId id, Role role, User user) {
this.id = id;
this.role = role;
this.user = user;
}

// Property accessors

public UserRoleId getId() {
return this.id;
}

public void setId(UserRoleId id) {
this.id = id;
}

public Role getRole() {
return this.role;
}

public void setRole(Role role) {
this.role = role;
}

public User getUser() {
return this.user;
}

public void setUser(User user) {
this.user = user;
}

}

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

<hibernate-mapping>
    <class name="com.ly.dao.UserRole" table="user_role" catalog="essaywriting">
        <composite-id name="id" class="com.ly.dao.UserRoleId">
            <key-property name="userName" type="java.lang.String">
                <column name="user_name" length="30" />
            </key-property>
            <key-property name="roleName" type="java.lang.String">
                <column name="role_name" length="30" />
            </key-property>
        </composite-id>
        <many-to-one name="role" class="com.ly.dao.Role" update="false" insert="false" fetch="select" lazy="false">
            <column name="role_name" length="30" not-null="true" />
        </many-to-one>
        <many-to-one name="user" class="com.ly.dao.User" update="false" insert="false" fetch="select" lazy="false">
            <column name="user_name" length="30" not-null="true" />
        </many-to-one>
    </class>
</hibernate-mapping>

问题补充：查询程序：
List<UserRole> roleList= (List<UserRole>)userRoleDao.findByProperty("user.userName", user.getUserName());
----
public List findByProperty(String propertyName, Object value) {
log.debug("finding UserRole instance with property: " + propertyName
+ ", value: " + value);
try {
String queryString = "from UserRole as model where model."
+ propertyName + "= ?";
return getHibernateTemplate().find(queryString, value);
} catch (RuntimeException re) {
log.error("find by property name failed", re);
throw re;
}
}

问题补充：有问题的数据库是我从服务器上备份恢复到本地测试机上的，
同一个程序，连原来服务器上的数据库正常，连从服务器上复制来数据库的本地服务器出现这个错误。

问题补充：问题已经解决，hql很弱智，mysql很坑爹。