hibernate 问题 100

Question

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not 
re-read row data for column 5.数据库异常。检查一下你删除的数据是否有外键关联什么的

Answer 1

没有关联呀！
关系是 many-to-one

Answer 2

,+***+,                                     
    ,*********,  ,               ,@@,             
   .****+++****,*:               ,WW.             
  ,***:.,,,.+****+               ,WW.             
  ***.,     ,:***+               ,WW.             
 .**:        ****+               ,WW.             
 +*+,       ,.+++. :@@*,     +@@:,WW.*@*.#@:      
 **:         ,,,,,WWWWWW:  ,WWWWWWWW.#WWWWWWW,+++,
,**:             @WW@*WW.  WWW**WWWW.#WWW#*WW* :: 
,**:             WWW*,.., #WW:,,.@WW.#WW+.,+WW,. .
 +*+,            .WWWW+,  WW+,   .WW.#W@.  .WW,+# 
 .**,            ,:WWWWW:,WW:    ,WW.#W@,  .WW,@@,
 ,***,       .,   ,.:#WWW.WW*,   .WW.#W#,  .WW.#+,
  .***,     +**,  +,,,WWW:+WW.   WWW.#W#,  .WW.  ,
  ,.*****+*****.  WWWWWWW.,WWWWWWWWW.#W#,  .WW,**,
   ,.********+., :WWWWWW+, .@WWWW@WW.#W#,  .WW,** 
     ,.+++++:,   ,.:++:.,   ,:++:.++..++,  ,++,,, 
       ,,,,,       ,,,,       ,,, ,,,,,,    ,,    
用http://bbs.soulsky.net/pub/ascii/做的。

Answer 3

以下是com.cy81.entity.CysysTrUserPowerSet.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" ><hibernate-mapping>
<class
    name="com.cy81.entity.CysysTrUserPowerSet"
    table="CYSYS_TR_UserPowerSet"
>    <id
        name="PowerSetFlowId"
        type="java.lang.Integer"
        column="PowerSetFlowId"
    >
        <generator class="native" />
    </id>
<many-to-one
        name="cysysTrUserOperation"
        class="com.cy81.entity.CysysTrUserOperation"
        not-null="true"
    >
        <column name="UserOptFlowId" />
    </many-to-one>
<many-to-one
        name="cysysTbSystemHandleSet"
        class="com.cy81.entity.CysysTbSystemHandleSet"
        not-null="true"
    >
        <column name="HandleCode" />
    </many-to-one></class>
</hibernate-mapping>

Answer 4

以下是com.cy81.entity.CysysTrUserPowerSet.javapackage com.cy81.entity;import java.io.Serializable;
import org.apache.commons.lang.builder.EqualsBuilder;
import org.apache.commons.lang.builder.HashCodeBuilder;
import org.apache.commons.lang.builder.ToStringBuilder;
public class CysysTrUserPowerSet implements Serializable {    private Integer powerSetFlowId;    private com.cy81.entity.CysysTrUserOperation cysysTrUserOperation;    private com.cy81.entity.CysysTbSystemHandleSet cysysTbSystemHandleSet;    public CysysTrUserPowerSet(Integer powerSetFlowId, com.cy81.entity.CysysTrUserOperation cysysTrUserOperation, com.cy81.entity.CysysTbSystemHandleSet cysysTbSystemHandleSet) {
        this.powerSetFlowId = powerSetFlowId;
        this.cysysTrUserOperation = cysysTrUserOperation;
        this.cysysTbSystemHandleSet = cysysTbSystemHandleSet;
    }    public CysysTrUserPowerSet() {
    }    public Integer getPowerSetFlowId() {
        return this.powerSetFlowId;
    }    public void setPowerSetFlowId(Integer powerSetFlowId) {
        this.powerSetFlowId = powerSetFlowId;
    }    public com.cy81.entity.CysysTrUserOperation getCysysTrUserOperation() {
        return this.cysysTrUserOperation;
    }    public void setCysysTrUserOperation(com.cy81.entity.CysysTrUserOperation cysysTrUserOperation) {
        this.cysysTrUserOperation = cysysTrUserOperation;
    }    public com.cy81.entity.CysysTbSystemHandleSet getCysysTbSystemHandleSet() {
        return this.cysysTbSystemHandleSet;
    }    public void setCysysTbSystemHandleSet(com.cy81.entity.CysysTbSystemHandleSet cysysTbSystemHandleSet) {
        this.cysysTbSystemHandleSet = cysysTbSystemHandleSet;
    }    public String toString() {
        return new ToStringBuilder(this)
            .append("powerSetFlowId", getPowerSetFlowId())
            .toString();
    }    public boolean equals(Object other) {
        if ( !(other instanceof CysysTrUserPowerSet) ) return false;
        CysysTrUserPowerSet castOther = (CysysTrUserPowerSet) other;
        return new EqualsBuilder()
            .append(this.getPowerSetFlowId(), castOther.getPowerSetFlowId())
            .isEquals();
    }    public int hashCode() {
        return new HashCodeBuilder()
            .append(getPowerSetFlowId())
            .toHashCode();
    }}

Answer 5

我在用
session.delete("from com.cy81.entity.CysysTrUserPowerSet");
出现异常
请教怎么解决
急

Answer 6

对应的com.cy81.entity.CysysTrUserOperation不存在

Answer 7

包的层次没有错，我把sql驱动换了，现在好用了