Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.0

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:MySQL 3.1.8

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

In the Hibernate documentation it is implied that a table will be mapped to by only one class. Is it possible to have one table mapped to by more than one class? If so are there any locking implications?

Yep, can map a table to more than one class using entity-name.

example

<class name="Foo" entity-name="Foo" table="FOO">
<id name="id"/>
<property name="name"/>
<property name="notes"/>
</class>

<class name="Foo" entity-name="FooSummary">
<id name="id"/>
<property name="name"/>
</class>

Note that for relationships you will need to specify entity-name in addition to class name.

This is simplified mapping from our current project it is working just fine. About locking, so far we had no issues, problem or any kind of restrictions and etc ....

Map1:



Map2:


We used such an approach in few areas of our app. Actually everywhere where that was used one class was user for read-only data other for all of the rest. We have some cases where we had implemented more then two classes mapped on the same table for different buisiness logic to improve performance. Be careful to use that it can cause code maintenance issues later.

Be carefull with last mapping. There are some problems if you try to save both objects with same id in one transaction using merge().

As I mentioned above we are using second class only in read-only mode.

Then you should set mutable="false".