I'm sure this is simple, but I keep going round and round on this. I have a very simple, legacy relationship




When I query for a clients object, I don't want the dms_type ID. I want the the client object to contain the DMS name. I've tried many different mapping configurations. THe one that get's me the closest is this one:



And



When I run my tests, I see hibernate is trying to select all clients that have a clients.dms_type of some value. What I really want to happen is to have hibernate select all the dmsTypes (there will be only one) that have a crm_type.id of some value. Can someone point out what I'm doing wrong?

Hibernate version: version 3.0.5, 25 May 2005


Name and version of the database you are using: postgreSQL 7.4

The generated SQL (show_sql=true): select clients0_.id as id0_, clients0_.name as name70_0_, clients0_.active as active70_0_, clients0_.internal as internal70_0_, clients0_.addr1 as addr5_70_0_, clients0_.addr2 as addr6_70_0_, clients0_.city as city70_0_, clients0_.state as state70_0_, clients0_.zip as zip70_0_, clients0_.phone as phone70_0_, clients0_.timezone as timezone70_0_, clients0_.dms_type as dms12_70_0_ from clients clients0_ where clients0_.dms_type=?

Well, I think I have it. I took the reverse mapping:

[code] <one-to-one name="client" class="Clients" property-ref="dms"/> [/code

Out of the DmsTypes definition. Now when I run tests I see that Hiberate is returning the string along with the other values.

To achieve the above, best solution is to use formula



if you want to use many-to-one, it can be done as...
(map dms_type column using many-to-one)

with

(There is no need to reverse map the many-to-one relationship.)

Note: I havent' tested these. So, there may need to be some alterations.