Mapping Exception

[kranthi chamarthi]

I am trying to do a many-to-many association using hibernate. I am having an
EVENT table and PERSON table. I am trying to get many-to-many association between these two tables using a junction table PERSON_EVENT. Following is the
mapping xml

    
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="Person" table="PERSON">
<id name="id" column="PERSON_ID">
<generator class="increment"/>
</id>
<property name="age"/>
<property name="firstName" column="FirstName"/>
<property name="lastName" column="LastName"/>
<set name="events" table="PERSON_EVENTS">
<key column="PERSON_ID"/>
<many-to-many column="EVENT_ID" class="EVENT"/>
</set>
</class>
</hibernate-mapping>

Now when i tried to run the program i am getting the following exception
org.hibernate.MappingException: An association from the table PERSON_EVENTS refers to an unmapped class: EVENT

Can anyone suggest me how to solve this.

[Paul Sturrock]

You probably don't have your EVENT mapping listed in your configuration. If you are using hibernate.cfg.xml have you included the event mapping?

[kranthi chamarthi]

Yeah i included the Event mapping in my hibernate.cfg.xml
Follwing is the configuration xml

<hibernate-configuration>
<session-factory>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost/example</property>
<property name="connection.username">root</property>
<property name="connection.password">mysql</property>
<property name="connection.pool_size">1</property>
<property name="show_sql">true</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<!--<property name="hbm2ddl.auto">create</property>-->
<mapping resource="event.hbm.xml"/>
<mapping resource="person.hbm.xml"/>
</session-factory>
</hibernate-configuration>   
 

and following is the event hbm xml

<hibernate-mapping>
<class name="Event" table="EVENTS">
        <id name="id" column="EVENT_ID">
            <generator class="increment"/>
        </id>
        <property name="date" type="timestamp" column="EVENT_DATE"/>
        <property name="title"/>
    </class>
 
</hibernate-mapping>

[Paul Sturrock]

You included a mapped resource called "Event". Your mapping from Person is to a mapped resource called EVENT.

Remember, Java is case-sensitive.

[kranthi chamarthi]

You are right Paul...Thank you very much.

[Ajay Luthria]

Paul Sturrock wrote:You included a mapped resource called "Event". Your mapping from Person is to a mapped resource called EVENT.

Remember, Java is case-sensitive.

Hi Paul,
I am having the same problem and after reading your reply tried to solve it but comes up with the error:
n association from the table PERSON_EVENT refers to an unmapped class: Event

<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost/test</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">bhuru</property>
<property name="hibernate.connection.pool_size">10</property>
<property name="show_sql">true</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.hbm2ddl.auto">update</property>

<!-- Mapping files -->
<mapping resource="Event.hbm.xml"/>
<mapping resource="Person.hbm.xml"/>


</session-factory>
</hibernate-configuration>

Person.hbm.xml
------------------
<hibernate-mapping>
<class name="Person" table="PERSON">

<id name="id" column="PERSON_ID">
<generator class="native"/>
</id>

<property name="firstName"/>

<set name="events" table="PERSON_EVENT">
<key column="PERSON_ID"/>
<many-to-many column="EVENT_ID" class="Event"/>
</set>

</class>
</hibernate-mapping>

Event.hbm.xml
------------------

<hibernate-mapping>


<class name="hibernate.Event" table="EVENT">

<id name="id" column="EVENT_ID">
<generator class="native"/>
</id>

<property name="date" type="timestamp" column="EVENT_DATE"/>
<property name="title"/>





</class>


</hibernate-mapping>

I would genuinely appreciate any help.