Hi,

I have a single POJO class called 'User' that is mapped to two tables (USERS and USER_ROLES)

When I invoke session.save(user) it gives the following error:

net.sf.hibernate.MappingException: duplicate import: User
at net.sf.hibernate.cfg.Mappings.addImport(Mappings.java:85)
at net.sf.hibernate.cfg.Binder.bindClass(Binder.java:126)
at net.sf.hibernate.cfg.Binder.bindRootClass(Binder.java:221)
at net.sf.hibernate.cfg.Binder.bindRoot(Binder.java:1243)
at net.sf.hibernate.cfg.Configuration.add(Configuration.java:249)
at net.sf.hibernate.cfg.Configuration.addInputStream(Configuration.java:285)

Is there a specific way to define the *.hbm.xml files when the same bean is mapped to more than one table.

I have defined two hbm.xml files one for user table and one for role table and both refer to, obviously, the same POJO class.

//user.hbm.xml
<hibernate-mapping package="com.proj.beans">
<class name="User" table="USERS">
<id name="userId" column="USERNAME">
<generator class="assigned" />
</id>
<property name="password" column="PASSWORD"/>
<property name="repId" column="SALESREPID"/>
</class>
</hibernate-mapping>

//userrole.hbm.xml
<hibernate-mapping package="com.proj.beans">
<class name="User" table="USER_ROLES">
<id name="userId" column="USERNAME">
<generator class="assigned"/>
</id>
<property name="roleName" column="ROLENAME"/>
</class>
</hibernate-mapping>

and I do the following in my configuaration:

cfg.addInputStream(this.getClass().
getClassLoader().getResourceAsStream("User.hbm.xml"));

cfg.addInputStream(this.getClass().
getClassLoader().getResourceAsStream("UserRole.hbm.xml"));

Any help will be much appreciated.

Thanks,
Jeelani

In Hibernate 2.1 you will need two session factories to do this.

Thanks Gavin. But I want both to be part of same transaction. If I use two Session Factories, how to make them part of same transaction? Do I need to go for XA* ?

Jeelani

You could use openSession(Connection)

Creating two connections just for taking to two tables of same Database is not convincing!

Anyways, Thanks a lot Gavin for the quick response!

Thanks,
Jeelani

???!


I just told you a way to do it without two connections!

My bad! Sorry.

Jeelani

I am able to fix it using openSession(Connection). This requires creating two SessionFactories and a session object from each factory using the same Connection. And set AutoCommit on Connection to false and finally once both transactions are successful, do Connection.commit();

Thanks Gavin for the help!
Jeelani