Mapping of default columns of each table

tigerduck · **Joined:** Thu Oct 14, 2004 11:53 am **Posts:** 5

Hi,

i am using the table-per-concrete-class approach. each table contains four columns to log creation/change informations

Code:

<property name="createTime" column="CRTDAT"/>
<property name="createUser" column="CRTUSR"/>
<property name="changeTime" column="CHGDAT"/>
<property name="changeUser" column="CHGUSR"/>

i wonder if it is possible to extract these mappings, so not each class must contain these four lines.

Tickerduck

zzyborg · **Posted:** Fri Feb 10, 2006 1:06 am

i think its a matter of simple inheritemce . why dont u put these common fields on top of your inheritence hierarchy :)

tigerduck · **Joined:** Thu Oct 14, 2004 11:53 am **Posts:** 5

hi, no dont think so. the common attributes (id, time,..) are stored in a superclass but this superclass is not persited. maybe this approach is wrong..

tigerduck

zzyborg · **Posted:** Fri Feb 10, 2006 4:13 am

as far as i know , table per concrete class makes some data redundant . im not sure if there any solution that way .
why not go for a table per subclass