Hi,

Does hibernate support the ability to map one field to another field within the domain model and allow HQL queires to use the former.

Use Case for this would be where we have a huge set of HQL queries that use the current domain model.Non-trivial changes are made to that model.The large set of queries prevent us doing this in one go.We need to be abe to evolve the changes.We would also have third parties that would have written queries against the old model.

e.g.

class Account{
private String accountNumber
private String IBAN
}

we want to change this to

class Account{
private Set<AccountKey> keys
}

class AccountKey{
String accountId
KeyTypeEnum idType
}

Could Hibernate support the ability to map Account.accountNumber to Account.keys.acountId where idType='Domestic'

Regards,
Phil

Try creating a subclasses of account, using idType as your "discriminator" column. Each subclass can be mapped differently.

Hi,
Thanks for the reply ,

Unfortunatly the Enum idType is not a closed enum.

Also I'm not clear on how this would allow existing HQL queries to run unchanged.

Basically I'd like the legacy HQL

select Account where acountNumber =:number

to be translated by Hibernate to something along the lines

select Account where keys.idType="'Domestic' and keys.accountId = :number

Ideally the legacy field accountNumber could be mapped to an expression (defined in the hibernate mapping ) which at runtimne is evaluated.

Regards
Phil