I want to have a 'Customer' class that has a 'getCountryName()' property.

Basically, I have a 'Customer' table, a 'Country' table, and I can get the country name doing customer.getCountry().getName(), but I want to be able to write the following query:

"from Customer c where c.countryname = 'USA'"

so I need to map the country.Name field to customer.countryName in the mapping file, and I don't find the way to do it.

Thanks,

Peter.

Why would you not write:

Is not a 'real world case'. I'm trying to know if I can change my schema from being something like

Customer:
Id
CountryName

to

Customer
Id
CountryId

Country
Id
Name

and hide that change in the mapping file.

You can do this sort of thing with the formula attribute of the property element.

A couple of gotchas though:
-Your rdbms needs to support subselects
- the property will be read-only

I investigated this option but couldn't use it because MySQL 4.0 does not support subselects.

search the forum for "formula subselect" for more info.

OK, does anybody know if supporting this is in the hibernate roadmap?

Doing a subselect when you can do a simple join is not something I want to do as a general solution, even if I can apply it when there are not a lot of records in the tables involved.

This appears to be slated for hibernate3: http://www.hibernate.org/200.html