I have created a hibernate connection in iReport 3.7.5. At first i was having difficulty getting iReport to find the hibernate.cfg.xml file. Now that I have made the connection and gotten the test connection done, I have to comment out all my mapping resources and class-cache directories to make the connection work. the directory structures are all put in the code correctly.

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

<session-factory name="SessionFactory">

<property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
<property name="connection.url">jdbc:jtds:sqlserver://199.99.99.99/HELP99</property>
<property name="connection.username">HELP99</property>
<property name="connection.password">HELP99</property>
<property name="default_schema">dbo</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property> <!-- ADDED DIALECT -->


<mapping resource="com/help/hibernate/AbsenceEntitlement.hbm.xml"/>
<mapping resource="com/help/hibernate/AbsenceEntry.hbm.xml"/>


<class-cache class="com.help.hibernate.AbsenceEntitlement" usage="read-only"/>
<class-cache class="com.help.hibernate.AbsenceEntry" usage="read-only"/>

</session-factory>

</hibernate-configuration>

when i connect the hibernate database i get the error "class AbsenceEntitlement not found while looking for property: personRef" personRef is a one to many relationship with a few tables!

What could be causing the error???