We have tables that could be changed by the application, eg. the application could add columns to a table.

Is it possible to use a dynamic model to retrieve results from such a table?

Eg.

<class entity-name="TestTable">

<id name="id"
type="long"
column="ID">
<generator class="sequence" />
</id>

<!-- Do I have to specify all the properties here? -->
<property name="route"
column="route"
type="int" />
</class>

Thank you.

Hibernate version: 3.0

Name and version of the database you are using: MySQL-3.23.38

Take a look at dynamic-class and dynamic-component (not well documented but probably usefull)

Could you please give me an example, or point me to documentation about it?