Hibernate Version: 2.1

SITUATION: I need mapping and/or query ideas for the following scenario.

DB TABLES:
------------------------------------

Product (product_id text)

ProductName (
product_name_id int
product_id int
locale text
)

DESIRED OBJECT:
------------------------------------
class Product {
private ... productID;
private ... productName; // the name for a given locale

... getters /setters ...
}


MAPPING:
------------------------------------
How should I map the productName field within the Product class mapping so that it will only contain the name for the given locale?



If I were to do this outside of the hibernate api, I would write a query like:

...

ps = prepareStatement("
SELECT p.prodctID, pn.productName
FROM product p
INNER JOIN productName pn ON p.productID = pn.productID
WHERE p.productID = ?
AND pn.locale = ?
");

ps.setInt( 123 );
ps.setLocale( "xyz" );
ps.execute();
...

new Product( resultSet.getInt("productId", resultSet.getInt("productName"));


Any ideas would be much appreciated!

Thanks,

Tim

create an updatable view and map it like any other class?

Apparently the ability to do this will be in the next version (2.2) of Hibernate.

See Gavin's post on this thread:
http://forum.hibernate.org/viewtopic.php?t=929150

Thanks. I've come to the realization (and I hope it's the correct realization) that I will let my application view determine which locale should be displayed. I plan to pull the data from the database using Hibernate in a 1-to-many relationship and then simply grab the right object based on the current locale of the user within the app.

I appreciate the feedback!

Thanks,
Tim