hibernate 单向多对一 问题，请高手指教

Question

USER是关键字吧 换个表名看下

Answer 1

User.hbm.xml
<hibernate-mapping>
    <class name="org.vo.User" table="user" catalog="m2o">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="native" />
        </id>
        <property name="name" type="java.lang.String">
            <column name="name" length="100" not-null="true" />
        </property>
        <many-to-one 
        name="room"
        class="org.vo.Room"
        cascade="all"
        outer-join="true"
        >
<column name="room_id" length="100" /></many-to-one>
    </class>
</hibernate-mapping>

Answer 2

User.hbm.xml
<hibernate-mapping>
    <class name="org.vo.User" table="user" catalog="m2o">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="native" />
        </id>
        <property name="name" type="java.lang.String">
            <column name="name" length="100" not-null="true" />
        </property>
        <many-to-one 
        name="room"
        class="org.vo.Room"
        column="id" 
        cascade="all"
        outer-join="true"
        />
    </class>
</hibernate-mapping>

Answer 3

我觉得也是USER是数据库的关键字

Answer 4

<hibernate-mapping>
    <class name="org.vo.User" table="user">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="native" />
        </id>
        <property name="name" type="java.lang.String">
            <column name="name" length="100" not-null="true" />
        </property>
        <many-to-one 
        name="room"
        class="org.vo.Room"
        column="room_id"
        cascade="all"
        outer-join="true"
        fetch="select" 
        lazy="false"
/>
    </class>
</hibernate-mapping>
 fetch="select" 
 lazy="false" 加上这两个 看看是不是延迟加载的问题

Answer 5

字段名不要和数据库的关键字相同，建议将user字段改名