Hello All,
I have two database tables which are shown below:


TABLE 1 ~ maps to class1
postal code (PK)
location object id (FK)
.........
........
.........

TABLE2 ~ maps to class2
location object id (PK)
...........
...........
..........

table 1 has one to one relationship with table 2 and table 2 has one to many relation ship with table 1.

my config file for an entity corresponding to table 1 looks like the following:

---------------------------------------------------------------------------------
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>
<class name="com.abc.managed.xyz.entity.Class1" table="Table1">
<id name="postalCode" column="POSTAL_CODE" type="String" unsaved-value="null" >
<generator class="assigned"/>
</id>
<property name="twcLocationId" column="TWC_LOCATION_ID" type="string" length="128" not-null="false"/>
<property name="lastModifyDate" column="LAST_MODIFY_DATE" type="date" not-null="false"/>
<one-to-one name="location" column="LOCATION_OBJECTID" class="com.abc.managed.xyz.entity.Class2" />
</class>
</hibernate-mapping>
---------------------------------------------------------------------------------

when I run mu code , I get an exception which i sshown below:
P.S -- last line of the exception trace says "columnn ame nust be added to element one-to-one but I already have column name added".

Any help is appreciated ...Thanks

--------------------------------------------------------------------------
DAOSession :: Can't Initialize Hibernate Session
net.sf.hibernate.MappingException: Error reading resource: com/abc/managed/xyz/entity/Class1.hbm.xml
at net.sf.hibernate.cfg.Configuration.addResource(Configuration.java:318)
at net.sf.hibernate.cfg.Configuration.doConfigure(Configuration.java:976)
at net.sf.hibernate.cfg.Configuration.doConfigure(Configuration.java:928)
at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:856)
at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:842)
at com.abc.managed.xyz.database.hibernate.DAOSession.init(DAOSession.java:41)
at com.xyz.managed.abc.database.hibernate.DAOSession.getDAOSessionInstance(DAOSession.java:108)
at com.xyz.managed.abc.database.hibernate.DataAccessObject.retrieveObjects(DataAccessObject.java:211)
at com.xyz.managed.abc.database.hibernate.TestingJunction.testMyCode(TestingJunction.java:78)
at com.xyz.managed.abc.database.hibernate.TestingJunction.main(TestingJunction.java:30)
Caused by: net.sf.hibernate.MappingException: invalid mapping
at net.sf.hibernate.cfg.Configuration.addInputStream(Configuration.java:284)
at net.sf.hibernate.cfg.Configuration.addResource(Configuration.java:315)
... 9 more
Caused by: org.xml.sax.SAXParseException: Attribute "column" must be declared for element type "one-to-one".


--------------------------------------------------------------------------

The messages says that <one-to-one> has _no_ column name, but you added one. Please read the reference documentation for the correct usage of one-to-one (you probably should also try to use a <many-to-one> in your case).