associations using join says "table or view does not ex

veerjas · **Joined:** Mon Jul 21, 2008 5:22 am **Posts:** 1

Hi,

im doing associations using joins. i have a join table in DB PersonAddress.

and the mapping is here

Code:

<?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="personId" column="personId">
         <generator class="assigned"/>
      </id>
      <join  table="personaddress" >
         <key column="personId" unique="true"/>
         <many-to-one name="address" column="addressId" not-null="true" cascade="save-update"/>
      </join>
   </class>
   
   <class name="Address" table="address">
      <id name = "addressId" column="addressId">
           <generator class="assigned"/>
       </id>
   </class>
   
</hibernate-mapping>

when i call the save(person) it say "table or view does not exist" and table is not there in the schema. but it is there before i execute the same program

Thanks

Cameron McKenzie · **Posted:** Mon Jul 21, 2008 10:41 pm

Which table does it complain does not exist?

Devendra · **Joined:** Thu Jul 26, 2007 8:25 am **Posts:** 6

Are you using 'hibernate.hbm2ddl.auto' property in configuration file ?