This seems like it should be simple, so it's quite possible I just "don't get it".

I have a Project object that has a statusId column. This works for most of my CRUD situations. However, when searching and displaying results, I wan't to show the text representation of statusId, which I have as a statusDesc getter/setter.

It seems like I should be able to say "Hibernate, get me the statusDesc column's value from the project_status table". What's the best way to go about doing this?

2ndly, is it possible to map this with XDoclet?

In some of my scenarios like this I personally just threw it onto my object and mapped it as a many-to-one when it wasn't internationalized and when it was internationalized I mapped it as many-to-many or one-to-many as appropriate.

In the case of rendering a view with many results, you could just load all of the statuses independently and pick the right one for each record you are showing as you render it.

e.g. 1


e.g. 2


Or something like that.

As for X-Doclet, I don't use it but this seems pretty simple so I don't see why it wouldn't be possible.

try this out. (i'm assuming statusid is an int).

use a PersistentEnum for the statusid, map it to a class called Status.

when you start up your app, in the initialization, create a List of all the Status's with the data from your product_status table.

in the fromInt method, return one of the Status's from the List you created.

then in your Project object, have it return Status objects instead of ints. now you can have multiple getters in the Status object to get either the id or the text description.

you can also override toString(), so in your JSP or whatever, it'll print out the text description instead of the id.

hope this helps.

--alex

I don't think either of these solutions will help in my situation. I want to use the Criteria/Expression API to search by a status's text description when a user wants to search on a status field. So far, the only way I think I can do it is to select all records in a table (and do an outer join with the status table) and then do a match, but that's a pain when the Expression API is so simple.

You can use the the Criteria API to search based on the description if you mapped it as the first way I suggested.

In your criteria you can then do the following:


This will give you back all of the instances of YourClass that have a status description where the description String == what your users are searching for.

I know this works because I've done it in my project.

Awesome David - thanks for this info. I'll try this when I get home tonight.

David - you solution worked, I did have to change to using a "ProjectStatus" object which represents the project_status table. Then I added a simple getter for getStatusDesc() that returns projectStatus.getStatusDesc(). It's too bad I can't just set the statusDesc field as a String, but I can live with this solution. Here's the XDoclet markup for it.

/**
* @return String
* @hibernate.many-to-one class="com.centres.redd.persistence.ProjectStatus"
* insert="false" update="false" cascade="none" column="status_id"
* outer-join="true"
*/
public ProjectStatus getProjectStatus() {
return projectStatus;
}

David - the following line doesn't even compile - did you have something else in mind:
[/code]